Data Observability Tools & Data Pipeline Monitoring Tools (2026)

Data observability tools watch the tables a pipeline produces, while data pipeline monitoring tools watch the jobs that produce them. Which you need depends on whether your incidents are failed runs or wrong data behind a green run. The comparison covers job monitors, rules as code, warehouse-native checks and commercial platforms, and says which situation each one fits.

Last updated: Proudly published by: Jeff Wahl8 min read

Data observability tools vs data pipeline monitoring tools

The 2 names describe different layers. Data pipeline monitoring tools watch the jobs: did the run finish or fail, and how long did it take. Data observability tools watch the tables the jobs write: is the data fresh and complete, and what depends on it.

The gap matters because a job reports on itself. Take orders_load, which usually puts about 15,000 rows into orders. An upstream rate limit cuts one run to 3,300 rows. The job exits 0, every job-level monitor stays green, and the table is 78% short. Only a check on the table, comparing its row count with earlier loads, sees it.

2 monitors watching the same load: the job monitor sees orders_load succeed, while the table monitor sees 3,300 rows loaded into orders against a baseline of 15,000, 78% short2 monitors watching the same load: the job monitor sees orders_load succeed, while the table monitor sees 3,300 rows loaded into orders against a baseline of 15,000, 78% short

The reverse also holds. A table monitor sees a stale table and can't tell you the scheduler lost its heartbeat or that a Spark stage spilled to disk. Choosing tools starts with deciding which of these questions has been costing you incidents.

4 kinds of monitoring tool compared on the same criteria

Job monitors
  • WatchesRuns and tasks
  • Catches exit 0, bad dataNo
  • Learns baselinesRun durations
  • Spans systemsPer scheduler
  • Cost modelMetrics volume
Rules as code
  • WatchesTables you list
  • Catches exit 0, bad dataIf a rule exists
  • Learns baselinesNo, you write rules
  • Spans systemsPer connection
  • Cost modelCode you maintain
Warehouse native
  • WatchesTables on 1 platform
  • Catches exit 0, bad dataVolume, freshness
  • Learns baselinesYes, for 2 metrics
  • Spans systems1 platform
  • Cost modelServerless compute
Platforms
  • WatchesTables across stores
  • Catches exit 0, bad dataYes
  • Learns baselinesYes
  • Spans systemsMany warehouses
  • Cost modelVendor pricing

Data pipeline monitoring tools: Airflow, Dagster and Datadog

Job monitoring is the layer most teams already have. Airflow emits metrics through StatsD or OpenTelemetry: ti_failures counts task failures by DAG and task, dagrun.duration.success.{dag_id} times each run, and scheduler_heartbeat shows whether the scheduler is alive. You graph and alert on them in whatever metrics stack you run.

Dagster moves one step toward the data. An asset check, written with @asset_check, tests a property of an asset such as nulls in a column or a schema, and the result appears in the UI with a severity. Setting blocking=True stops downstream assets from materializing when the check fails, which turns a check into a gate. By default runs continue past a failed check.

Datadog Data Jobs Monitoring covers jobs across Spark on Kubernetes, EMR, Dataproc, Databricks, Airflow, dbt, AWS Glue and Azure Data Factory. It detects failed and slow jobs and data skew, and compares runs. It works at the job level and does not read table contents. Pick this layer first when your incidents are failed or late jobs, and add a table layer when they're wrong numbers behind a green run.

Prepare for the interview
01 / Open invite
02min.

Know Data Observability Tools the way the interviewer who asks it knows it.

a Data Observability Tools query, the same shape a screen would give you.
The diff against expected. Where ties broke. What you missed.
sandbox
1source → bronze → silver → gold
2 ingest : CDC + Kafka
3 transform : dbt + Airflow
4 serve : Snowflake
5
Execute your solution0.4s avg.

Open-source data observability tools and what each covers

Elementary is the dbt-native option. It's Apache-2.0 licensed, has 2.4k GitHub stars as of 2026-11-03, and runs anomaly detection as dbt tests, with monitors for freshness and volume plus schema changes. The open-source dbt package and CLI are self-managed, and a hosted Elementary Cloud sits on top. It fits a team whose models already live in dbt, because the checks are configuration in the same project.

Great Expectations (Apache-2.0, 11.9k stars as of 2026-11-03) and Soda Core express checks as code. Soda Core verifies data contracts inside your pipelines, and Soda's documentation states that it does not include observability features. Metric monitoring and anomaly detection arrive with Soda Cloud, a managed service. That split is common: the open-source piece enforces rules you know, and the hosted piece learns what normal looks like.

