Root cause summary

The data quality incident on mysql.default.raw_orders with the failing test row_count_orders was caused by the failure of the upstream pipeline airflow.ingest_orders_daily. Specifically, the load_orders task within this pipeline failed, preventing fresh data from being loaded into mysql.default.raw_orders.

Evidence chain

1. The row_count_orders test on mysql.default.raw_orders failed at 2026-06-08T14:08:20.758000+00:00.
2. Multiple other data quality tests on various tables, including those downstream from mysql.default.raw_orders, showed an "Aborted" status around 2026-06-08T14:08:24Z, indicating a lack of data updates.
3. The upstream pipeline airflow.ingest_orders_daily, responsible for populating mysql.default.raw_orders, has a Failed status.
4. The load_orders task within the airflow.ingest_orders_daily pipeline specifically failed, indicating that data was not loaded into mysql.default.raw_orders.
5. Downstream tables dbt.default.default.stg_orders, dbt.default.default.fct_orders, dbt.default.default.fct_revenue and dashboard metabase.revenue_dashboard are impacted by the failure of mysql.default.raw_orders.

Remediation steps

1. Investigate and fix the load_orders task in the airflow.ingest_orders_daily pipeline.
2. Rerun the airflow.ingest_orders_daily pipeline to ensure data is loaded into mysql.default.raw_orders.
3. Monitor the row_count_orders test and other related data quality tests on mysql.default.raw_orders to confirm resolution.
4. Notify affected downstream consumers about the incident and resolution.