VOLUME_TAGS

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 14.3 and above check marked yes 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;