For lineage and catalogs, the OpenLineage documentation describes an open framework in the LF AI & Data Foundation, built on datasets, and on the jobs and runs that touch them, extended by facets, with integrations for Airflow, Spark, Flink and dbt, as well as Great Expectations. Marquez is its reference implementation. OpenMetadata adds data quality tests and a profiler, plus incident management and alerts, in 1 catalog. Open-source stacks give full control and ask you to host and upgrade every piece and connect them yourself.

Data observability and pipeline monitoring tools by layer

Job and run monitoring
Airflow metricsTask failures and run duration
Dagster asset checksChecks that can block downstream assets
Datadog Data Jobs MonitoringFailed and slow Spark and warehouse jobs
Table and data monitoring
ElementaryAnomaly tests inside a dbt project
Soda CoreData contracts verified in the pipeline
Great ExpectationsExpectations written as code
Snowflake data metric functionsScheduled checks on Snowflake tables
Databricks data quality monitoringFreshness and completeness in Unity Catalog
Monte CarloTable and metric monitors across warehouses
BigeyeData quality platform that also covers schema and lineage
Metaplane by DatadogML monitoring with column-level lineage
OpenMetadataCatalog with tests and a profiler, plus incident handling
OpenLineage with MarquezOpen lineage events and their backend

Built-in data observability in Snowflake and Databricks

Both warehouses ship a first layer. Snowflake system data metric functions measure common metrics without configuration, run on a schedule that defaults to once every hour, and require Enterprise Edition. Its data quality documentation says anomaly detection currently covers volume and freshness, billing is serverless compute for scheduled runs, and an account holds up to 50,000 function associations.

The schedule sets your detection delay. A freshness check that runs every 60 minutes on a table with a 240 minute SLA can alert up to 300 minutes after the last good load: the allowance plus 1 check interval. Tighten the schedule on the few tables where that gap is too long, and accept the default elsewhere.

Databricks data quality monitoring has 2 parts. Anomaly detection checks freshness, using a model of each table's commit history, and completeness, whether the last 24 hours brought roughly the expected rows. Data profiling tracks summary statistics and drift; it was formerly called Lakehouse Monitoring. Both cover Unity Catalog tables and bill as serverless compute. That's enough while all of your data lives on 1 platform, but the checks stop at its edge.

Commercial data observability platforms: what they add

Platforms connect to your warehouses and orchestrators, as well as BI tools, and monitor tables from outside. Monte Carlo's documentation lists table monitors for freshness and volume and for schema changes, metric monitors with anomaly detection or fixed thresholds, validation monitors with custom SQL, and job and query performance monitors. Monitors can be defined as code and deployed through CI/CD, and a Terraform provider manages account setup.

Deployment varies and deserves a question in any evaluation. Monte Carlo documents an agent that runs in your cloud, a Snowflake Native App and private network links, plus a dedicated instance and EU hosting. Bigeye describes itself as an enterprise data observability platform covering pipeline and data quality monitoring, with schema change detection and lineage. Ask each vendor what metadata leaves your environment and which of these options your security team accepts.

The category also consolidates. On April 23, 2025, Datadog announced it was acquiring Metaplane, which it described as an end-to-end data observability platform with machine learning monitoring and column-level lineage, and said Metaplane would continue as Metaplane by Datadog. Check current packaging before you assume which products ship together. Prices change often and are left out here, so ask for them in writing.

Which data observability tool fits which situation

No tool here is the right answer in general, so the decision runs through your constraints. Start from where incidents come from. If runs fail or crawl, begin with job monitoring. If runs are green and numbers are wrong, begin with table checks, in the system that already holds the data.

Then count how many places the data lives. One warehouse favors its native checks. A dbt project favors Elementary or dbt tests. Several warehouses and a lake feeding BI tools in the same incident favor a platform, because only a tool that sits outside them can follow a break from one system into the next. Last, weigh who maintains it: open-source stacks cost engineer time, while platforms cost money and a metadata-sharing review.

Situations and the tools that tend to fit

