SYSTEM$GET_TAG_ON_CURRENT_COLUMN¶

Returns the tag string value assigned to the column based upon the specified tag or NULL if a tag is not assigned to the specified column.

Use this function in the masking policy conditions.

Syntax¶

SYSTEM$GET_TAG_ON_CURRENT_COLUMN( '<tag_name>' )

Copy

'tag_name'

Identifier for the tag as a string.

For example, if the tag is named cost_center use 'cost_center' as the argument.

Currently, this function can only be used in a masking policy condition to dynamically evaluate the tag string value set on a column.

Snowflake returns an error while using the function in either a SELECT query, a row access policy, a view, or a user-defined function (UDF).
Note that this function applies to all table-like objects (e.g. views).
The tag must exist when calling this system function; otherwise, Snowflake returns the following error message:
```
Tag '<tag_name>' does not exist or not authorized.
```
Copy