DataLineage Doctor

RCA dashboard

Incident detail

dbt.default.stg_products

Triggered at 26-04-2026 16:28

COMPLETE HIGH confidence

Root cause summary

The freshness_check_products test on dbt.default.stg_products aborted because the upstream pipeline airflow.dbt_transform_daily has been in a Failed state since 2026-04-20T03:00:00Z, preventing dbt.default.stg_products from being updated.

0.95 Score

Evidence chain

  1. The test freshness_check_products on table dbt.default.stg_products aborted at 2026-04-26T10:58:37.837274Z.
  2. The upstream pipeline airflow.dbt_transform_daily has a Failed status, with its last successful run at 2026-04-20T03:00:00Z.
  3. The failure of airflow.dbt_transform_daily prevents dbt.default.stg_products from receiving fresh data.
  4. The downstream table dbt.default.default.fct_revenue is impacted by the freshness issue of dbt.default.stg_products.

Remediation steps

  1. Investigate the root cause of the Failed status for the run_fct task within the airflow.dbt_transform_daily pipeline.
  2. Fix the issue in the airflow.dbt_transform_daily pipeline to ensure successful completion.
  3. Manually trigger the airflow.dbt_transform_daily pipeline to refresh dbt.default.stg_products and resolve the data freshness issue.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

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

    The pipeline airflow.dbt_transform_daily failed its last run, specifically the run_fct task, preventing subsequent updates to dbt.default.stg_products.

  • Incident Trigger
    26-04-2026 16:28 · dbt.default.stg_products

    A data quality incident was triggered for table dbt.default.stg_products due to freshness issues.

  • DQ Test Aborted
    26-04-2026 16:28 · dbt.default.stg_products

    The freshness_check_products test on dbt.default.stg_products aborted, indicating that the table was not updated as expected.

Blast radius

Level 1

Entity Type Service
dbt.default.default.fct_revenue T table dbt