Root cause summary

The upstream pipeline airflow.dbt_transform_daily, responsible for updating dbt.default.stg_products, has been failing since at least 2026-04-20T03:00:00Z. This prolonged failure prevented dbt.default.stg_products from being updated, leading to the freshness_check_products test aborting due to outdated data.

Evidence chain

1. The data quality test freshness_check_products on table dbt.default.stg_products aborted at 2026-04-30T12:39:00.512096Z.
2. Upstream lineage for dbt.default.stg_products identifies the airflow.dbt_transform_daily pipeline as a direct dependency.
3. The airflow.dbt_transform_daily pipeline's last_run_status is Failed at 2026-04-20T03:00:00Z, indicating it has not successfully completed for 10 days prior to the incident.
4. The airflow.ingest_products_daily pipeline, which feeds mysql.default.default.raw_products (an upstream of dbt.default.stg_products), was successful, ruling out ingestion as the primary cause.
5. Other related data quality tests on tables, such as dbt.default.default.fct_revenue.freshness_check, also aborted around the same time, indicating a broader impact likely stemming from the airflow.dbt_transform_daily pipeline's failure.
6. The dbt.default.default.fct_revenue table is identified as a downstream consumer impacted by dbt.default.stg_products.

Remediation steps

1. Investigate and resolve the underlying failures in the airflow.dbt_transform_daily pipeline.
2. Manually trigger a successful run of the airflow.dbt_transform_daily pipeline to update dbt.default.stg_products.
3. Monitor the freshness_check_products test on dbt.default.stg_products to ensure it passes after the pipeline is fixed and rerun.