VOLUMES
Applies to: Databricks SQL check marked yes Databricks Runtime 13.3 LTS and above Unity Catalog only
INFORMATION_SCHEMA.VOLUMES contains the object level metadata for volumes within the local catalog or all catalogs if owned by the SYSTEM
catalog.
The rows returned are limited to the volumes the user is privileged to interact with.
This is an extension to the SQL Standard Information Schema.
Definition
The VOLUMES
relation contains the following columns:
Name | Data type | Nullable | Description |
---|---|---|---|
VOLUME_CATALOG |
STRING |
No | Catalog that contains the volume. |
VOLUME_SCHEMA |
STRING |
No | Schema that contains the volume. |
VOLUME_NAME |
STRING |
No | Name of the volume. |
VOLUME_TYPE |
STRING |
No | One of 'MANAGED' , 'EXTERNAL' . |
VOLUME_OWNER |
STRING |
No | User or group (principal) currently owning the volume. |
COMMENT |
STRING |
Yes | An optional comment that describes the volume. |
CREATED |
TIMESTAMP |
No | Timestamp when the volume was created. |
CREATED_BY |
STRING |
No | Principal which created the volume. |
LAST_ALTERED |
TIMESTAMP |
No | Timestamp when the volume definition was last altered in any way. |
LAST_ALTERED_BY |
STRING |
No | Principal which last altered the volume. |
STORAGE_LOCATION |
STRING |
No | The storage location where the volume is created. |
Constraints
The following constraints apply to the VOLUMES
relation:
Class | Name | Column List | Description |
---|---|---|---|
Primary key | VOLUMES_PK |
VOLUME_CATALOG , VOLUME_SCHEMA , VOLUME_NAME |
Unique identifier for the volume. |
Foreign key | VOLUME_SCHEMATA_FK |
VOLUME_CATALOG , VOLUME_SCHEMA |
References SCHEMATA. |
Examples
> SELECT table_owner
FROM information_schema.volumes
WHERE volume_schema = 'my_schema'
AND volume_name = 'my_volume';