Root cause summary

The freshness_check_products test on table dbt.default.stg_products aborted because its upstream transformation pipeline, airflow.dbt_transform_daily, failed to complete. This pipeline has been failing since 2026-04-20T03:00:00Z, preventing dbt.default.stg_products from being updated and causing the freshness check to abort.

Evidence chain

1. The data quality test dbt.default.default.stg_products.freshness_check_products on table dbt.default.stg_products aborted at 2026-04-27T12:48:53.016698Z.
2. Upstream lineage shows that airflow.dbt_transform_daily pipeline is a direct upstream dependency for dbt.default.stg_products.
3. The airflow.dbt_transform_daily pipeline's last run status was Failed at 2026-04-20T03:00:00Z, with task run_fct failing.
4. The failure of airflow.dbt_transform_daily prevented dbt.default.stg_products from being updated, leading to the freshness test aborting.
5. The dbt.default.default.fct_revenue table is a downstream consumer impacted by the dbt.default.stg_products table.

Remediation steps

1. Investigate and fix the airflow.dbt_transform_daily pipeline failure, specifically addressing the run_fct task.
2. Backfill airflow.dbt_transform_daily to ensure dbt.default.stg_products and its downstream dependencies are up-to-date.
3. Monitor the freshness_check_products test on dbt.default.stg_products after remediation to confirm resolution.