Assign Tag

The Assign Tag component lets you assign existing tags to Snowflake objects, enabling you to better track object usage within your Snowflake account.

Note

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
Pipe
Procedure
Stage
Stream
Table
Task
View

Properties

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.

Tag lineage

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.