DataLineage Doctor

RCA dashboard

Incident detail

mysql.default.users

Triggered at 10-06-2026 05:16

COMPLETE HIGH confidence

Root cause summary

The null_check_user_id test failed on mysql.default.users because the upstream pipeline airflow.ingest_users_hourly failed during its load_users task, leading to incomplete or corrupted data in the mysql.default.users table.

0.95 Score

Evidence chain

  1. The null_check_user_id test on mysql.default.users failed at 2026-06-09T23:46:20.095000+00:00.
  2. The upstream pipeline airflow.ingest_users_hourly has a Failed status for its last run.
  3. Specifically, the load_users task within the airflow.ingest_users_hourly pipeline Failed.
  4. Several other data quality tests across different tables like dbt.default.default.dim_users, dbt.default.default.fct_revenue, and mysql.default.default.subscriptions also show an Aborted status around the same time (2026-06-09T23:46:27.611106Z), suggesting a broader issue potentially stemming from an upstream data ingestion problem.

Remediation steps

  1. Investigate and resolve the failure in the load_users task of the airflow.ingest_users_hourly pipeline.
  2. Rerun the airflow.ingest_users_hourly pipeline to ensure correct data ingestion into mysql.default.users.
  3. Backfill any missing or incorrect data in mysql.default.users as a result of the pipeline failure.
  4. Monitor the null_check_user_id test on mysql.default.users for successful completion after remediation.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

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

    The load_users task of the airflow.ingest_users_hourly pipeline Failed.

  • Data Quality Test Failure
    10-06-2026 05:16 · mysql.default.users

    The null_check_user_id test Failed on mysql.default.users.

  • Data Quality Test Aborted
    10-06-2026 05:16 · dbt.default.default.dim_users

    The anomaly_detection_growth test was Aborted on dbt.default.default.dim_users, indicating potential broader data quality issues.

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