The Assign Tag component lets you assign existing tags to Snowflake objects, enabling you to better track object usage within your Snowflake account.
- This component is available for Matillion ETL for Snowflake.
- This component is an enterprise feature. To learn more, read Editions if you're a Hub customer, otherwise, read Enterprise Mode (Marketplace Customers). :::
New to Snowflake object tagging? Read Object Tagging.
Tags empower your data stewards and administrators to monitor sensitive data with regard to compliance, discovery, security, and resource usage, all via a centralized or decentralized data governance management practice.
You must create tags within your Snowflake database. Read CREATE TAG to learn more.
Tags can be applied within a schema on the following objects:
- External table
- Materialized view
Name = string
A human-readable name for the component.
Database = drop-down
The Snowflake database. The special value, [Environment Default], will use the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.
Schema = drop-down
The Snowflake schema. The special value, [Environment Default], will use the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
Object Type = drop-down
The type of object to assign a tag to.
Object Name = drop-down
The name of the object you wish to assign a tag to.
Object Details = column editor
- Tag Name: Select a tag from the drop-down menu. Read CREATE TAG if you haven't created any tags yet.
- Tag Value: A string value. Must be unique for your Snowflake schema. Accepts variables.
From the Snowflake Object tagging documentation:
A tag is inherited based on the Snowflake securable object hierarchy. Snowflake recommends defining the tag keys as closely as possible to the securable object hierarchy in your Snowflake environment.
Tag inheritance means that if a tag is applied to a table, the tag also applies to the columns in that table. This behavior is referred to as tag lineage.