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

  1. New tables land in the curated schema
  2. Classification or a data steward identifies sensitive columns
  3. Tag those columns, for example pii = 'email'
  4. Does the tag have a masking policy attached? Yes: Columns are masked for unauthorised roles. No: Attach a policy to the tag.
  5. Schedule data metric functions on key tables
  6. 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

Snowflake topics

Snowflake Fundamentals

Warehouses & Performance

Staging & SnowSQL

Tables & Data Handling

Cloud Integrations

Storage & Optimization

Security & Governance

Views, Pipelines & Automation

Data Types & SQL Fundamentals

Semi-Structured Data Deep Dive

Advanced Features

Data Sharing & Collaboration

Cost Management & Monitoring

Databases, Schemas & Objects

Performance Deep Dive

Advanced Security & Governance

Stored Procedures & UDFs

Ecosystem & Integrations

SnowPro Certification Prep

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Mastering Snowflake

The modern data cloud, from architecture to SnowPro certification. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice Snowflake SQL Sharpen the SQL you use in Snowflake: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Snowflake  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Unlike the SQL and Python courses, Snowflake needs a real account — there's no in-browser engine for it. Click Copy above, then paste it into a free Snowflake trial (30 days, no card required) and run it in Snowsight.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic