DataLineage Doctor

RCA dashboard

Incident detail

dbt.default.dim_users

Triggered at 26-04-2026 16:26

COMPLETE HIGH confidence

Root cause summary

The anomaly_detection_growth test on dbt.default.dim_users failed because the upstream pipeline airflow.ingest_users_hourly did not complete its load_users task, leading to stale or incomplete data in mysql.default.default.users and subsequently in dbt.default.dim_users.

0.95 Score

Evidence chain

  1. The anomaly_detection_growth test on dbt.default.dim_users aborted at 2026-04-26T10:56:04.567112Z.
  2. Multiple other DQ tests on various tables also aborted around the same time, indicating a broader data availability or processing issue.
  3. The upstream lineage shows dbt.default.dim_users depends on dbt.default.default.stg_users, which in turn depends on mysql.default.default.users.
  4. The mysql.default.default.users table is populated by the airflow.ingest_users_hourly pipeline.
  5. The airflow.ingest_users_hourly pipeline has a Failed status, with the load_users task specifically failing.
  6. The last_run_at for the airflow.ingest_users_hourly pipeline was 2026-04-20T03:00:00Z, indicating that the data for users is outdated and potentially caused the anomaly detection test to fail due to a lack of recent data.

Remediation steps

  1. Investigate the failure of the load_users task within the airflow.ingest_users_hourly pipeline.
  2. Fix the issue causing the load_users task to fail and rerun the airflow.ingest_users_hourly pipeline to backfill mysql.default.default.users.
  3. Once the upstream data in mysql.default.default.users is corrected and fresh, trigger a refresh for the dbt.default.dim_users table to resolve the data quality issue.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

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

    The airflow.ingest_users_hourly pipeline failed during its load_users task.

  • Data Quality Incident Triggered
    26-04-2026 16:26 · dbt.default.dim_users

    A data quality incident was triggered for table dbt.default.dim_users.

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

    The anomaly_detection_growth test on dbt.default.dim_users aborted, likely due to upstream data issues from airflow.ingest_users_hourly pipeline failure.

Blast radius

Level 1

Entity Type Service
metabase.user_growth_dashboard D dashboard metabase