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.

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;