Is Snowflake Horizon Enough, or Do You Need a Dedicated Catalog?

When Snowflake Horizon is enough and when it is not: the edition gates, the coverage limits and a decision rule, every claim cited to Snowflake documentation.

By

Jatin S

Updated on

September 9, 2026

Key Takeaways

  • If every asset that would appear in an incident postmortem is a Snowflake object, Horizon is enough and you should stop reading. Ingestion lands in Snowflake, transformation runs in Snowflake, reporting reads Snowflake. In that shape a second catalog describes the same assets twice and adds cost without adding an answer.
  • Horizon is an Enterprise Edition product in practice, and the Horizon page never says so. Data lineage, external lineage, data quality monitoring, sensitive data classification, tag based masking and ACCESS_HISTORY each carry an Enterprise Edition requirement on their own documentation page. The edition applies to every credit the account burns, not just to governance.
  • "Inside or outside of Snowflake" has a precise documented meaning, and it is narrower than it sounds. It resolves to Apache Iceberg tables in an external Iceberg REST catalog, cloud object storage read through external tables, and lineage nodes pushed in over OpenLineage. A Postgres instance, a BI semantic layer or an ingestion tool does not become a governed Snowflake asset.
  • Snowflake does not enforce your primary keys, foreign keys or unique constraints on standard tables. The constraints reference lists all three as "Optional, not enforced". Only NOT NULL and CHECK are enforced. Any relationship a catalog draws from those declarations is a statement of intent, not a guarantee the engine has ever checked.
  • Native anomaly detection covers two metrics and is still a preview feature. ROW_COUNT and FRESHNESS are the only system data metric functions that support it. It needs at least two weeks of history before it activates and Snowflake recommends 60 days for high confidence.
  • The decision rule: count the systems that would appear in your last incident postmortem. If they are all Snowflake objects, keep the money. If more than one sits outside, Horizon is the warehouse half of the answer and something has to cover the other half.

Snowflake Horizon Catalog is good, it is bundled, and for a large number of teams it is the correct and final answer. That is not the conclusion most articles on this question reach, and it is the one the documentation supports whenever an estate genuinely runs on one platform.

The useful work is defining where it stops, precisely enough that you can put the boundary in a budget request. Two things decide that: which edition of Snowflake you are on, because most of the governance surface is gated behind Enterprise Edition, and how much of the estate you care about is actually a Snowflake object. Everything below is read from Snowflake documentation on 6 September 2026, and the exact pages are listed at the end so you can check any of it.

The short answer, by estate shape

Read this as a decision rule rather than a verdict. The answer changes with the shape of the estate, not with the size of the company.

Your situationWhat to doWhy
Everything you govern is a Snowflake object and you are already on Enterprise EditionUse Horizon. Buy nothing.The metadata is already in the account, the governance features are already paid for, and a second catalog describes the same assets a second time.
Everything you govern is a Snowflake object but you are on Standard EditionPrice the Enterprise Edition upgrade first, before you price a catalogLineage, quality monitoring, classification, tag based masking and access history all require Enterprise Edition. The upgrade may cost less than a platform, or it may not, but it is the comparison that matters.
Snowflake is the center of the estate but a lake, a Postgres instance or a BI layer is in scopeUse Horizon inside Snowflake and add a layer that covers the restHorizon governs Snowflake objects and Iceberg tables in an external REST catalog. Other systems arrive only as OpenLineage nodes, and only if something pushes them in.
You need to know that a pipeline broke, not that a rule failedAdd observability, whichever catalog you useNative anomaly detection covers volume and freshness on two system metrics. Everything else is a threshold you set yourself and a notification you configure yourself.
You are regulated and have to show one control set across the whole estateA per platform governance layer will not close the auditEvidence assembled separately for each platform is the thing auditors ask you to reconcile. One control set across systems is a different product from a good warehouse catalog.

What Snowflake Horizon Catalog actually includes

Start with what Snowflake says it is, because the framing matters. The Horizon Catalog documentation page opens like this:

Horizon Catalog is the agentic catalog for all your data, whether it is inside or outside of Snowflake. It is open, interoperable, and compatible with any engine, any data, and any cloud.

The page then groups the product into four areas. Discovery and connection covers Apache Iceberg tables, the Iceberg REST Catalog API, external tables, catalog linked databases and the Internal Marketplace. The AI context layer covers semantic views, end to end data lineage, automatically generated descriptions and object tagging. Governance and trust covers data quality monitoring, sensitive data classification, data protection policies, AI guardrails, the model registry, access control and cross engine policy enforcement. Business continuity covers database and account replication across regions and accounts.

That is a real product and the list is not padded. Every item on it exists and is documented. What the page does not do, anywhere, is state an edition requirement for a single one of them. Those live on the individual feature pages, and they are the reason this question has a cost answer at all.

The pieces most buyers do not know are there

  • Contacts. Snowflake has a documented stewardship object. Contacts are described as schema level objects that contain details about which user or group of users can be contacted for a specific purpose, with four purposes available: approver, security and compliance, data steward and support. They attach to a database, schema, table, view, materialized view, dynamic table, event table, external table, Iceberg table or task. If your only requirement is "who owns this table", that requirement is met natively.
  • Automatically generated descriptions. Snowflake can generate a description for a column, table or view using its own hosted models, optionally sampling the data to improve the result, and the generated text is saved into the COMMENT property of the object. That is a genuine answer to the empty catalog problem, and it writes into the database rather than into a separate tool.
  • Universal Search. Search covers tables and views including Iceberg, dynamic and hybrid tables, plus streams, tasks, pipes, stages, databases, schemas, functions, stored procedures, semantic views, agents, models and installed applications. It also searches the Snowflake Marketplace, your Internal Marketplace, the Snowflake documentation site and the Snowflake community knowledge base. Two documented caveats: it is optimized for search terms in English, and new objects can take up to a few hours to appear.
  • Trust Center. Four scanner packages ship: Security Essentials, CIS Benchmarks, Threat Intelligence and AI Security. Security Essentials runs on a fixed schedule without incurring serverless compute cost. The others incur serverless compute cost, which is worth knowing before you turn them all on.

