Root cause summary

The anomaly_detection_revenue test on dbt.default.fct_revenue aborted because the upstream pipeline airflow.dbt_transform_daily failed its run_fct task on 2026-04-20T03:00:00Z, preventing recent updates to the table.

Evidence chain

1. The anomaly_detection_revenue test on dbt.default.fct_revenue aborted at 2026-04-26T15:12:06.410504Z.
2. The upstream pipeline airflow.dbt_transform_daily has a Failed status for its last run, which occurred at 2026-04-20T03:00:00Z.
3. The specific task run_fct within airflow.dbt_transform_daily, which is responsible for dbt.default.fct_revenue, has a Failed status.
4. Past incidents for dbt.default.fct_revenue on 2026-04-26 corroborate this, indicating that airflow.dbt_transform_daily task run_fct failure was the root cause for freshness issues.

Remediation steps

1. Investigate and fix the Failed task run_fct in the airflow.dbt_transform_daily pipeline.
2. Rerun the airflow.dbt_transform_daily pipeline to update dbt.default.fct_revenue.
3. Monitor dbt.default.fct_revenue for successful completion of the anomaly_detection_revenue and freshness_check tests.