Root cause summary

The freshness_check 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. This prevented dbt.default.fct_revenue from being updated, leading to a freshness violation.

Evidence chain

1. The data quality test dbt.default.default.fct_revenue.freshness_check aborted at 2026-04-26T13:24:41.846040Z.
2. Multiple other data quality tests on related tables, such as dbt.default.default.stg_products.freshness_check_products and dbt.default.default.fct_revenue.anomaly_detection_revenue, also aborted around the same time, indicating a broader issue with data processing.
3. The upstream pipeline airflow.dbt_transform_daily, which is responsible for transforming data feeding into dbt.default.fct_revenue, had its last_run_status as Failed on 2026-04-20T03:00:00Z.
4. Specifically, the run_fct task within the airflow.dbt_transform_daily pipeline, which processes factual tables like dbt.default.fct_revenue, was found to be in a Failed state.

Remediation steps

1. Investigate and resolve the underlying issue causing the run_fct task to fail in the airflow.dbt_transform_daily pipeline.
2. Manually trigger a rerun of the airflow.dbt_transform_daily pipeline once the fix is deployed to refresh dbt.default.fct_revenue.
3. Notify affected stakeholders about the data freshness delay for dbt.default.fct_revenue.