DataLineage Doctor

RCA dashboard

Incident detail

dbt.default.fct_revenue

Triggered at 26-04-2026 20:30

COMPLETE HIGH confidence

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.

0.90 Score

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.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

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

    Pipeline airflow.dbt_transform_daily task run_fct failed, preventing updates to dbt.default.fct_revenue.

  • Data Quality Incident Trigger
    26-04-2026 20:30 · dbt.default.fct_revenue

    Data quality incident triggered for table dbt.default.fct_revenue due to freshness_check failure.

  • DQ Test Aborted
    26-04-2026 20:30 · dbt.default.default.fct_revenue.freshness_check

    Test case dbt.default.default.fct_revenue.freshness_check result was Aborted.

Blast radius

Blast radius will appear once the RCA completes.