(+351) 21 24 10006  ·  info@bconcepts.pt
Carnaxide, Lisbon
Data observability: detect problems before impact
Data Engineering

Data observability: detect problems before impact

João Barros 20/07/2026 6 min

Companies increasingly rely on data pipelines to feed critical decisions: pricing, inventory, credit risk, marketing campaigns. When a load fails, a schema changes or a source starts reporting zeros, the impact appears quickly — from campaigns that spend millions to compliance reports with incorrect information. Data observability answers this urgency: it’s not just knowing that something failed, it’s understanding why, where and with what impact in minutes, not days.

Today there are more tools and practices to instrument every stage of the data flow, but the question many teams ask is practical: where to start and how to align investment with impact? Implementing data observability is not a technical luxury; it’s an economic defense. Companies with visible pipelines can reduce mean time to resolve incidents (MTTR) from several hours to under an hour and avoid operational losses that can amount to hundreds of thousands of euros per month in a retail or fintech context.

What is data observability and how it differs from monitoring

Data observability is the ability to infer the internal state of data systems from observable signals: metrics, logs and traces (telemetry). Unlike traditional monitoring, which checks health and uptime, observability focuses on behavior and signals of degradation — for example, changes in value distributions, schema drift, loss of cardinality or increasing latency in transformations.

Observabilidade de dados: detetar problemas antes do impacto

An observable approach combines tests (pre/post-deploy), continuous metrics (freshness, volume, completeness), and lineage to relate an anomaly in a source file with reports to end users. This turns technical incidents into actionable information for business and engineering teams, and enables prioritizing fixes based on potential impact.

Which signals are worth detecting immediately

Not all signals have the same value. Some metrics justify immediate alerts because historically they lead to direct losses: row count, referential integrity, null values in key columns, and delays in data freshness. Other metrics, such as small variations in the distribution of a variable, can indicate model drift and deserve investigation, but not necessarily an immediate operational alarm.

Practical examples of useful rules: alert when the number of rows ingested in a day diverges more than 10% from the average of the last 7 runs; flag when the percentage of null values in a key column exceeds 5%; and create schema warnings when an expected column disappears. These thresholds are a starting point — adjustments depend on the criticality of the pipelines and historical behavior.

Essential practices to implement data observability

Starting with observability can seem challenging, but there are pragmatic steps that bring quick value. First, instrument pipelines to emit standard metrics: counts, run times, latency and schema metadata. Second, establish data SLAs and service-level agreements that define expected freshness and completeness.

  • Define essential metrics per pipeline (row count, freshness, schema hash, distribution).
  • Automate tests (unit and regression) as part of CI/CD for data transformations.
  • Persist telemetry and build trend dashboards, not just instantaneous states.
  • Implement alerting with context (who is the owner, estimated impact, link to runbook).
  • Maintain data lineage to trace impact from source to reports and models.

These steps produce real results: they reduced the number of false positives when combined with adaptive thresholds and allow prioritizing between engineering and business teams. It is also important to create simple runbooks for recurring incidents — a resolution flow can dramatically lower MTTR.

Tools and architecture: from simple to sophisticated

There is no single solution. For small teams, starting with integrated tests (dbt tests, Great Expectations) and job run monitoring (Airflow, Prefect) can solve 60–70% of the most common problems. As the ecosystem grows, dedicated observability tools (for example, commercial platforms like Monte Carlo, Databand or open-source alternatives like Soda and OpenLineage) add capabilities for automatic incident correlation, intelligent alerting and impact dashboards.

Typical architectures include instrumentation at the ingestion layer, telemetry stored in a time-series system or data warehouse, and a lineage layer to map dependencies. A good architectural practice is to ensure the following data are easily queryable: rows ingested per job, schema history, anomalies detected per feature, and metadata of owners/SLAs for each table.

Mini practical case: how an omnichannel retailer reduced losses by 30%

Imagine a retail chain with a physical store and an online store. During a seasonal peak, an ETL process that aggregates sales by SKU fails silently due to a change in the partner feed. Without observability, reports show underestimated sales, and the replenishment system reduces orders, causing stockouts in stores. The impact was estimated at €150k in lost sales over two weeks.

After implementing data observability with row count tests, validation of sales distribution by SKU and alerting with context (owner and runbook), the team began detecting the failure in less than 30 minutes. MTTR fell from 6 hours to 45 minutes, and incidents that caused commercial impact decreased by 70%. In two months, the reduction in losses and operational effort justified the initial investment.

Measure success and next practical steps

Measuring the impact of observability requires clear operational KPIs: mean time to detect (MTTD), mean time to resolve (MTTR), percentage of pipelines with test coverage, and number of incidents that caused business impact. Concrete objectives, such as reducing MTTR to under 1 hour for critical pipelines, make the initiative actionable.

To start today, I recommend three practical high-impact steps: (1) identify the 3 pipelines with the highest risk/value for the company; (2) instrument basic metrics (row count, freshness, schema) and define SLAs; (3) automate alerts with runbooks and a responsible owner for each pipeline. These three steps usually produce measurable results in 4–8 weeks.

Data observability is more than a technical matter: it is an operational discipline that protects decisions and reduces risk. By focusing on actionable metrics, automation and accountability, teams can turn lengthy incidents into rapid responses. What is the first pipeline you will instrument in your organization?

← Back to insights
Let's talk?

Ready to transform your data?

Book a free 30-minute meeting and find out how we can help your team make better decisions.

Book a Free Meeting
bConcepts