Root cause summary

The mysql.default.raw_products table is stale due to the upstream airflow.ingest_products_daily pipeline not running since 2026-04-20T03:00:00Z. This staleness likely caused the null_check_product_id test to fail.

Evidence chain

1. The null_check_product_id test on mysql.default.raw_products was reported to have failed at 2026-04-26T17:26:27.362000+00:00.
2. Multiple other data quality tests on various tables, including dbt.default.default.stg_products.freshness_check_products, reported an 'Aborted' status around 2026-04-26T17:26:32Z, indicating potential widespread data quality issues.
3. The upstream pipeline airflow.ingest_products_daily, responsible for populating mysql.default.raw_products, last ran successfully on 2026-04-20T03:00:00Z, which is six days prior to the incident.
4. Downstream entities dbt.default.default.stg_products and dbt.default.default.fct_revenue are impacted by the mysql.default.raw_products table.

Remediation steps

1. Investigate why the airflow.ingest_products_daily pipeline has not executed since 2026-04-20T03:00:00Z.
2. Manually trigger or restart the airflow.ingest_products_daily pipeline to ingest fresh data into mysql.default.raw_products.
3. After the pipeline successfully completes, re-run the null_check_product_id test on mysql.default.raw_products.