DataLineage Doctor

RCA dashboard

Incident detail

dbt.default.fct_revenue

Triggered at 26-04-2026 18:54

COMPLETE HIGH confidence

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.

0.95 Score

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.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

  • Pipeline Failure
    20-04-2026 08:30 · airflow.dbt_transform_daily

    The upstream pipeline airflow.dbt_transform_daily failed its run_fct task.

  • DQ Test Triggered
    26-04-2026 18:54 · dbt.default.fct_revenue

    The freshness_check data quality test was triggered on dbt.default.fct_revenue.

  • DQ Test Aborted
    26-04-2026 18:54 · dbt.default.default.fct_revenue.freshness_check

    The freshness_check data quality test on dbt.default.fct_revenue aborted due to data freshness issues.

Blast radius

Blast radius will appear once the RCA completes.