VOLUME_TAGS
Applies to: 
Databricks SQL Databricks Runtime 14.3 and above Unity Catalog only.
INFORMATION_SCHEMA.VOLUME_TAGS contains the volume tagging metadata within the catalog, or all volumes if owned by the SYSTEM catalog.
Information is displayed only for volumes the user has permission to interact with.
This relation is an extension to the SQL Standard Information Schema.
Definition
The VOLUME_TAGS relation contains the following fields:
| Name | Data type | Nullable | Description |
|---|---|---|---|
CATALOG_NAME |
STRING |
No | The catalog of the volume that a given tag applies to. |
SCHEMA_NAME |
STRING |
No | The schema of the volume that the tag applies to. |
VOLUME_NAME |
STRING |
No | The volume that the tag applies to. |
TAG_NAME |
STRING |
No | The name of the tag. |
TAG_VALUE |
STRING |
No | The value of the tag. |
Constraints
The following constraints apply to the VOLUME_TAGS relation:
| Class | Name | Column List | Description |
|---|---|---|---|
| Primary key | VOLUME_TAGS_PK |
CATALOG_NAME, SCHEMA_NAME, VOLUME_TAG, TAG_NAME, TAG_VALUE |
Unique identifier for a volume tag. |
| Foreign key | VOLUME_TAGS_SCHEMATA_FK |
CATALOG_NAME, SCHEMA_NAME |
References SCHEMATA |
| Foreign key | VOLUME_TAGS_VOLUMES_FK |
CATALOG_NAME, SCHEMA_NAME, VOLUME_NAME |
References VOLUMES |
| Foreign key | VOLUME_TAGS_CATALOGS_FK |
CATALOG_NAME |
References CATALOGS |
Example
> SELECT catalog_name, schema_name, volume_name, tag_name, tag_value
FROM information_schema.volume_tags;