DESCRIBE WAREHOUSE¶

Describes the warehouse. For example, shows the date that the warehouse was created.

DESCRIBE can be abbreviated to DESC.

See also:: ALTER WAREHOUSE , CREATE WAREHOUSE, DROP WAREHOUSE , SHOW WAREHOUSES

Syntax¶

DESC[RIBE] WAREHOUSE <name>

Copy

Parameters¶

name: Specifies the identifier of the warehouse to describe.

Usage Notes¶

To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Examples¶

This demonstrates the DESCRIBE WAREHOUSE command:

CREATE WAREHOUSE temporary__warehouse WAREHOUSE_SIZE=XSMALL;

Copy

DESCRIBE WAREHOUSE temporary_warehouse;

Copy

+-------------------------------+---------------------+-----------+
| created_on                    | name                | kind      |
|-------------------------------+---------------------+-----------|
| 2022-06-23 00:00:00.000 -0700 | TEMPORARY_WAREHOUSE | WAREHOUSE |
+-------------------------------+---------------------+-----------+