Categories:

System functions (System Information)

SYSTEM$GET_TAG_ALLOWED_VALUES

Returns a comma-separated list of string values that can be set on a supported object, or NULL to indicate the tag key does not have any specified string values and accepts all possible string values.

See also:

Specify tag values , TAGS view

Syntax

SYSTEM$GET_TAG_ALLOWED_VALUES('<name>')
Copy

Arguments

name

The fully-qualified name of the tag key as a string.

Usage notes

  • The role that calls this function must have either the USAGE privilege on the parent database and schema of the tag or the global APPLY TAG on ACCOUNT permission.

  • Snowflake returns NULL when you pass the SNOWFLAKE.CORE.SEMANTIC_CATEGORY system tag as an argument in the function because there is not an allowed values constraint with this tag.

Examples

Query the allowed tag values for the tag key named cost_center, which resides in the database named governance and the schema named tags:

select system$get_tag_allowed_values('governance.tags.cost_center');
Copy
Language: English