Root cause summary

The freshness_check on dbt.default.fct_revenue failed because the upstream pipeline airflow.dbt_transform_daily did not complete successfully since 2026-04-20T03:00:00Z, specifically due to the failure of the run_fct task, preventing recent updates to the table.

Evidence chain

1. The freshness_check on table dbt.default.fct_revenue aborted at 2026-04-26T15:12:11.691701Z.
2. The upstream pipeline airflow.dbt_transform_daily has a last_run_status of "Failed" with the last_run_at timestamp being 2026-04-20T03:00:00Z.
3. Within the airflow.dbt_transform_daily pipeline, the run_fct task shows a "Failed" status.
4. Past incidents 73351df5-825b-4216-9d4c-1dbe4941ec76 and 32fb694e-b95e-4289-aa9c-90e9bd02c829 for dbt.default.fct_revenue also identified the failure of the run_fct task in airflow.dbt_transform_daily as the root cause for freshness_check failures.

Remediation steps

1. Investigate and resolve the underlying issue causing the run_fct task in the airflow.dbt_transform_daily pipeline to fail.
2. Manually trigger a rerun of the airflow.dbt_transform_daily pipeline to refresh dbt.default.fct_revenue after the fix.