Every Horizon capability that requires Enterprise Edition

This is the table that decides the answer, and it is assembled from the requirement note at the top of each feature page rather than from any single Snowflake summary. If you are on Standard Edition today, this is the list of things you do not currently have.

CapabilityEdition requiredWhat the documentation says
Data lineage in SnowsightEnterprise Edition or higherThe lineage page states, verbatim, "This feature requires Enterprise Edition (or higher)."
External lineage over OpenLineageEnterprise Edition or higherGenerally available, and the page carries the same Enterprise Edition requirement.
Data quality monitoring with data metric functionsEnterprise EditionThe data quality introduction states, verbatim, "Data Quality Monitoring requires Enterprise Edition." Upgrading from a lower edition requires contacting Snowflake support.
Anomaly detection on data quality metricsEnterprise Edition or higherDocumented as a preview feature available to all accounts that are Enterprise Edition or higher.
Sensitive data classificationEnterprise Edition or higherThe classification page states, verbatim, "Sensitive data classification requires Enterprise Edition or higher."
Tag based masking policiesEnterprise EditionThe page states, verbatim, "This feature requires Enterprise Edition."
Tag propagationEnterprise Edition or higherCreating and setting tags is available to all accounts. The documentation notes that advanced capabilities, including tag propagation, require Enterprise Edition or higher.
ACCESS_HISTORYEnterprise Edition or higherThe reference page states, verbatim, "Access History requires Enterprise Edition (or higher)." Note that the editions comparison page lists it under Standard Edition; the feature page is the more specific source and it is the one quoted here.
Time Travel beyond 1 dayEnterprise Edition or higherThe standard retention period is 1 day and is enabled for all accounts. Only on Enterprise Edition and higher can permanent databases, schemas and tables be set to any value up to 90 days. Transient and temporary objects stay at a maximum of 1 day on every edition.

Two consequences follow, and both are usually missed. The first is that the edition is not a governance line item. It applies to every credit the account consumes, so upgrading to get lineage and quality monitoring changes the rate on your entire compute bill. Snowflake publishes those rates through a regional calculator rather than a fixed public list, so the only honest instruction is to model your own consumption before assuming the bundled option is the cheap one.

The second is that quality monitoring and classification carry serverless compute costs on top of the edition. Data quality billing is documented as occurring only when a scheduled data metric function is computed on an object, which is a fair model, but it does mean the cost scales with how many checks you run and how often. Bundled is not the same as free.

What "inside or outside of Snowflake" actually covers

This is the sentence that does the most work in Horizon marketing and the one most likely to be misread. It has a precise documented scope, and that scope is three things.

1. Iceberg tables in an external Iceberg REST catalog

A catalog linked database is a Snowflake database connected to an external Iceberg REST catalog, which syncs automatically to detect namespaces and Iceberg tables. Snowflake documents it as supported when you use a catalog integration for Iceberg REST, with tutorials covering AWS Glue and Databricks Unity Catalog as the external catalog. The boundary is explicit in the documentation: you can create schemas, externally managed Iceberg tables or database roles in a catalog linked database, and creating other Snowflake objects is not currently supported. Replication and cloning are not supported either.

So the "outside Snowflake" story is an Apache Iceberg story. It is a genuinely good one if your lake is Iceberg. It does nothing at all for a system that is not.

2. Cloud object storage read through external tables

An external table is documented as a feature you use to query data stored in an external stage as if the data were inside a table in Snowflake. The supported locations are Amazon S3, Google Cloud Storage and Microsoft Azure storage. They are read only, no data manipulation statements are permitted, and XML file formats are not supported. This extends the catalog over files in a bucket. It does not extend it over a database.

3. Lineage nodes contributed over OpenLineage

External lineage is generally available and requires Enterprise Edition or higher. Tools send OpenLineage COMPLETE events as JSON to a Snowflake REST endpoint, and Snowflake documents configuration for dbt and Apache Airflow specifically, noting that any tool with an OpenLineage integration can be configured the same way. Column level lineage is supported through the columnLineage facet. The documented limits are the part to plan around: external lineage events are retained for one year, an event carries a maximum of 15,000 lineage edges, the account limit is 20,000 external lineage edges in total, the default node type is External Node, and OpenLineage version 2 is not supported.

Read that account limit again, because it is the shape of the feature. Twenty thousand edges across the whole account is a useful bridge to a transformation tool and an orchestrator. It is not an inventory of another platform. And nothing arrives unless you build and maintain the push.

What this adds up to is simple. Horizon governs Snowflake objects, Iceberg tables it can reach through a REST catalog, and files in a bucket. Everything else appears as a node on a graph if you wire it up, and does not appear at all if you do not. Anything you need to search, tag, classify, quality test or attach a policy to has to be a Snowflake object.

Horizon data quality: six metric categories, learned baselines on two of them

Snowflake data quality monitoring works through data metric functions, which you attach to an object and put on a schedule. The system library is grouped into six categories: accuracy, freshness, schema, statistics, uniqueness and volume. Accuracy is by far the largest, covering blank counts and percentages, case format violations, future timestamps, invalid JSON, invalid numeric type casts, negatives, nulls, special characters, untrimmed strings and zeros. Statistics covers averages, minimums, maximums, medians, approximate quantiles, standard deviation, variance and string length measures. Uniqueness is three functions: ACCEPTED_VALUES, DUPLICATE_COUNT and UNIQUE_COUNT. Schema is one, SCHEMA_CHANGE_COUNT. Volume is one, ROW_COUNT.

That is a solid library and it covers most of what a team writes by hand in the first year. The documented limits are where the planning happens.

  • Object coverage. Data metric functions can be set on dynamic tables, event tables, external tables, Iceberg tables, materialized views, standard tables including temporary and transient tables, and views. Hybrid tables and streams are not supported. They cannot be set on shared objects and are not available on reader accounts or trial accounts.
  • Scale ceiling. A maximum of 50,000 data metric function associations per account.
  • Scheduling. Checks run on a schedule you set, with an hourly default, and there is a documented ten minute lag before a scheduling change takes effect. Reclustering a table does not trigger a run.
  • Cost model. Serverless compute, billed under a Data Quality Monitoring category, and billing occurs only when a scheduled data metric function is computed on an object. Calling one in a SELECT statement is not billed.
  • Thresholds. You define expectations as comparisons where the left side must be the keyword VALUE, using the documented operators. This is expressive and it is also entirely manual: every threshold on every metric is a number somebody chose and now owns.

