DataLineage Doctor

RCA dashboard

Incident detail

mysql.default.raw_orders

Triggered at 02-06-2026 09:01

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 failed its load_orders task, preventing new data from being loaded into mysql.default.raw_orders.

0.95 Score

Evidence chain

  1. The data quality test null_check_order_id on mysql.default.raw_orders failed.
  2. The upstream pipeline airflow.ingest_orders_daily was identified as a direct upstream dependency of mysql.default.raw_orders.
  3. The pipeline airflow.ingest_orders_daily has a Failed status for its last run, specifically the load_orders task.
  4. Multiple other DQ tests on other tables also show an Aborted status around the same time, suggesting a broader data ingestion issue.

Remediation steps

  1. Investigate and fix the load_orders task within the airflow.ingest_orders_daily pipeline.
  2. Manually trigger a rerun of the airflow.ingest_orders_daily pipeline after the fix.
  3. Monitor the null_check_order_id test on mysql.default.raw_orders for successful completion after pipeline rerun.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

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

    The airflow.ingest_orders_daily pipeline's load_orders task failed.

  • DQ Test Failure
    02-06-2026 09:01 · mysql.default.raw_orders

    The null_check_order_id test on mysql.default.raw_orders failed.

  • DQ Test Aborted
    02-06-2026 09:01 · dbt.default.default.stg_products

    The dbt.default.default.stg_products.freshness_check_products test was 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