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.

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.

> SELECT table_owner
    FROM information_schema.volumes
    WHERE volume_schema = 'my_schema'
      AND volume_name = 'my_volume';