DESCRIBE WAREHOUSE

描述 虚拟仓库。例如，显示仓库的创建日期。

DESCRIBE 可以缩写为 DESC。

另请参阅：

ALTER WAREHOUSE、CREATE WAREHOUSE、DROP WAREHOUSE、SHOW WAREHOUSES

语法

DESC[RIBE] WAREHOUSE <name>
Copy

参数

name

指定要描述的仓库的 :doc:` 标识符 </sql-reference/identifiers>`。

使用说明

  • To post-process the output of this command, you can use the pipe operator (->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.

    The output column names for this command are generated in lowercase. If you consume a result set from this command with the pipe operator or the RESULT_SCAN function, use double-quoted identifiers for the column names in the query to ensure that they match the column names in the output that was scanned. For example, if the name of an output column is type, then specify "type" for the identifier.

示例

此示例演示了 DESCRIBE WAREHOUSE 命令：

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 |
+-------------------------------+---------------------+-----------+
语言: 中文