DataLineage Doctor

RCA dashboard

Incident detail

mysql.default.users

Triggered at 05-06-2026 00:21

COMPLETE HIGH confidence

Root cause summary

The data quality test null_check_user_id on mysql.default.users failed because the upstream pipeline airflow.ingest_users_hourly encountered a failure in its load_users task, leading to incomplete or incorrect data ingestion into mysql.default.users.

0.95 Score

Evidence chain

  1. The data quality test null_check_user_id on mysql.default.users failed at 2026-06-04T18:51:41.336000+00:00.
  2. The upstream lineage analysis identified airflow.ingest_users_hourly as a direct upstream pipeline for mysql.default.users.
  3. The airflow.ingest_users_hourly pipeline's last_run_status is Failed, with the load_users task specifically showing a Failed status.
  4. Downstream entities dbt.default.default.stg_users, dbt.default.default.dim_users, and metabase.user_growth_dashboard are impacted by this incident.

Remediation steps

  1. Investigate the failure of the load_users task within the airflow.ingest_users_hourly pipeline to identify the specific error.
  2. Address the underlying issue causing the load_users task to fail (e.g., source system issues, data schema changes, resource limitations).
  3. Rerun the airflow.ingest_users_hourly pipeline to ensure successful data loading into mysql.default.users.
  4. Monitor the null_check_user_id data quality test on mysql.default.users to confirm successful remediation.
  5. Notify owners of impacted downstream entities: dbt.default.default.stg_users, dbt.default.default.dim_users, and metabase.user_growth_dashboard.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

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

    The load_users task within the airflow.ingest_users_hourly pipeline failed, leading to potential data quality issues in mysql.default.users.

  • Data Quality Incident
    05-06-2026 00:21 · mysql.default.users

    The null_check_user_id data quality test on table mysql.default.users failed, indicating missing user_id values.

  • Cascading Data Quality Issue
    05-06-2026 00:21 · dbt.default.default.dim_users

    Anomaly detection test dbt.default.default.dim_users.anomaly_detection_growth on dbt.default.default.dim_users was aborted, likely due to upstream data quality issues originating from mysql.default.users.

Blast radius

Level 1

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

Level 2

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

Level 3

Entity Type Service
metabase.user_growth_dashboard D dashboard metabase