SHOW DATASETS¶

Displays information about the datasets in your account. You can show all datasets or use the IN subcommand to only display results at the schema or database level.

See also:: CREATE DATASET , ALTER DATASET

Syntax¶

SHOW DATASETS
  [ LIKE '<pattern>' ]
  [ IN { SCHEMA <schema_name> | DATABASE <db_name> | ACCOUNT } ]
  [ STARTS WITH '<name_string>' ]
  [ LIMIT <rows> [ FROM '<name_string>' ] ]

Copy

Optional parameters¶

LIKE pattern: Restricts the list of returned datasets to those matching the specified pattern.
IN SCHEMA <schema_name> | DATABASE <db_name> | ACCOUNT: Restricts the list of returned datasets to those in the specified schema or database within an account.
DATABASE db_name: Restricts the list of returned datasets to those in the specified database. If you specify a database without db_name and no database is in use, they keyword has no effect on the output.
SCHEMA schema_name: By default, returns records for the schema in use. You can also specify a schema_name.
STARTS WITH name_string: Uses the string that you specify to limit the datasets returned. The names of the datasets returned have the same beginning characters as the specified string.
LIMIT rows [ FROM name_string ]: Limits the number of returned datasets to the specified number of rows. The optional FROM clause specifies the starting point for the returned datasets.

Access control requirements¶

Privilege	Object	Notes
OWNERSHIP or USAGE	Schema	Provides the privilege to show the datasets within the account.

Examples¶

The following example shows two datasets in the PUBLIC schema:

SHOW DATASETS IN SCHEMA PUBLIC LIMIT 2;

Copy