Root cause summary

The freshness_check on dbt.default.fct_revenue failed because the upstream pipeline airflow.dbt_transform_daily, specifically the run_fct task, did not complete successfully, preventing recent updates to the table.

Evidence chain

1. The freshness_check for table dbt.default.fct_revenue aborted at 2026-04-26T15:00:12.479549Z.
2. Multiple other data quality tests on dbt.default.fct_revenue and related tables also aborted around 2026-04-26T15:00:12Z, indicating a broader data update issue.
3. The upstream pipeline airflow.dbt_transform_daily, which is responsible for populating dbt.default.fct_revenue, shows a Failed status for its run_fct task.
4. The last recorded run of airflow.dbt_transform_daily was 2026-04-20T03:00:00Z, which is prior to the incident, indicating that dbt.default.fct_revenue had not been updated recently.

Remediation steps

1. Investigate the specific failure of the run_fct task within the airflow.dbt_transform_daily pipeline.
2. Rerun the airflow.dbt_transform_daily pipeline after resolving the underlying issue to update dbt.default.fct_revenue.
3. Monitor the freshness_check on dbt.default.fct_revenue to confirm successful resolution and data freshness.