Categories:

System functions

SYSTEM$GET_TAG

Returns the tag value associated with the specified Snowflake object or column. Returns NULL if a tag is not set on the specified Snowflake object or column.

Syntax

SYSTEM$GET_TAG( '<tag_name>' , '<obj_name>' , '<obj_domain>' )

Arguments

'tag_name'

The name of the tag as a string.

The name is the key in the key-value pair of the tag. For example, in the tag cost_center = 'sales', cost_center is the key-name of the tag. For this argument, use 'cost_center'.

'obj_name'

The name of the object as a string.

For example, if a table name is my_table, use 'my_table' as the name of the object.

To specify a column, use the format <table_name>.<column_name>. For example, my_table.revenue.

To identify a logical table, dimension, fact, or metric in a semantic view:

  • Use an exclamation mark (!) between the name of the semantic view and the name of the logical table.

  • Use a period (.) between the name of the logical table and the name of the dimension, fact, or metric.

  • For a derived metric, use a period (.) between the name of the semantic view and the name of the derived metric.

For example:

  • 'my_semantic_view!my_logical_table'

  • 'my_semantic_view!my_logical_table.my_dimension'

  • 'my_semantic_view!my_logical_table.my_fact'

  • 'my_semantic_view!my_logical_table.my_metric'

  • 'my_semantic_view.my_derived_metric'

For more information, see Object identifiers.

'object_domain'

Domain of the reference object, such as a table or view, if the tag association is on the object. For columns, the domain is COLUMN if the tag association is on a column.

Use one of the following values:

  • 'ACCOUNT'

  • 'ALERT'

  • 'BACKUP POLICY'

  • 'BACKUP SET'

  • 'COLUMN'

  • 'COMPUTE POOL'

  • 'CORTEX AGENT'

  • 'DATABASE'

  • 'DATABASE ROLE'

  • 'FAILOVER GROUP'

  • 'FUNCTION'

  • 'INTEGRATION'

  • 'INSTANCE'

  • 'NETWORK POLICY'

  • 'PROCEDURE'

  • 'REPLICATION GROUP'

  • 'ROLE'

  • 'SCHEMA'

  • 'SEMANTIC DIMENSION' (for dimensions in a semantic view)

  • 'SEMANTIC FACT' (for facts in a semantic view)

  • 'SEMANTIC METRIC' (for metrics in a semantic view)

  • 'SEMANTIC TABLE' (for logical tables in a semantic view)

  • 'SEMANTIC VIEW'

  • 'SHARE'

  • 'SNAPSHOT POLICY' (deprecated; prefer 'BACKUP POLICY')

  • 'SNAPSHOT SET' (deprecated; prefer 'BACKUP SET')

  • 'SNOWFLAKE INTELLIGENCE'

  • 'STAGE'

  • 'STREAM'

  • 'TABLE': Use this for all table-like objects such as views, materialized views, and external tables (except for semantic views).

  • 'TASK'

  • 'USER'

  • 'WAREHOUSE'

Usage notes

Examples

Returns NULL if a tag is not associated to the specified object:

select system$get_tag('cost_center', 'my_table', 'table');

+-----------------------------------------------------+
| SYSTEM$GET_TAG('COST_CENTER', 'MY_TABLE', 'TABLE')  |
+-----------------------------------------------------+
| NULL                                                |
+-----------------------------------------------------+

Returns the tag value for the specified table. The tag value is the string component of the key = 'value' pair in the tag:

select system$get_tag('cost_center', 'my_table', 'table');

-----------------------------------------------------+
| SYSTEM$GET_TAG('COST_CENTER', 'MY_TABLE', 'TABLE') |
+----------------------------------------------------+
| sales                                              |
+----------------------------------------------------+

Returns the tag value for the specified column:

select system$get_tag('fiscal_quarter', 'my_table.revenue', 'column');

+----------------------------------------------------------------+
| SYSTEM$GET_TAG('FISCAL_QUARTER', 'MY_TABLE.REVENUE', 'COLUMN') |
+----------------------------------------------------------------+
| Q1                                                             |
+----------------------------------------------------------------+