Schema:

ACCOUNT_USAGE

TAGS View

This Account Usage view lists the tags in an account.

Columns

Column Name

Data Type

Description

TAG_ID

NUMBER

The local identifier of a tag.

TAG_NAME

TEXT

The name of a tag.

TAG_SCHEMA_ID

NUMBER

The local identifier of the tag schema.

TAG_SCHEMA

TEXT

The name of schema in which the tag exists.

TAG_DATABASE_ID

NUMBER

The local identifier of the database in which the tag exists.

TAG_DATABASE

TEXT

The name of the database in which the tag exists.

TAG_OWNER

TEXT

The name of the role that owns the tag.

TAG_COMMENT

TEXT

Comments for the tag, if any.

CREATED

TIMESTAMP_LTZ

Date and time when the tag was created.

LAST_ALTERED

TIMESTAMP_LTZ

Date and time when the tag was last updated.

DELETED

TIMESTAMP_LTZ

Date and time when the tag was dropped, or the date and time when its parents were dropped.

ALLOWED_VALUES

ARRAY

Specifies the possible string values that can be assigned to the tag when the tag is set on an object or NULL if the tag does not have any specified allowed values. For details, see Specifying Tag Values.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).

  • The view only displays objects for which the current role for the session has been granted access privileges.

Examples

Return the tag references for your Snowflake account:

select * from snowflake.account_usage.tags
order by tag_name;
Back to top