Where the native anomaly detection stops

Snowflake does train an algorithm on historical values and flag results outside a predicted range, which removes the threshold problem for the metrics it covers. Two documented constraints define how far that goes. ROW_COUNT and FRESHNESS are the only system data metric functions that support anomaly detection, and the feature is documented as a preview feature available to Enterprise Edition accounts and higher.

It also needs history before it does anything. The documentation calls for at least two weeks of data for a frequently running function, or at least two data points for an infrequent or trigger based one, and recommends 60 days of data to detect anomalies with a high degree of confidence. Until then the status reads TRAINING_IN_PROGRESS. Sensitivity is adjustable across low, medium and high to manage false positives.

So volume and freshness get learned baselines. Null rates, duplicate counts, distribution shifts and every accuracy metric get a number you picked. That is the honest position, and it is a reasonable one for a warehouse to take. It is also the gap that observability products exist to fill, which is a separate decision from the catalog decision and should be made separately.

Getting told about it

Notifications are configured, not assumed. You set DATA_QUALITY_MONITORING_SETTINGS on the database with a specification that names whether notifications are enabled, the email recipients, the notification integrations, a cooldown in hours and whether object metadata is included. Email addresses must be verified first, and the role needs MANAGE DATA QUALITY on the account plus usage on the notification integration. Channels are email and external systems such as Slack through webhooks. Once enabled at database level, every object in that database with an attached data metric function generates notifications, and you switch individual ones off by setting DATA_QUALITY_NOTIFICATION to FALSE on the association.

None of that is difficult. All of it is work somebody has to do and keep doing, and it is the part that quietly decides whether the native option really was cheaper.

What the Snowflake lineage graph shows, and what it does not track

Lineage in Snowsight requires Enterprise Edition or higher. The graph covers tables, dynamic tables, external tables, Iceberg tables, views, materialized views, semantic views, stages, datasets, feature views and models. Column lineage is supported between columns in table like objects, with one documented exception: column lineage is not currently supported for semantic views. The graph reveals objects incrementally, one step at a time upstream or downstream from your selection, rather than rendering a whole dependency tree at once.

The list of things it does not track is the part worth writing down, because these are the gaps you discover during an incident rather than during an evaluation.

  • Shared and system objects. Lineage is not available for objects in shared databases or in the SNOWFLAKE database.
  • Temporary and deleted tables. Neither appears, which matters if a transformation stages through temporary objects.
  • Filter and join only tables. A table used only to filter or join, where no data moves into the downstream object, does not appear as an upstream dependency. That is defensible as a definition and surprising in practice.
  • Disjointed queries. Data movement performed by separate, disjointed queries is not connected. A pipeline stitched together outside Snowflake produces a broken graph inside it.
  • Dynamic tables themselves. A dynamic table appears in the lineage graph of other objects, but the lineage tab does not appear on the dynamic table itself.

For a Snowflake to Snowflake trace this is strong, and it is free of the setup that external lineage requires. The question to ask about your own estate is where the trace has to start and end. If the answer is "from the ingestion job through to the dashboard", the warehouse graph is the middle of the picture and the two ends arrive over OpenLineage or not at all. Our own explainer on the ways lineage is captured and used goes into the difference between parsing a warehouse and stitching an estate, if that distinction is new.

The constraint trap: Snowflake does not enforce your keys

Treat this as background rather than as a Horizon limitation or a criticism of Snowflake. It is a design decision, documented plainly, and it changes how you should read anything a catalog tells you about relationships between tables.

On standard tables, the constraints reference lists PRIMARY KEY, FOREIGN KEY and UNIQUE constraints as "Optional, not enforced". NOT NULL and CHECK constraints are listed as "Optional, enforced". Hybrid tables behave differently: PRIMARY KEY is required and enforced, FOREIGN KEY is optional and enforced for referential integrity, UNIQUE is optional and enforced, NOT NULL is optional and enforced, and CHECK constraints are not supported at all.

The practical consequence is that on ordinary Snowflake tables, a declared primary key is documentation. The engine accepts it, the optimizer may use it, and nothing rejects a duplicate. Any relationship diagram a catalog draws from those declarations is a statement of what somebody intended, not evidence of what is true in the data. If uniqueness and referential integrity matter to you, they have to be tested rather than declared: a DUPLICATE_COUNT or UNIQUE_COUNT data metric function on the key column, or the equivalent test in whatever quality layer you run. Assume nothing from the schema.

Five conditions under which Horizon is genuinely enough

If all five of these hold, use Horizon and spend the money somewhere else. This is a real outcome for a lot of teams and there is nothing second best about it.

  • 1. Every asset in scope is a Snowflake object. Ingestion lands in Snowflake, transformation runs inside it, and reporting reads from it. Nothing you would need to explain during an incident lives somewhere Horizon cannot see.
  • 2. You are already on Enterprise Edition or higher. You upgraded for extended Time Travel, failover, private connectivity or a compliance requirement, so the governance surface costs no incremental edition uplift.
  • 3. Your quality checks fit the system metric library, or you can write the rest as custom data metric functions. And an hourly schedule is fast enough for the checks that matter.
  • 4. Everyone who needs the catalog has a Snowflake login. The consumers are analysts and engineers inside the account, not a business audience who will never be provisioned one.
  • 5. Your lineage question stops at the warehouse boundary. You need to know which table feeds which. You do not need the trace to reach back to an ingestion job or forward into a dashboard.

Five triggers that change the answer

