SHOW VERSIONS IN DATASET¶

Displays information about the datasets in your account at either the schema or database level.

Syntax¶

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

Copy

IN DATASET dataset_name: Name of dataset for which versions are displayed.
LIKE pattern: Restricts the list of returned datasets to those matching the specified pattern. Matching is case-insensitive.
LIMIT num: Limits the maximum number of rows returned.

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

Privilege	Object	Notes
OWNERSHIP or USAGE	Dataset	Provides the privilege to show the dataset versions within the account.

The USAGE privilege on the parent database and schema are required to perform operations on any object in a 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.

Regarding metadata:

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.