DESCRIBE LISTING¶
描述 列表 中的列。
DESCRIBE 可以缩写为 DESC。
语法¶
{ DESC | DESCRIBE } LISTING <name> [ REVISION = { DRAFT | PUBLISHED } ]
参数¶
name指定要描述的列表的标识符，该标识符在创建列表时指定。如果标识符包含空格或特殊字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。
请参阅 SHOW LISTINGS 以了解列表详细信息（包括列表 名称）。
REVISION = { DRAFT | PUBLISHED }指定要显示的修订版。
例如，如果您有已发布列表的草稿，则可以指定要显示的草稿或已发布版本。
- 有效值:
DRAFT：描述列表的草稿版本。PUBLISHED：描述列表的已发布版本。
- 默认值:
PUBLISHED
使用说明¶
要 DESCRIBE 列表，您必须使用对列表具有 USAGE、MODIFY 或 OWNERSHIP 权限之一的角色。
若要对此命令的输出进行后处理，可以使用 RESULT_SCAN 函数，该函数会将输出视为可查询的表。
示例¶
描述名为 MYLISTING 的列表中的列：
DESC LISTING MYLISTING;
+------------------------------+---------------------+------------------+---------------------+--------------------------------------+--------------------------------------+--------------------------------------+----------------------------------------------------------------+----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------+---------------------+------------------+--------------------+-----------------+---------------+---------------------+-------------+----------------------+-------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------+-------------------------+--------------------------------------------------+-----------------------------+----------------------+------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------------------------------------------------------------------------------+------------------+----------------------+----------------+-----------------------------------------------------------------------------------------------------------------+---------------------------------+
| global_name | name | owner | owner_role_type | created_on | updated_on | published_on | title | subtitle | description | target_accounts | is_monetized | is_application | is_targeted | state | revisions | comment | refresh_schedule | refresh_type | business_needs | usage_examples | listing_terms | profile | customized_contact_info | application_package | data_dictionary | regions | manifest_yaml | review_state | rejection_reason | categories | resources | unpublished_by_admin_reason |
+------------------------------+---------------------+------------------+---------------------+--------------------------------------+--------------------------------------+--------------------------------------+----------------------------------------------------------------+----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------+---------------------+------------------+--------------------+-----------------+---------------+---------------------+-------------+----------------------+-------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------+-------------------------+--------------------------------------------------+-----------------------------+----------------------+------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------------------------------------------------------------------------------+------------------+----------------------+----------------+-----------------------------------------------------------------------------------------------------------------+---------------------------------+
| GZ13Z1VEWNG | CDC_COVID_19_DATA | ACCOUNTADMIN | ROLE | 2023-12-01T13:01:13.367-08:00 | 2023-12-01T13:25:11.331-08:00 | 2023-12-01T13:25:11.331-08:00 | Understanding COVID-19: Explore the Latest Data from the CDC | Track cases, deaths, vaccination rates, and more | Get the most up-to-date information on the COVID-19 pandemic from the Centers for Disease Control and Prevention (CDC). | | false | false | false | PUBLISHED | DRAFT,PUBLISHED | | 60 MINUTE | FULL_DATABASE | [{""type"":""CUSTOM"",""name"":""Public Health Monitoring and Response"",""description"":""Monitor trends in cases, deaths, and other key metrics.""}] | [{""title"":""Identify potential outbreaks of COVID-19 in [country name] by tracking trends in confirmed cases" | {"type":"STANDARD"} | RAVENCLAW_9A314599_F644_4664_946B_4DE0B2169C28 | | | {""database"":""COVIDDATADB"",""objects"":[{""schema"":""PUBLIC"",""domain"":""TABLE"",""name"":""GLOBAL_COVID_STATISTICS""}]}" | ALL | title: "Understanding COVID-19: Explore the Latest Data from the CDC" . . . | | | HEALTH | "{""documentation"":""https://snowflake.com/doc"",""media"":""https://www.youtube.com/watch?v=AR88dZG-hwo""}" | |
+------------------------------+---------------------+------------------+---------------------+--------------------------------------+--------------------------------------+--------------------------------------+----------------------------------------------------------------+----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------+---------------------+------------------+--------------------+-----------------+---------------+---------------------+-------------+----------------------+-------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------+-------------------------+--------------------------------------------------+-----------------------------+----------------------+------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------------------------------------------------------------------------------+------------------+----------------------+----------------+-----------------------------------------------------------------------------------------------------------------+---------------------------------+