Any single one of these is a reason to evaluate a dedicated platform alongside Horizon rather than instead of it. Horizon keeps doing its job inside Snowflake either way.

  • 1. A system outside Snowflake would appear in your postmortem. An operational Postgres instance, a lake that is not Iceberg, an ingestion tool, a BI semantic layer. None of those becomes a governed Snowflake asset, and the OpenLineage bridge gives you graph nodes rather than searchable, taggable, testable assets.
  • 2. You need to know a pipeline broke, not that a rule failed. Learned baselines on two metrics is where the native layer stops. Everything past that is a threshold somebody owns.
  • 3. You need governance on the lineage itself. Not just a picture of dependencies, but an approval step before a documented lineage relationship changes, so the graph is a controlled record rather than a rendering.
  • 4. Catalog readers do not have Snowflake accounts. The moment a data owner in finance or risk has to be able to look something up, a catalog that lives inside the warehouse console stops being the tool for the job.
  • 5. An auditor wants one control set across the estate. Per platform governance produces per platform evidence, and the reconciliation of that evidence is the work. This is where regulated teams tend to find the cost.

Where Decube fits alongside Snowflake

The honest framing is that this is not a replacement decision. If your estate is Snowflake, Horizon is doing useful work and should keep doing it. The decision is about the layer that has to span systems, and about the capabilities the native layer leaves as your own engineering problem.

PlatformWhat it covers nativelyWhere it stops
DecubeCatalog and discovery with a business glossary, custom attributes and verified and deprecated tags; column level lineage across systems with a structured approval flow on lineage changes; no code and custom SQL quality tests across 12 test types with dynamic thresholding, bulk configuration and alert grouping; pipeline health, freshness, volume, schema change detection and machine learning based anomaly detection, all first party; data contracts between producers and consumers with SQL based test enforcement; policy driven tagging, automatic PII classification, role based access, group management and approval workflows.It is a second product to evaluate and justify when a bundled one already exists. If your estate really is one platform, that justification is hard and should be. Ask us for the current list of sources our quality engine monitors before you assume coverage of any specific system, because that list changes and we would rather you check it than take it from a blog post.
Snowflake Horizon CatalogDiscovery across Snowflake objects with Universal Search; object tagging, contacts for stewardship and automatically generated descriptions; semantic views; column level lineage inside the warehouse; sensitive data classification; data metric functions across six metric categories with configurable notifications; masking and row access policies; the Trust Center scanners; replication for continuity.Most of that requires Enterprise Edition. Coverage outside Snowflake means Iceberg tables in an external REST catalog, files in cloud object storage, and OpenLineage nodes within a 20,000 edge account limit. Anomaly detection covers volume and freshness only and is in preview. Every other threshold and every notification route is yours to define and maintain.

Two capabilities are worth calling out because they are the ones we would point at in this specific comparison rather than in general. The first is approval gated lineage: a structured approval flow on the lineage layer itself, so a change to a documented relationship is a governed event rather than a re render. Nothing in the Snowflake lineage documentation describes an equivalent, because the graph is derived rather than curated. If that matters to you, our lineage product page is the place to look at how the approval flow works.

The second is dynamic thresholding on quality tests, which addresses the exact gap the documentation describes: native anomaly detection covers ROW_COUNT and FRESHNESS, and everything else is a static number. Alongside it sit pipeline health monitoring, freshness, volume and schema change detection with machine learning based anomaly detection as first party features rather than a separate purchase, which is what our data observability page covers.

On cost, we publish ours, which is the only reason it is mentioned here. Starter is 175 US dollars per user per month, from 21,000 US dollars a year with a minimum of 10 users, and Growth is 225 US dollars per user per month, from 54,000 US dollars a year with a minimum of 20 users, on the Decube pricing page. Compare that against a modeled Enterprise Edition uplift on your actual consumption plus the serverless cost of the checks you intend to run, not against the word "included".

How to make this decision in an afternoon

You do not need a proof of concept to answer this. You need four numbers and an hour.

  • 1. Open your last two incident postmortems and list every system named in them. Count how many are Snowflake objects and how many are not. That ratio is the answer to most of this article.
  • 2. Check which Snowflake edition you are on. If it is Standard, price the Enterprise Edition uplift on your real consumption before you price anything else, because it is the precondition for almost every governance feature discussed here.
  • 3. Count the quality checks you would want running and how often. Multiply by the serverless cost model, and note how many of them need a threshold somebody has to own because they are not ROW_COUNT or FRESHNESS.
  • 4. Name the people who need to read the catalog. If any of them will never have a Snowflake login, you have found your requirement, and it is not a feature gap, it is an access one.

If the count in step one is all Snowflake and the answer to step four is nobody, stop. Use Horizon, wire up the notifications properly, and put the budget into something that is actually missing. If either answer went the other way, you are not choosing between a catalog and a warehouse feature. You are choosing what covers the part of the estate the warehouse was never built to see. If the vocabulary here is new, our explainer on what a data catalog is and what it holds sets out the underlying concepts before you start comparing implementations.

Frequently Asked Questions

Is Snowflake Horizon enough for data lineage, or do you need a dedicated tool?

For lineage that starts and ends inside Snowflake, Horizon is enough. Its lineage graph requires Enterprise Edition or higher and covers tables, dynamic tables, external tables, Iceberg tables, views, materialized views, semantic views, stages, datasets, feature views and models, with column level lineage between columns in table like objects. You need a dedicated tool when the trace has to reach outside the warehouse. Snowflake documents several things the graph does not track: objects in shared databases or the SNOWFLAKE database, temporary tables, deleted tables, tables used only for filtering or joining where no data moves downstream, and data movement performed by separate disjointed queries. Lineage from outside systems arrives only through the external lineage endpoint, which accepts OpenLineage events from tools such as dbt and Apache Airflow, retains those events for one year, and is capped at 20,000 external lineage edges per account. If your postmortem needs to name the ingestion job and the dashboard as well as the tables in between, that cap and that setup burden are the reason to look at a dedicated platform.

Does Snowflake Horizon require Enterprise Edition?

