Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Databricks SQL Databricks Runtime 16.1 and above
Sets a tag on a catalog, schema, table, view, volume, or column.
To add tags to Unity Catalog securable objects, you must own the object or have all of the following privileges:
APPLY TAGon the objectUSE SCHEMAon the object's parent schemaUSE CATALOGon the object's parent catalog
If the tag is governed by a tag specific policy you also need ASSIGN permission on the tag policy
Syntax
SET TAG ON
{ CATALOG catalog_name |
COLUMN relation_name . column_name |
{ SCHEMA | DATABASE } schema_name |
TABLE relation_name |
VIEW relation_name |
VOLUME volume_name }
tag_key [ = tag_value ]
Parameters
CATALOG catalog_name
The name of the catalog to tag.
COLUMN relation_name . column_name
The qualified name of the column to tag.
relation_namemust identify a view or a table. Therelation_namemust not include a temporal specification or options specification.SCHEMA schema_name
The name of the schema to tag.
TABLE relation_name
The name of the table or view to tag. The name must not include a temporal specification or options specification.
VIEW relation_name
The name of the view to tag.
VOLUME volume_name
The name of the volume to tag.
tag_key
An identifier. If a tag assignment with the same key already exists and exception is raised.
tag_value
An optional identifier. If not specified, the tag assignment will be set as key-only.
Examples
> SET TAG ON CATALOG catalog `cost_center` = `hr`;
> UNSET TAG ON CATALOG catalog cost_center;
> SET TAG ON TABLE catalog.schema.table cost_center = hr;
> UNSET TAG ON TABLE catalog.schema.table cost_center;
> SET TAG ON COLUMN table.ssn pii;
> UNSET TAG ON COLUMN table.ssn pii;
> SELECT table_name, column_name FROM information_schema.column_tags
WHERE tag_name = 'pii' AND schema_name = 'default';
table_name column_name
---------- -----------
table ssn