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.

For example, you can use the pipe operator or RESULT_SCAN function to select specific columns from the SHOW command output or filter the rows.

When you refer to the output columns, use double-quoted identifiers for the column names. For example, to select the output column type, specify SELECT "type".

You must use double-quoted identifiers because the output column names for SHOW commands are in lowercase. The double quotes ensure that the column names in the SELECT list or WHERE clause match the column names in the SHOW command output that was scanned.

输出¶

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

列	描述
`global_name`	列表的全局名称
`name`	创建列表时指定的名称。
`owner`	列表所有者。
`owner_role_type`	列表所有者角色类型。
`created_on`	列表的创建日期和时间。
`updated_on`	列表的上次更新日期和时间。
`published_on`	列表的上次发布日期和时间。
`title`	列表清单中指定的标题
`subtitle`	列表清单中指定的子标题
`description`	The listing description.
`listing_terms`	列表条款。
`state`	列表状态，以下之一： DRAFT PUBLISHED UNPUBLISHED
`share`	The share identifier for this listing.
`application_package`	与列表相关的应用程序包。
`business_needs`	列表满足的业务需求。
`usage_examples`	An example showing a query of the listing.
`data_attributes`	The listing's attributes, including the refresh rate, geographic coverage, and time range.
`categories`	列表类别。
`resources`	Listing resources, such as a documentation link.
`profile`	The provider's profile name.
`customized_contact_info`	提供商联系信息。
`data_dictionary`	列表元数据。
`data_preview`	Preview of the listing data.
`comment`	关联的注释（如果存在）。
`revisions`	修订状态，仅用于公开列表。
`target_accounts`	目标账户的逗号分隔列表。
`regions`	列表区域。
`refresh_schedule`	列表刷新频率（以分钟为单位）。
`refresh_type`	列表刷新类型。
`review_state`	列表审查状态。
`rejection_reason`	列表遭拒原因。
`unpublished_by_admin_reasons`	列表所有者未发布列表的原因。
`is_monetized`	收费标志。
`is_application`	Is application flag. If `true`, an application package is attached to the listing.
`is_targeted`	针对性标志。
`is_limited_trial`	Is limited trial flag.
`is_by_request`	Is by request flag.
`limited_trial_plan`	The plan associated with a limited trial listing.
`retired_on`	Date and time the listing was retired. Null if not retired.
`scheduled_drop_time`	Date and time the listing is scheduled to be dropped (no longer available to existing consumers). Null if not scheduled.
`manifest_yaml`	当 `REVISION` 为 `PUBLISHED` 时，表示整个已发布的清单；当 `REVISION` 为 `DRAFT` 时，表示整个已发布的清单（含草案修改）。
`distribution`	Distribution details, if present, such as `EXTERNAL`.
`is_mountless_queryable`	`true` If the listing can be queried without being mounted; `false` otherwise.
`organization_profile_name`	The associated organization profile name.
`uniform_listing_locator`	The uniform listing locator (ULL). For more information about ULLs, see 配置组织列表.
`trial_details`	Details associated with trial listings.
`approver_contact`	Approver contact information.
`support_contact`	Support contact information.
`live_version_uri`	Full uniform resource indictor (URI) of the live version of the listing, against which stage operations can be performed. NULL if no live version exists for the listing.
`last_committed_version_uri`	Full URI of the last committed version of the listing.
`last_committed_version_name`	System-generated name for the last committed version of the listing.
`last_committed_version_alias`	User-specified alias for the last committed version of the listing.
`published_version_uri`	Full URI of the current published version of the listing.
`published_version_name`	System-generated name of the published version of the listing.
`published_version_alias`	User-specified alias for the last published version of the listing.
`compliance_badges`	Compliance badges associated with this listing, if any.
`is_share`	Is share flag. If `true`, the listing was created based on a share.
`monetization_version`	Monetization model that the listing uses.
`request_approval_type`	Listing access request type. The access request type defines how discovery targets of a listing submit access requests to the listing approver. Any one of: `NULL` `REQUEST_AND_APPROVE_IN_SNOWFLAKE` 表示访问请求是在 Snowflake 环境中提交和批准的。 `REQUEST_AND_APPROVE_OUTSIDE_SNOWFLAKE` 表示提供商独立管理访问请求的提交和批准。外部列表的值始终为 `NULL`。
`monetization_display_order`	The order in which pricing plans and offers are displayed to consumers.
`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 设置统一列表定位器或列表名称.
`share_restrictions`	A flag that indicate whether share restrictions exist on external private listings.

示例¶

To describe the columns in a listing named MYLISTING, run the following command:

DESC LISTING MYLISTING;

Copy