The Horizon Catalog page states no edition requirement, but the individual feature pages do, and most of the governance surface is gated. Data lineage in Snowsight, external lineage, sensitive data classification and ACCESS_HISTORY each state Enterprise Edition or higher. Data quality monitoring and tag based masking policies each state Enterprise Edition. Tag propagation requires Enterprise Edition or higher, although creating and setting tags is available to all accounts. Time Travel beyond the default 1 day, up to 90 days on permanent objects, also requires Enterprise Edition or higher. One inconsistency is worth knowing: the editions comparison page lists ACCESS_HISTORY under Standard Edition while the ACCESS_HISTORY reference page states it requires Enterprise Edition or higher. Because the Snowflake edition sets the rate on every credit the account consumes, not just on governance features, an upgrade to obtain these should be modeled against your real consumption rather than assumed to be cheaper than buying a platform.

Does Snowflake Horizon catalog data that lives outside Snowflake?

Within a specific documented scope, yes. It covers Apache Iceberg tables held in an external Iceberg REST catalog through a catalog linked database, which syncs namespaces and tables automatically; Snowflake documents AWS Glue and Databricks Unity Catalog as external catalogs in its tutorials, and notes that only schemas, externally managed Iceberg tables and database roles can be created there. It covers files in Amazon S3, Google Cloud Storage and Microsoft Azure storage through read only external tables, which do not support data manipulation statements or XML. And it accepts lineage from external tools over an OpenLineage endpoint, capped at 20,000 external lineage edges per account with a default node type of External Node. What it does not do is make a system that is none of those things into a governed Snowflake asset. An operational database, a BI semantic layer or an ingestion tool cannot be searched, tagged, classified, quality tested or policy attached inside Horizon.

Does Snowflake Horizon do data observability?

It does part of it natively and leaves the rest to you. Data quality monitoring uses data metric functions grouped into six categories: accuracy, freshness, schema, statistics, uniqueness and volume. You attach them to an object, set a schedule with an hourly default, and define expectations as comparisons. Anomaly detection, which learns a baseline instead of making you pick a number, is documented as a preview feature for Enterprise Edition accounts and supports only two system functions, ROW_COUNT and FRESHNESS. It needs at least two weeks of history before it activates and Snowflake recommends 60 days for high confidence. Notifications are configured per database through the DATA_QUALITY_MONITORING_SETTINGS property, with email or webhook based channels such as Slack. So freshness and volume get learned baselines, and null rates, duplicate counts and distribution shifts get thresholds a person chose and now maintains. That is the gap dedicated observability tooling addresses, and it is a separate decision from the catalog decision.

Does Snowflake enforce primary key and foreign key constraints?

Not on standard tables. The Snowflake constraints reference lists PRIMARY KEY, FOREIGN KEY and UNIQUE constraints as "Optional, not enforced", while NOT NULL and CHECK constraints are listed as "Optional, enforced". Hybrid tables are different: PRIMARY KEY is required and enforced, FOREIGN KEY is optional and enforced for referential integrity, UNIQUE is optional and enforced, NOT NULL is optional and enforced, and CHECK constraints are not supported. The practical consequence for anyone reading a catalog is that a relationship drawn from a declared key on a standard table records what somebody intended, not something the engine has verified. If uniqueness or referential integrity matters, test it: a DUPLICATE_COUNT or UNIQUE_COUNT data metric function on the key column, or the equivalent test in whichever quality layer you run.

How much history does Snowflake keep for Time Travel and access history?

Time Travel has a standard retention period of 1 day, or 24 hours, enabled automatically for all accounts. On Standard Edition the retention period can be set to 0 or left at the default of 1 day. On Enterprise Edition and higher, permanent databases, schemas and tables can be set to any value from 0 up to 90 days, while transient and temporary objects remain capped at 1 day. ACCESS_HISTORY, which records the direct objects accessed, the base objects accessed, the objects modified and the policies referenced by a query, requires Enterprise Edition or higher and displays the last 365 days. It carries a latency of up to 180 minutes and does not log several things, including RESULT_SCAN operations, failed queries, intermediate views between base tables and direct objects, stream update operations and data movement from replication.

When should a Snowflake team buy a dedicated data catalog?

When any one of five things is true. A system outside Snowflake would appear in your incident postmortems, and it is not an Iceberg table in a REST catalog or a file in cloud object storage. You need to know a pipeline broke rather than that a rule failed, on more than the two metrics native anomaly detection covers. You need governance on the lineage itself, meaning an approval step before a documented relationship changes rather than a graph that simply re renders. People who need to read the catalog will never be given a Snowflake login. Or an auditor wants one control set evidenced across the estate rather than assembled platform by platform. If none of those is true and you are already on Enterprise Edition, use Horizon and spend the budget on something that is genuinely missing.

