DataLineage Doctor

RCA dashboard

Incident detail

dbt.default.stg_products

Triggered at 26-04-2026 20:32

COMPLETE HIGH confidence

Root cause summary

The freshness_check_products test on dbt.default.stg_products aborted because the upstream transformation pipeline airflow.dbt_transform_daily failed on its run_fct task. This prevented the dbt.default.stg_products table from being updated, leading to stale data and the freshness check failure.

0.95 Score

Evidence chain

  1. The freshness_check_products test case on dbt.default.stg_products resulted in Aborted status at 2026-04-26T15:02:15.375437Z.
  2. The upstream pipeline airflow.dbt_transform_daily failed on 2026-04-20T03:00:00Z with the task run_fct having a Failed status.
  3. The dbt.default.stg_products table has airflow.dbt_transform_daily as an immediate upstream pipeline.
  4. The upstream raw data ingestion pipeline airflow.ingest_products_daily was Successful, indicating the issue is not with initial data ingestion but with transformation.
  5. The fct_revenue table dbt.default.default.fct_revenue is a direct downstream consumer of dbt.default.stg_products and is impacted by this incident.

Remediation steps

  1. Investigate and fix the run_fct task in the airflow.dbt_transform_daily pipeline.
  2. Rerun the airflow.dbt_transform_daily pipeline to update dbt.default.stg_products.
  3. Monitor the freshness_check_products test on dbt.default.stg_products after the pipeline rerun.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

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

    The airflow.dbt_transform_daily pipeline failed on task run_fct, preventing updates to dbt.default.stg_products.

  • Data Quality Incident Trigger
    26-04-2026 20:32 · dbt.default.stg_products

    A data quality incident was triggered on dbt.default.stg_products due to the failing freshness_check_products test case.

  • Test Case Aborted
    26-04-2026 20:32 · dbt.default.default.stg_products.freshness_check_products

    The freshness_check_products test on dbt.default.stg_products aborted, indicating issues with data availability or processing.

Blast radius

Level 1

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