SHOW VERSIONS IN DATASET

在架构或数据库级别显示有关账户中的数据集的信息。

See also:

SHOW DATASETS , ALTER DATASET, CREATE DATASET

语法

SHOW VERSIONS [ LIKE '<pattern>' ] IN DATASET <dataset_name>
  [ LIMIT <rows>]

参数

IN DATASET dataset_name

显示其版本的数据集的名称。

LIKE pattern

将返回的数据集列表限制为与指定模式匹配的数据集。匹配不区分大小写。

LIMIT num

限制返回的最大行数。

访问控制要求

A role used to execute this operation must have the following privileges at a minimum:

权限对象备注
OWNERSHIP 或 USAGE数据集提供在账户内显示数据集版本的权限。

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

使用说明

  • 关于元数据：

    Attention

    Customers should ensure that no personal data (other than for a User object), sensitive data, export-controlled data, or other regulated data is entered as metadata when using the Snowflake service. For more information, see Metadata fields in Snowflake.