DESCRIBE LISTING

Describes the columns in a listing.

另请参阅：

CREATE LISTING、ALTER LISTING、SHOW LISTINGS、SHOW VERSIONS IN LISTING、DROP LISTING

语法

{ DESC | DESCRIBE } LISTING <name>  [ REVISION = { DRAFT | PUBLISHED } ]
Copy

参数

name

要描述的列表的标识符，该标识符在创建列表时指定。如果标识符包含空格或特殊字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。

请参阅 SHOW LISTINGS 以了解列表详细信息（包括列表 名称）。

REVISION = { DRAFT | PUBLISHED }

指定要显示的修订版。

例如，如果您有已发布列表的草稿，则可以指定要显示的草稿或已发布版本。

有效值:

  • DRAFT：描述列表的草稿版本。

  • PUBLISHED：描述列表的已发布版本。

默认值:

PUBLISHED

使用说明

  • You can describe a listing only if you use a role that has the USAGE, MODIFY, or OWNERSHIP privilege on the listing.

  • 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.

输出

命令输出在以下列中提供列表属性和元数据：

列

描述

global_name

列表的全局名称

name

创建列表时指定的名称。

owner

列表所有者。

owner_role_type

列表所有者角色类型。

created_on

列表的创建日期和时间。

updated_on

列表的上次更新日期和时间。

published_on

列表的上次发布日期和时间。

title

列表清单中指定的标题

subtitle

列表清单中指定的子标题

description

列表描述。

target_accounts

目标账户的逗号分隔列表。

is_monetized

收费标志。

is_application

应用程序标志。如果为 true，则表示一个应用程序包已附加到列表。

is_targeted

针对性标志。

state

列表状态，以下之一：

  • DRAFT

  • PUBLISHED

  • UNPUBLISHED

revisions

修订状态，仅用于公开列表。

comment

关联的注释（如果存在）。

refresh_schedule

列表刷新频率（以分钟为单位）。

refresh_type

列表刷新类型。

business_needs

列表满足的业务需求。

usage_examples

列表使用案例。

listing_terms

列表条款。

profile

列表清单中指定的提供商简介名称。

customized_contact_info

提供商联系信息。

application_package

与列表相关的应用程序包。

data_dictionary

列表元数据。

regions

列表区域。

manifest_yaml

当 REVISION 为 PUBLISHED 时，表示整个已发布的清单；当 REVISION 为 DRAFT 时，表示整个已发布的清单（含草案修改）。

review_state

列表审查状态。

rejection_reason

列表遭拒原因。

categories

列表类别。

resources

列表资源。

unpublished_by_admin_reasons

列表所有者未发布列表的原因。

request_approval_type

显示列表访问请求类型。 访问请求类型定义列表的发现目标如何向列表批准者提交访问请求。以下任何一个：

  • NULL

  • REQUEST_AND_APPROVE_IN_SNOWFLAKE 表示访问请求是在 Snowflake 环境中提交和批准的。

  • REQUEST_AND_APPROVE_OUTSIDE_SNOWFLAKE 表示提供商独立管理访问请求的提交和批准。外部列表的值始终为 NULL。

legacy_uniform_listing_locator

Specifies the legacy Uniform Listing Locator (ULL). If an existing organizational listing profile is updated to use a custom organization profile, this column includes the ULL associated with the previous default profile that continues to be valid.

If no profile updates have been made, this column is NULL.

For more information on ULLs, see 设置统一列表定位器或列表名称.

示例

描述名为 MYLISTING 的列表中的列：

DESC LISTING MYLISTING;
Copy
+------------------------------+---------------------+------------------+---------------------+--------------------------------------+--------------------------------------+--------------------------------------+----------------------------------------------------------------+----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------+---------------------+------------------+--------------------+-----------------+---------------+---------------------+-------------+----------------------+-------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------+-------------------------+--------------------------------------------------+-----------------------------+----------------------+------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------------------------------------------------------------------------------+------------------+----------------------+----------------+-----------------------------------------------------------------------------------------------------------------+---------------------------------+-----------------------+--------------------------------+
|   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   | request_approval_type | legacy_uniform_listing_locator |
+------------------------------+---------------------+------------------+---------------------+--------------------------------------+--------------------------------------+--------------------------------------+----------------------------------------------------------------+----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------+---------------------+------------------+--------------------+-----------------+---------------+---------------------+-------------+----------------------+-------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------+-------------------------+--------------------------------------------------+-----------------------------+----------------------+------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------------------------------------------------------------------------------+------------------+----------------------+----------------+-----------------------------------------------------------------------------------------------------------------+---------------------------------+-----------------------+--------------------------------+
|   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""}" |                                 | NULL                  | NULL                           |
+------------------------------+---------------------+------------------+---------------------+--------------------------------------+--------------------------------------+--------------------------------------+----------------------------------------------------------------+----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------+---------------------+------------------+--------------------+-----------------+---------------+---------------------+-------------+----------------------+-------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------+-------------------------+--------------------------------------------------+-----------------------------+----------------------+------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------------------------------------------------------------------------------+------------------+----------------------+----------------+-----------------------------------------------------------------------------------------------------------------+---------------------------------+-----------------------+--------------------------------+
语言: 中文