Is Atlan worth it?
Atlan is worth it if your primary need is a modern data catalog with strong column-level lineage and cloud-native integrations (Snowflake, dbt, Databricks). It is harder to justify if you also need data observability and quality coverage across a heterogeneous stack — those capabilities require separate vendors, adding cost and complexity.
What is the best Atlan alternative
Decube is purpose-built for regulated financial services, with native observability, approval-gated lineage, PII auto-classification, and an AI layer (TrustyAI) that does not route metadata to a public LLM. These map directly to regulatory frameworks supervised by MAS, OJK, BNM, and APRA. Atlan AI's OpenAI dependency is often a procurement blocker in these environments.
How does Atlan compare to Alation?
Both are catalog-first platforms with strong discovery. Alation pioneered search-first data culture and analyst adoption. Atlan is stronger on column-level lineage and cloud integrations. Both require external tooling for observability and broad data quality coverage.
How long does it take to migrate from Atlan to another platform?
Migration time depends on estate size and the number of active integrations. SaaS-native platforms like Decube deploy in 2–6 weeks without professional services. The longer task is typically re-establishing business glossaries, data ownership, and custom attributes — that effort is roughly the same regardless of which platform you move to.
What is the difference between a context layer and a semantic layer?
A semantic layer standardizes how metrics are defined and calculated so every analyst and BI tool uses the same numbers. A context layer encodes governance rules, data lineage, quality signals, and organizational knowledge so AI agents can make safe, autonomous decisions. The semantic layer is for human-facing analytics. The context layer is for AI-facing autonomy.
Can I use a semantic layer without a context layer?
Yes - and most organizations do today. If your primary consumers are human analysts using BI tools, a semantic layer alone is sufficient. The context layer becomes essential when you introduce AI agents that need to understand not just what a metric means but whether and how they are allowed to use it.
Is a context layer the same as a data catalog?
No. A data catalog is a component of a context layer. The catalog inventories data assets and stores metadata. The context layer activates that metadata by delivering it to AI agents at query time through APIs and MCP connections. Modern platforms like Atlan extend catalog functionality into full context layer infrastructure.
Which tool implements a context layer?
Purpose-built context layer platforms include Decube, which combines catalog, lineage, quality, and governance into a metadata layer that delivers context to AI agents via MCP. You can also build a context layer on custom infrastructure using a vector database (for semantic search), a knowledge graph
How long does it take to implement a context layer?
Most enterprise context layer implementations take 8–16 weeks when using a purpose-built platform like Atlan. Building from scratch on custom infrastructure typically takes 6–12 months. The timeline depends heavily on how much governance metadata already exists and how many data sources need to be connected.
What is Data Context?
Data Context is the information that explains what data means, where it comes from, how it is transformed, whether it can be trusted, and how it should be used. It combines metadata, lineage, data quality, and governance so people and systems can confidently use data for analytics, reporting, and AI.
How is Data Context different from metadata?
Metadata describes data, while Data Context makes data usable and trustworthy. Metadata provides definitions, ownership, and technical details. Data Context extends this by adding lineage, quality signals, and governance rules, creating a complete, operational understanding of data.
Why is Data Context important for AI?
AI systems require Data Context to interpret data correctly, safely, and reliably. Without context, AI models may misunderstand metrics, use stale or incorrect data, or expose sensitive information. Data Context ensures AI uses trusted, well-defined, and policy-compliant data.
How does data lineage contribute to Data Context?
Data lineage provides visibility into how data flows and transforms across systems. It shows upstream sources, downstream dependencies, and transformation logic, enabling impact analysis, root-cause investigation, and confidence in reported numbers.
How do organizations build Data Context in practice?
Organizations build Data Context by unifying metadata, lineage, observability, and governance into a single operational layer. This includes defining business meaning, capturing end-to-end lineage, monitoring data quality, and enforcing usage policies directly within data workflows.
What is Context Engineering?
Context Engineering is the practice of designing and operationalizing business meaning, data lineage, quality signals, ownership, and policy constraints so that both humans and AI systems can reliably understand and act on enterprise data. Unlike traditional metadata management, Context Engineering focuses on decision-grade context that can be consumed programmatically by AI agents in real time.
How is Context Engineering different from prompt engineering?
Prompt engineering focuses on how questions are phrased for an AI model, while Context Engineering focuses on what the AI system already knows before a question is asked. In enterprise environments, context includes data definitions, lineage, quality, and usage constraints—making Context Engineering foundational for trustworthy and scalable Agentic AI.
Why is Context Engineering critical for Agentic AI?
Agentic AI systems reason, decide, and act autonomously across multiple systems. Without engineered context—such as trusted data meaning, lineage, and real-time quality signals—agents cannot assess risk or impact correctly. Context Engineering ensures AI agents act safely, explain decisions, and know when to pause or escalate.
What are the core components of Context Engineering?
The four core components of Context Engineering are: Semantic context (business meaning and definitions) Lineage context (end-to-end data flow and dependencies) Operational context (data quality and reliability signals) Policy context (privacy, compliance, and usage constraints) Together, these form a unified context layer that supports enterprise decision-making and AI automation
How should enterprises prepare for Context Engineering?
Enterprises should follow a phased approach: Inventory critical data and trust gaps Unify metadata, lineage, quality, and policy into a single context layer Expose context through APIs for AI agent consumption By 2026, this foundation will be essential for deploying Agentic AI at scale with confidence and auditability.
How do you measure the ROI of a data catalog?
ROI is measured by comparing the quantifiable benefits (such as reduced data search time, fewer data quality issues, and lower compliance effort) against the total costs (implementation, licensing, and support). Typical metrics include time savings, productivity gains, and compliance cost reduction.
What is a data catalog and why is it important for ROI?
A data catalog is a centralized inventory of data assets enriched with metadata that helps users find, understand, and trust data across an organization. It improves data discovery, reduces search time, and enhances collaboration — all of which contribute to measurable ROI by cutting operational costs and accelerating insights.
How quickly can businesses see ROI after implementing a data catalog?
Time-to-value varies with deployment and adoption, but many organizations begin seeing measurable improvements in days to months, especially through faster data discovery and reduced compliance effort. Early wins in these areas can quickly justify the investment.
What factors should you include when calculating the ROI of a data catalog?
When calculating ROI, include: Implementation and training costs Recurring maintenance and licensing fees Savings from reduced data search and rework Compliance cost reductions Productivity and decision-making improvements This ensures a holistic view of both costs and benefits.
How does a data catalog support data governance and compliance ROI?
A data catalog enhances governance by classifying data, enforcing rules, and providing transparency. This reduces regulatory risk and compliance effort, leading to direct cost savings and stronger data trust.
What is data lineage?
Data lineage shows where data comes from, how it moves, and how it changes across systems. It helps teams understand the full journey of data—from source to final reports or AI models.
Why is data lineage important for modern data teams?
Data lineage builds trust in data by making it transparent and explainable. It helps teams troubleshoot issues faster, assess impact before changes, meet compliance requirements, and confidently use data for analytics and AI.
What are the different types of data lineage?
Common types of data lineage include: Technical lineage – Tracks data movement at table and column level. Business lineage – Connects data to business definitions and metrics. Operational lineage – Shows how pipelines and jobs process data. End-to-end lineage – Combines all of the above across systems.
Is data lineage only useful for compliance?
No. While data lineage is critical for audits and regulatory compliance, it is equally valuable for debugging data issues, impact analysis, cost optimization, and AI readiness.
How does data lineage help with data quality?
Data lineage helps identify where data quality issues originate and which reports or dashboards are affected. This reduces time spent on root-cause analysis and improves accountability across data teams.
What is Metadata Management?
Metadata management involves the management and organization of data about data to enhance data governance, data asset quality, and compliance.
What are the key points of Metadata Management?
Metadata management involves defining a metadata strategy, establishing roles and policies, choosing the right metadata management tool, and maintaining an ongoing program.
How does Metadata Management work?
Metadata management is essential for improving data quality and relevance, utilizing metadata management tools, and driving digital transformation.
Why is Metadata Management important for businesses?
Metadata management is important for better data quality, usability, data insights, compliance adherence, and improved accuracy in data cataloging.
How should companies evolve their approach to Metadata Management?
Companies should manage all types of metadata across different environments, leverage intelligent methods, and follow best practices to maximize data investments.
What is a data definition example?
A data definition example could be: “Customer: a person or entity that has made at least one purchase within the past year.” It clearly sets business meaning and inclusion criteria.
Why is data definition important in data governance?
It ensures everyone interprets data consistently, reducing ambiguity and improving compliance, reporting, and collaboration.
Who should own data definitions?
Ownership should be shared between business domain experts (for context) and data stewards (for technical accuracy).
How often should data definitions be reviewed?
Ideally quarterly or whenever there’s a structural change in business logic, data models, or product offerings.
What’s the difference between data definition and data catalog?
A data catalog inventories data assets; data definition explains what those assets mean. Combined, they create full visibility and trust.
Why is Data Lineage important for businesses?
Data Lineage provides transparency and trust in your data ecosystem. It helps organizations ensure data accuracy, simplify root-cause analysis during data quality issues, and maintain compliance with regulations like GDPR or SOX. By understanding data flows, teams can make faster, more reliable decisions and improve overall data governance.
What are the key components of Data Lineage?
The main components of Data Lineage include: Data Sources: Where the data originates (databases, APIs, files). Transformations: How data is processed or modified. Data Pipelines: The tools or systems that move data. Destinations: Where the data is stored or consumed (dashboards, reports, models). Metadata: The contextual details that describe each step in the data’s lifecycle.
How does Data Lineage support Data Governance and AI readiness?
Data Lineage acts as the foundation for strong data governance by providing visibility into data ownership, transformation logic, and usage. For AI initiatives, lineage ensures that models are trained on accurate and traceable data, making AI outputs more explainable and trustworthy. Platforms like Decube’s Data Trust Platform unify lineage with data quality and metadata management to help enterprises achieve AI readiness.
What tools are commonly used for Data Lineage?
Several tools help automate and visualize data lineage, such as Decube, Atlan, Alation, Collibra, and OpenLineage. These tools connect to data warehouses, ETL pipelines, and BI tools to automatically map relationships between datasets — saving time and reducing manual effort.
What is Data Lineage?
Data Lineage is the process of tracking how data moves and transforms across an organization — from its origin to its final destination. It shows where data comes from, how it changes through different systems or pipelines, and where it ends up being used. In short, data lineage helps you visualize the journey of your data.
What does “data context” mean?
Data context refers to the semantic, structural, and business information that surrounds raw data. It explains what data means, where it comes from, who owns it, and how it should be used.
What is a centralized LLM framework?
It’s an enterprise-wide system where all departments access AI through a shared platform, equipped with guardrails, context layers, and multimodal capabilities.
What are guardrails in AI?
Guardrails are controls—policies, access restrictions, and compliance checks—that ensure AI outputs are secure, ethical, and aligned with enterprise goals.
How does data context affect ROI in AI?
Models trained or prompted with contextualized data deliver outputs that are relevant, trustworthy, and actionable—leading to faster adoption and higher business value.
What is MCP (Model Context Protocol) and why does it matter?
MCP defines how models interact with external tools and data sources. Feeding it with strong context ensures the AI agent can act accurately and responsibly.
What is a Data Trust Platform in financial services?
A Data Trust Platform is a unified framework that combines data observability, governance, lineage, and cataloging to ensure financial institutions have accurate, secure, and compliant data. In banking, it enables faster regulatory reporting, safer AI adoption, and new revenue opportunities from data products and APIs.
Why do AI initiatives fail in Latin American banks and fintechs?
Most AI initiatives in LATAM fail due to poor data quality, fragmented architectures, and lack of governance. When AI models are fed stale or incomplete data, predictions become inaccurate and untrustworthy. Establishing a Data Trust Strategy ensures models receive fresh, auditable, and high-quality data, significantly reducing failure rates.
What are the biggest data challenges for financial institutions in LATAM?
Key challenges include: Data silos and fragmentation across legacy and cloud systems. Stale and inconsistent data, leading to poor decision-making. Complex compliance requirements from regulators like CNBV, BCB, and SFC. Security and privacy risks in rapidly digitizing markets. AI adoption bottlenecks due to ungoverned data pipelines.
How can banks and fintechs monetize trusted data?
Once data is governed and AI-ready, institutions can: Reduce OPEX with predictive intelligence. Offer hyper-personalized products like ESG loans or SME financing. Launch data-as-a-product (DaaP) initiatives with anonymized, compliant data. Build API-driven ecosystems with partners and B2B customers.
What is data dictionary example?
A data dictionary is a centralized repository that provides detailed information about the data within an organization. It defines each data element—such as tables, columns, fields, metrics, and relationships—along with its meaning, format, source, and usage rules. Think of it as the “glossary” of your data landscape. By documenting metadata in a structured way, a data dictionary helps ensure consistency, reduces misinterpretation, and improves collaboration between business and technical teams. For example, when multiple teams use the term “customer ID”, the dictionary clarifies exactly how it is defined, where it is stored, and how it should be used. Modern platforms like Decube extend the concept of a data dictionary by connecting it directly with lineage, quality checks, and governance—so it’s not just documentation, but an active part of ensuring data trust across the enterprise.
What is an MCP Server?
An MCP Server stands for Model Context Protocol Server—a lightweight service that securely exposes tools, data, or functionality to AI systems (MCP clients) via a standardized protocol. It enables LLMs and agents to access external resources (like files, tools, or APIs) without custom integration for each one. Think of it as the “USB-C port for AI integrations.”
How does MCP architecture work?
The MCP architecture operates under a client-server model: MCP Host: The AI application (e.g., Claude Desktop or VS Code). MCP Client: Connects the host to the MCP Server. MCP Server: Exposes context or tools (e.g., file browsing, database access). These components communicate over JSON‑RPC (via stdio or HTTP), facilitating discovery, execution, and contextual handoffs.
Why does the MCP Server matter in AI workflows?
MCP simplifies access to data and tools, enabling modular, interoperable, and scalable AI systems. It eliminates repetitive, brittle integrations and accelerates tool interoperability.
How is MCP different from Retrieval-Augmented Generation (RAG)?
Unlike RAG—which retrieves documents for LLM consumption—MCP enables live, interactive tool execution and context exchange between agents and external systems. It’s more dynamic, bidirectional, and context-aware.
What is a data dictionary?
A data dictionary is a centralized repository that provides detailed information about the data within an organization. It defines each data element—such as tables, columns, fields, metrics, and relationships—along with its meaning, format, source, and usage rules. Think of it as the “glossary” of your data landscape. By documenting metadata in a structured way, a data dictionary helps ensure consistency, reduces misinterpretation, and improves collaboration between business and technical teams. For example, when multiple teams use the term “customer ID”, the dictionary clarifies exactly how it is defined, where it is stored, and how it should be used. Modern platforms like Decube extend the concept of a data dictionary by connecting it directly with lineage, quality checks, and governance—so it’s not just documentation, but an active part of ensuring data trust across the enterprise.
What is the purpose of a data dictionary?
The primary purpose of a data dictionary is to help data teams understand and use data assets effectively. It provides a centralized repository of information about the data, including its meaning, origins, usage, and format, which helps in planning, controlling, and evaluating the collection, storage, and use of data.
What are some best practices for data dictionary management?
Best practices for data dictionary management include assigning ownership of the document, involving key stakeholders in defining and documenting terms and definitions, encouraging collaboration and communication among team members, and regularly reviewing and updating the data dictionary to reflect any changes in data elements or relationships.
How does a business glossary differ from a data dictionary?
A business glossary covers business terminology and concepts for an entire organization, ensuring consistency in business terms and definitions. It is a prerequisite for data governance and should be established before building a data dictionary. While a data dictionary focuses on technical metadata and data objects, a business glossary provides a common vocabulary for discussing data.
What is the difference between a data catalog and a data dictionary?
While a data catalog focuses on indexing, inventorying, and classifying data assets across multiple sources, a data dictionary provides specific details about data elements within those assets. Data catalogs often integrate data dictionaries to provide rich context and offer features like data lineage, data observability, and collaboration.
What challenges do organizations face in implementing data governance?
Common challenges include resistance from business teams, lack of clear ownership, siloed systems, and tool fragmentation. Many organizations also struggle to balance strict governance with data democratization. The right approach involves embedding governance into workflows and using platforms that unify governance, observability, and catalog capabilities.
How does data governance impact AI and machine learning projects?
AI and ML rely on high-quality, unbiased, and compliant data. Poorly governed data leads to unreliable predictions and regulatory risks. A governance framework ensures that data feeding AI models is trustworthy, well-documented, and traceable. This increases confidence in AI outputs and makes enterprises audit-ready when regulations apply.
What is data governance and why is it important?
Data governance is the framework of policies, ownership, and controls that ensure data is accurate, secure, and compliant. It assigns accountability to data owners, enforces standards, and ensures consistency across the organization. Strong governance not only reduces compliance risks but also builds trust in data for AI and analytics initiatives.
What is the difference between a data catalog and metadata management?
A data catalog is a user-facing tool that provides a searchable inventory of data assets, enriched with business context such as ownership, lineage, and quality. It’s designed to help users easily discover, understand, and trust data across the organization. Metadata management, on the other hand, is the broader discipline of collecting, storing, and maintaining metadata (technical, business, and operational). It involves defining standards, policies, and processes for metadata to ensure consistency and governance. In short, metadata management is the foundation—it structures and governs metadata—while a data catalog is the application layer that makes this metadata accessible and actionable for business and technical users.
What features should you look for in a modern data catalog?
A strong catalog includes metadata harvesting, search and discovery, lineage visualization, business glossary integration, access controls, and collaboration features like data ratings or comments. More advanced catalogs integrate with observability platforms, enabling teams to not only find data but also understand its quality and reliability.
Why do businesses need a data catalog?
Without a catalog, employees often struggle to find the right datasets or waste time duplicating efforts. A data catalog solves this by centralizing metadata, providing business context, and improving collaboration. It enhances productivity, accelerates analytics projects, reduces compliance risks, and enables data democratization across teams.
What is a data catalog and how does it work?
A data catalog is a centralized inventory that organizes metadata about data assets, making them searchable and easy to understand. It typically extracts metadata automatically from various sources like databases, warehouses, and BI tools. Users can then discover datasets, understand their lineage, and see how they’re used across the organization.
What are the key features of a data observability platform?
Modern platforms include anomaly detection, schema and freshness monitoring, end-to-end lineage visualization, and alerting systems. Some also integrate with business glossaries, support SLA monitoring, and automate root cause analysis. Together, these features provide a holistic view of both technical data pipelines and business data quality.
How is data observability different from data monitoring?
Monitoring typically tracks system metrics (like CPU usage or uptime), whereas observability provides deep visibility into how data behaves across systems. Observability answers not only “is something wrong?” but also “why did it go wrong?” and “how does it impact downstream consumers?” This makes it a foundational practice for building AI-ready, trustworthy data systems.
What are the key pillars of Data Observability?
The five common pillars include: Freshness, Volume, Schema, Lineage, and Quality. Together, they provide a 360° view of how data flows and where issues might occur.
What is Data Observability and why is it important?
Data observability is the practice of continuously monitoring, tracking, and understanding the health of your data systems. It goes beyond simple monitoring by giving visibility into data freshness, schema changes, anomalies, and lineage. This helps organizations quickly detect and resolve issues before they impact analytics or AI models. For enterprises, data observability builds trust in data pipelines, ensuring decisions are made with reliable and accurate information.

Table of Contents

Read other blog articles

Grow with our latest insights

Sneak peek from the data world.

Thank you! Your submission has been received!
Talk to a designer