DESC VOLUME

Views detailed information about a Volume, including creator, creation time, storage path, connection name, and directory configuration.

Syntax


DESC VOLUME [schema_name.]<volume_name>;

DESCRIBE VOLUME and DESC VOLUME are equivalent.

Parameters

Parameter	Description
`schema_name`	Name of the owning schema; current schema is used if omitted
`volume_name`	Name of the Volume to view

Examples

View External Volume details:


DESC VOLUME my_oss_vol;

Sample output:


+------------------------+--------------------------------+
| info_name              | info_value                     |
+------------------------+--------------------------------+
| name                   | my_oss_vol                     |
| creator                | qiliang                        |
| created_time           | 2026-05-20 00:23:49.074        |
| last_modified_time     | 2026-05-20 00:23:49.074        |
| external               | true                           |
| url                    | oss://mcp-data-hangzhou/test/  |
| connection_name        | quick_start.oss_conn           |
| recursive              | true                           |
| directory_enabled      | true                           |
| directory_auto_refresh | true                           |
+------------------------+--------------------------------+

View Named Volume details:


DESC VOLUME my_named_vol;

View a Volume under a specific schema:


DESC VOLUME my_schema.my_oss_vol;

Output Field Descriptions

Field	Description
`name`	Volume name
`creator`	Creator username
`created_time`	Creation time
`last_modified_time`	Last modification time
`external`	Whether it is external storage (`true` means external storage mount, `false` means internal storage)
`url`	Object storage path (only has a value for External Volumes)
`connection_name`	Associated Storage Connection name (only has a value for External Volumes)
`recursive`	Whether to recursively scan subdirectories
`directory_enabled`	Whether the directory feature is enabled
`directory_auto_refresh`	Whether to automatically refresh file metadata

Required Privileges

Privilege	Description
`READ METADATA`	View Volume object metadata