DataLineage Doctor

RCA dashboard

Incident detail

mysql.default.users

Triggered at 26-04-2026 18:36

COMPLETE HIGH confidence

Root cause summary

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

0.95 Score

Evidence chain

  1. The null_check_user_id test failed on table mysql.default.users at 2026-04-26T13:06:27.739000+00:00.
  2. The upstream pipeline airflow.ingest_users_hourly for table mysql.default.users had a Failed run with its last_run_at at 2026-04-20T03:00:00Z.
  3. Specifically, the load_users task within the airflow.ingest_users_hourly pipeline Failed.
  4. Several other data quality tests across different tables also Aborted around 2026-04-26T13:06:32Z, indicating a broader data ingestion issue likely stemming from the upstream pipeline failure.

Remediation steps

  1. Investigate and fix the load_users task failure in the airflow.ingest_users_hourly pipeline.
  2. Rerun the airflow.ingest_users_hourly pipeline to backfill mysql.default.users with correct data.
  3. Monitor table mysql.default.users and its downstream consumers for data quality issues after the fix.

Lineage graph

Root cause highlighted in red. Downstream impacts in amber.

Timeline

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

    Pipeline airflow.ingest_users_hourly task load_users failed, preventing proper data loading into mysql.default.users.

  • DQ Test Failure
    26-04-2026 18:36 · mysql.default.users

    Data quality incident triggered due to null_check_user_id test failure on table mysql.default.users.

  • DQ Tests Aborted
    26-04-2026 18:36 · dbt.default.default.dim_users

    Multiple data quality tests, including dbt.default.default.dim_users.anomaly_detection_growth, dbt.default.default.fct_revenue.anomaly_detection_revenue, mysql.default.default.subscriptions.duplicate_subs, dbt.default.default.fct_revenue.freshness_check, and dbt.default.default.stg_products.freshness_check_products were Aborted, indicating a widespread data ingestion issue.

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