SituationTools that tend to fitWhy
Transformations live in dbt and the team is smallElementary, dbt testsAnomaly tests run as dbt tests in the project you already deploy, with no new platform to host.
All data sits in 1 Snowflake or Databricks accountNative data quality monitoringChecks need no connector and bill as serverless compute, though Snowflake's require Enterprise Edition.
Jobs fail or run slow more often than data goes wrongAirflow metrics, Dagster, Datadog Data Jobs MonitoringThey watch run health and duration, which is where those incidents show first.
Incidents cross warehouses, lakes and BI toolsA platform such as Monte Carlo, Bigeye or MetaplaneThey monitor tables across stores and carry lineage between them.
Producers must meet a written contract before data is publishedSoda Core, Great Expectations, Dagster blocking checksThey verify known rules inside the pipeline and can stop a bad load from moving downstream.
Open lineage across many tools is the main gapOpenLineage with Marquez, OpenMetadataJobs emit lineage events in an open format, so the graph does not depend on 1 vendor.

How to evaluate a data observability tool before you commit

Replay your worst incident from the last quarter instead of watching a demo. Load the affected tables, ask the tool how soon it would have alerted, and check whether the alert named the upstream cause. A tool that detects the break but can't place it still leaves you doing the investigation by hand.

Test 4 things on your own stack. First, coverage: does it connect to every system in the incident. Second, alert quality: how many alerts fire for 1 upstream break, and can they group by shared cause. Third, delay: what the check schedule adds to detection time. Fourth, ownership: who tunes thresholds once the trial ends. A tool that answers all 4 for your tier 1 tables is a candidate whatever its category.

How data observability comes up in data engineering interviews

Interviewers rarely ask you to name a vendor. They ask how you would know a pipeline you designed is broken and how you would find the cause, then listen for whether you separate job health from data health and where lineage fits. The data pipeline interview questions cover that ground, and the data pipeline practice problems let you design the pipelines these checks watch.

The data engineering system design round is where monitoring choices get probed hardest, and dbt-based answers lean on dbt interview questions. For the concepts underneath the tools, read what data observability is, data quality tools and data lineage tools.

Data observability tools FAQ

What is the difference between data observability tools and data pipeline monitoring tools?+
Pipeline monitoring tools watch the jobs: whether a run finished or failed, and how long it took. Data observability tools watch the tables the jobs produce: whether they arrived on time and hold all their rows, and whether the schema and values still look right. A run can succeed and still write bad data, so most teams need both layers.
What are the open-source data observability tools?+
Elementary is an Apache-2.0 dbt package with anomaly tests for freshness and volume, plus a schema check. Great Expectations (Apache-2.0) and Soda Core express checks as code. OpenLineage with its reference backend Marquez covers lineage, and OpenMetadata covers tests and profiling, and tracks incidents, in a catalog. Each is a building block you host and wire together.
Do I need a paid data observability platform?+
Not always. A team with its transformations in dbt, or its data in 1 warehouse, can get freshness and volume checks, and schema checks too, from open-source packages or the warehouse itself. A platform pays off when there are more tables than anyone can tune checks for, or when incidents cross systems that no single tool sees.
Can Airflow or Dagster monitor my data?+
Both monitor runs, and Dagster also runs checks on assets. Airflow emits metrics such as task failures and DAG run duration through StatsD or OpenTelemetry. Dagster asset checks test properties of an asset, and a blocking check stops downstream assets when it fails. Neither learns what normal looks like for a table without checks you write.
Do Snowflake and Databricks have built-in data observability?+
Yes, as a first layer. Snowflake data metric functions run on a schedule, once an hour by default, and its anomaly detection covers volume and freshness, on Enterprise Edition. Databricks data quality monitoring checks freshness and completeness for tables in Unity Catalog. Each covers its own platform only.
What does Datadog do for data observability?+
Datadog Data Jobs Monitoring watches jobs on Spark, Databricks, Airflow, dbt, AWS Glue and other platforms for failures and slow runs. On April 23, 2025, Datadog announced the acquisition of Metaplane, a data observability platform with machine learning monitoring and column-level lineage, which continues as Metaplane by Datadog.
02 / Why practice

The candidate who gets the offer

  1. 01

    Reading a solution is not the same as writing one

    Every engineer who has frozen on a query they had read a dozen times knows the gap. The only preparation that closes it is producing the answer yourself, under time, before the interview does it for you

  2. 02

    76% of hiring managers reject on the coding task, not the resume

    From HackerRank's 2024 Developer Skills Report. Candidates who look strong on paper still fail the live screen if they haven't done timed, executable practice

  3. 03

    System design comes down to the calls you defend out loud

    Ingestion, batch vs streaming, the bronze/silver/gold layers, idempotency, backfill and replay. Sketching the pipeline and naming the failure modes is the signal, not the boxes

Related guides