Categories:

System Functions

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

Arguments

'tag_name'

Identifier for the tag as a string.

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

Usage Notes

  • 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

Examples

For a contextual example on how to use this function, see Example 2: Protect Column Data Based on the Column Tag String Value.