COLUMN_TAGS

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 13.3 LTS and above check marked yes Unity Catalog only.

INFORMATION_SCHEMA.COLUMN_TAGS contains the column tagging metadata within the table, or all columns if owned by the SYSTEM catalog.

Information is displayed only for columns the user has permission to interact with.

This relation is an extension to the SQL Standard Information Schema.

Definition

The COLUMN_TAGS relation contains the following.

Name

Data type

Nullable

Description

CATALOG_NAME

STRING

No

The catalog name that a given tag applies to.

SCHEMA_NAME

STRING

No

The schema that the tag applies to.

TABLE_NAME

STRING

No

The table that the tag applies to.

COLUMN_NAME

STRING

No

The column 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 constraint applies to the COLUMN_TAGS relation:

Class

Name

Column List

Description

Primary key

COLUMN_TAGS_PK

CATALOG_NAME, SCHEMA_NAME, TABLE_NAME, COLUMN_NAME, TAG_NAME, TAG_VALUE

Unique identifier for a column tag.

Foreign key

COLUMN_TAGS_COLUMNS_FK

CATALOG_NAME, SCHEMA_NAME, TABLE_NAME, COLUMN_NAME

References COLUMNS

Example 

> SELECT catalog_name, schema_name, table_name, column_name, tag_name, tag_value
    FROM information_schema.column_tags;