SHOW VOLUMES

Syntax


SHOW VOLUMES [IN schema_name] [LIKE 'pattern' | WHERE expr] [LIMIT num]

Parameters

LIKE pattern: Optional parameter for pattern matching and filtering by volume name. Supports case-insensitive matching using SQL wildcards % (matches any number of characters) and _ (matches a single character). Example: LIKE '%testing%'. Note: Cannot be used simultaneously with the WHERE clause.
IN schema_name: Optional parameter for specifying a particular schema name, listing all volumes under that schema.
WHERE expr: Optional parameter for filtering based on the fields displayed by the SHOW VOLUMES command, supporting precise filtering of results using expressions.

Display Fields

Field	Description
volume_name	Volume name
create_time	Volume creation time
external	Whether it is an external Volume
workspace_name	Workspace name to which the Volume belongs
url	Volume URL address
recursive_file_lookup	Whether recursive file lookup is enabled
connection	Volume connection information

Examples


SHOW VOLUMES;


SHOW VOLUMES WHERE volume_name = 'zettapark_csv';


SHOW VOLUMES WHERE external = true;


SHOW VOLUMES WHERE workspace_name = 'xxx';


SHOW VOLUMES WHERE recursive_file_lookup = false;

Query which volumes use xxx.storage_connection:


SHOW VOLUMES WHERE connection = 'xxx.storage_connection';

Description

This command is used to list all Volume information under the current schema, and supports filtering results based on specified conditions via the WHERE clause.