DataLineage Doctor

RCA dashboard

Incident detail

mysql.default.raw_orders

Triggered at 27-04-2026 06:05

COMPLETE HIGH confidence

Root cause summary

The null_check_order_id test on table mysql.default.raw_orders failed because the upstream pipeline airflow.ingest_orders_daily's load_orders task failed, leading to incomplete or malformed data.

0.95 Score

Evidence chain

  1. The data quality test null_check_order_id on table mysql.default.raw_orders was triggered at 2026-04-27T00:35:17.727000+00:00 and failed.
  2. Recent data quality test results show multiple tests on mysql.default.raw_orders and related tables were Aborted around 2026-04-27T00:35:21Z.
  3. Upstream lineage shows that airflow.ingest_orders_daily is a direct upstream pipeline for mysql.default.raw_orders.
  4. The pipeline airflow.ingest_orders_daily has a Failed status, with the load_orders task specifically failing.
  5. A past incident (b670093c-2440-494d-9b5e-75d45fd4e1b4) on 2026-04-26T15:02:03.618000+00:00 for mysql.default.raw_orders with the null_check_order_id test explicitly attributed the failure to the load_orders task within the airflow.ingest_orders_daily pipeline, indicating a recurring issue.

Remediation steps

  1. Investigate and resolve the failure of the load_orders task in the airflow.ingest_orders_daily pipeline.
  2. Rerun the airflow.ingest_orders_daily pipeline to ensure mysql.default.raw_orders is populated with correct data.
  3. Monitor the null_check_order_id test on mysql.default.raw_orders and other related data quality tests.
  4. Notify owners of impacted downstream entities: dbt.default.default.stg_orders, dbt.default.default.fct_orders, dbt.default.default.fct_revenue, and metabase.revenue_dashboard.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

  • Pipeline Task Failure
    20-04-2026 08:30 · airflow.ingest_orders_daily.load_orders

    The pipeline task load_orders within airflow.ingest_orders_daily failed, impacting data loading into mysql.default.raw_orders.

  • Past Incident Triggered
    26-04-2026 20:32 · mysql.default.raw_orders

    A past incident (b670093c-2440-494d-9b5e-75d45fd4e1b4) was triggered for null_check_order_id on mysql.default.raw_orders, attributed to the load_orders task failure in airflow.ingest_orders_daily.

  • Data Quality Incident Triggered
    27-04-2026 06:05 · mysql.default.raw_orders.null_check_order_id

    The data quality test null_check_order_id on table mysql.default.raw_orders failed, triggering the current incident.

  • Data Quality Tests Aborted
    27-04-2026 06:05 · mysql.default.raw_orders

    Multiple data quality tests for mysql.default.raw_orders and related downstream tables, including dbt.default.default.stg_products, dbt.default.default.fct_revenue, mysql.default.default.subscriptions, and dbt.default.default.dim_users, were aborted.

Blast radius

Level 1

Entity Type Service
dbt.default.default.stg_orders T table dbt

Level 2

Entity Type Service
dbt.default.default.fct_orders T table dbt

Level 3

Entity Type Service
dbt.default.default.fct_revenue T table dbt
metabase.revenue_dashboard D dashboard metabase