Skip to content
METRIC OAK

New: the 3-week Data Platform Assessment: fixed fee, priced roadmap. See what's included →

Explainer

What is data observability? The five pillars, and how it differs from testing

Data observability is continuous monitoring of data health across pipelines: freshness, volume, distribution, schema and lineage. How it differs from data quality tests, what to monitor first, and the tool options on Databricks, Snowflake and dbt.

Hemant Walchale

Hemant Walchale
· 4 min read

Every data team has had the call: “the dashboard looks wrong.” Often the cause is mundane: a feed stopped, a file arrived half-empty, a column was renamed upstream. Data observability is the practice of catching those problems automatically, close to where they start, and knowing which reports and models they affect.

Five pillars of data observability, each with its question and an example alert: freshness asks whether data arrived on time, for example orders last loaded 26 hours ago; volume asks whether the expected amount arrived, for example row count down 40 percent today; distribution asks whether values look normal, for example null rate rising from 0.3 to 12 percent; schema asks whether the structure changed, for example a column renamed upstream; lineage asks what caused it and what breaks, for example five dashboards affected.

The five pillars

Pillar Question Typical signal
Freshness Did the data arrive on time? Time since last update, compared with the expected schedule
Volume Did the expected amount arrive? Row counts or file sizes versus normal ranges
Distribution Do the values look normal? Null rates, distinct counts, ranges, averages drifting from baseline
Schema Did the structure change? Added, removed, renamed or retyped columns
Lineage What caused it, and what does it affect? Upstream sources and downstream tables, dashboards and models

Observability vs testing

  • Tests encode what you already know must be true: uniqueness, not-null, accepted values, referential integrity. They are cheap, explicit and belong in every pipeline (for example dbt tests or pipeline expectations).
  • Observability watches for what you did not think to test. Monitors learn the normal pattern of freshness, volume and distributions and alert on deviations, then use lineage to trace the cause and the impact.

Tests catch known failures; observability catches the unknown ones and shortens the time to find and fix them. Mature teams use both.

What to monitor first

Monitoring everything creates noise. Start where errors are most expensive:

  1. Critical outputs: the tables behind executive dashboards, regulatory reports, finance figures and AI use cases.
  2. Freshness and volume on their key sources, which catch most incidents with few false alarms.
  3. Schema changes on inputs from systems you do not control (SaaS apps, partner files).
  4. Distribution checks on the few columns that drive decisions (amounts, statuses, IDs).
  5. Alert routing to the dataset owner, not a shared channel nobody reads.

Measure the result as fewer incidents found by users and a shorter time from failure to fix.

Tool options

  • Built into platforms: Databricks offers data quality monitoring on Unity Catalog tables; Snowflake has data metric functions that measure freshness, nulls, duplicates and custom metrics on a schedule; Microsoft Fabric and Purview add data quality and monitoring features.
  • dbt and pipeline frameworks: tests, source freshness checks and expectations within the pipelines themselves.
  • Dedicated observability tools: Monte Carlo, Bigeye, Soda, Anomalo and others add cross-platform monitoring, anomaly detection, incident workflows and lineage.

Native features are often enough for one platform; dedicated tools earn their cost across several platforms or very large estates.

The short version

Data observability continuously watches freshness, volume, distribution and schema, and uses lineage to trace cause and impact, so data problems are caught before users find them. Pair it with explicit tests, start with the outputs that matter most, and route alerts to owners. Our data quality and governance service sets up testing, monitoring and ownership together.

Related: what is data lineage, data contracts for data leaders, what is data mesh, how to assess AI readiness and what is reverse ETL.

Sources

Further reading from other practitioners

Not sure where your own platform stands? Take the free 3-minute data platform scorecard. Unfamiliar terms are explained in the data engineering glossary.

Frequently asked questions

What is data observability in simple terms?

Data observability is continuous, automated monitoring of the data in your pipelines and platforms, so you find out that data is late, missing, malformed or wrong before the people using it do. It also shows where a problem started and what it affects downstream.

What are the five pillars of data observability?

Freshness (did data arrive on time), volume (did the expected amount arrive), distribution (do the values look normal), schema (did the structure change) and lineage (where did the problem come from and what does it affect). The five-pillar model was popularised by Monte Carlo; some vendors group signals differently.

What is the difference between data observability and data quality testing?

Tests check rules you wrote in advance, such as 'order_id is unique' or 'amount is not null'. Observability watches for changes you did not anticipate, often learning normal patterns and alerting on anomalies, and adds lineage to find the cause and impact. Most teams need both: tests for known rules, observability for unknown problems.

Have 30 minutes? Get a senior architect’s view of your data platform.

No sales deck. You talk to the engineer who would lead the work.

Book an architecture review