Categories:

Warehouse & Resource Monitor DDL

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 <warehouse_name>

Parameters

warehouse_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;

DESCRIBE WAREHOUSE temporary_warehouse;

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