Horizon Catalog: Tags, Classification & Data Quality
Snowflake · Security & Governance
Theory
Snowflake Horizon Catalog is the built-in catalog for discovering, governing and connecting data inside and outside Snowflake. In Snowsight its pages sit under the Horizon Catalog heading: Catalog (Explorer, Internal Marketplace), Data sharing, and Governance & security. Governance features include object tags, automatic sensitive data classification, masking and row access policies, tag-based masking, access history, column-level lineage, data quality checks and the Trust Center.
A typical setup: create a tag such as pii, attach a masking policy to the tag, and every column tagged pii is masked automatically. Data metric functions such as SNOWFLAKE.CORE.NULL_COUNT then run on a schedule to watch for quality problems like missing emails.
Why we use it
As data grows, setting policies one column at a time and checking quality by hand does not scale. Tags, classification and scheduled quality checks let governance follow the data automatically and give auditors a clear record of who accessed what.
When to use it
Use tags and tag-based masking once you have many sensitive columns, classification to find them, and data metric functions on tables that feed reports. Tag-based masking and data quality monitoring need Enterprise edition; small setups can start with direct masking policies.
How it works
- New tables land in the curated schema
- Classification or a data steward identifies sensitive columns
- Tag those columns, for example pii = 'email'
- Does the tag have a masking policy attached? Yes: Columns are masked for unauthorised roles. No: Attach a policy to the tag.
- Schedule data metric functions on key tables
- Review lineage, access history and quality results
Example
CREATE TAG governance.tags.pii;
ALTER TAG governance.tags.pii SET MASKING POLICY email_mask;
ALTER TABLE customers MODIFY COLUMN email
SET TAG governance.tags.pii = 'email';
ALTER TABLE customers SET DATA_METRIC_SCHEDULE = '60 MINUTE';
ALTER TABLE customers ADD DATA METRIC FUNCTION SNOWFLAKE.CORE.NULL_COUNT ON (email);Key points
- Horizon Catalog groups Catalog, Data sharing and Governance & security in Snowsight
- A masking policy set on a tag protects every column with that tag
- Sensitive data classification can discover and tag columns automatically
- Data metric functions run on a DATA_METRIC_SCHEDULE set on the table
- Tag-based masking and data quality monitoring need Enterprise edition
- ACCESS_HISTORY in ACCOUNT_USAGE shows who read or changed which columns