Displays information about the datasets in your account at either the schema or database level.
SHOW VERSIONS [ LIKE '<pattern>' ] IN DATASET <dataset_name> [ LIMIT <rows>]
Copy
Parameters¶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.
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.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4