Root cause summary

The freshness_check_products test on dbt.default.stg_products aborted because the upstream transformation pipeline airflow.dbt_transform_daily failed on its run_fct task. This prevented the dbt.default.stg_products table from being updated, leading to stale data and the freshness check failure.

Evidence chain

1. The freshness_check_products test case on dbt.default.stg_products resulted in Aborted status at 2026-04-26T15:02:15.375437Z.
2. The upstream pipeline airflow.dbt_transform_daily failed on 2026-04-20T03:00:00Z with the task run_fct having a Failed status.
3. The dbt.default.stg_products table has airflow.dbt_transform_daily as an immediate upstream pipeline.
4. The upstream raw data ingestion pipeline airflow.ingest_products_daily was Successful, indicating the issue is not with initial data ingestion but with transformation.
5. The fct_revenue table dbt.default.default.fct_revenue is a direct downstream consumer of dbt.default.stg_products and is impacted by this incident.

Remediation steps

1. Investigate and fix the run_fct task in the airflow.dbt_transform_daily pipeline.
2. Rerun the airflow.dbt_transform_daily pipeline to update dbt.default.stg_products.
3. Monitor the freshness_check_products test on dbt.default.stg_products after the pipeline rerun.