Root cause summary

The null_check_order_id test on table mysql.default.raw_orders failed due to a prior failure of the load_orders task within the airflow.ingest_orders_daily pipeline, leading to incomplete or malformed data being loaded.

Evidence chain

1. The test null_check_order_id on mysql.default.raw_orders was triggered at 2026-04-26T15:02:03.618000+00:00.
2. Upstream lineage for mysql.default.raw_orders identified airflow.ingest_orders_daily as a direct source pipeline.
3. The airflow.ingest_orders_daily pipeline Failed on 2026-04-20T03:00:00Z, with the load_orders task specifically failing.
4. Several data quality tests on downstream tables, including dbt.default.default.fct_revenue, were Aborted around 2026-04-26T15:02:07Z, indicating widespread data quality issues.
5. The blast radius analysis confirms that dbt.default.default.stg_orders, dbt.default.default.fct_orders, dbt.default.default.fct_revenue (tables) and metabase.revenue_dashboard (dashboard) are all impacted downstream consumers.

Remediation steps

1. Investigate and fix the root cause of the load_orders task failure in the airflow.ingest_orders_daily pipeline.
2. Manually re-run the airflow.ingest_orders_daily pipeline for the affected data period.
3. Backfill the mysql.default.raw_orders table and all directly and indirectly impacted downstream tables: dbt.default.default.stg_orders, dbt.default.default.fct_orders, and dbt.default.default.fct_revenue.