Root cause summary

The row_count_orders test on table mysql.default.raw_orders failed because the upstream pipeline airflow.ingest_orders_daily experienced a failure in its load_orders task, preventing new data from being loaded into mysql.default.raw_orders.

Evidence chain

1. The row_count_orders test on mysql.default.raw_orders was triggered and failed at 2026-06-07T17:18:49.330000+00:00.
2. The upstream lineage for mysql.default.raw_orders identifies airflow.ingest_orders_daily as a direct source pipeline.
3. The airflow.ingest_orders_daily pipeline's last_run_status is Failed, with its load_orders task specifically failing, indicating that data is not being loaded into mysql.default.raw_orders.
4. Multiple other data quality tests on various tables, including row count checks, were Aborted around 2026-06-07T17:18:52Z, corroborating a widespread data loading issue.
5. Past incidents for mysql.default.raw_orders repeatedly show similar failures, with the airflow.ingest_orders_daily pipeline's load_orders task being the root cause, leading to incomplete or missing data.

Remediation steps

1. Investigate the cause of the load_orders task failure within the airflow.ingest_orders_daily pipeline.
2. Fix the underlying issue in the load_orders task and rerun the airflow.ingest_orders_daily pipeline to ensure data is correctly loaded into mysql.default.raw_orders.
3. Monitor the row_count_orders test on mysql.default.raw_orders and the downstream entities to confirm data quality recovery.