SHOW VERSIONS IN DATASET¶

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

See also:

SHOW DATASETS , ALTER DATASET, CREATE DATASET

Syntax¶

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

Parameters¶

IN DATASET dataset_name

Name of dataset for which versions are displayed.

Optional parameters¶

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.

Access control requirements¶

Privilege

Object

Notes

OWNERSHIP or USAGE

Schema

Provides the privilege to show the dataset versions within the account.

Usage notes¶

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

Language: English