Root cause summary

The row_count_dim_users test on table dbt.default.dim_users failed because the upstream pipeline airflow.ingest_users_hourly experienced a failure in its load_users task. This prevented fresh user data from being ingested into mysql.default.default.users, subsequently impacting dbt.default.default.stg_users and finally dbt.default.dim_users.

Evidence chain

1. The data quality test row_count_dim_users on table dbt.default.dim_users failed.
2. Multiple other data quality tests on dbt.default.dim_users and its related upstream tables, such as dbt.default.default.dim_users.anomaly_detection_growth, were aborted around 2026-04-26T14:21:01Z, indicating a widespread data issue at the time of the incident.
3. The upstream lineage shows that dbt.default.dim_users depends on dbt.default.default.stg_users, which in turn depends on mysql.default.default.users.
4. The airflow.ingest_users_hourly pipeline, responsible for loading data into mysql.default.default.users, has a Failed status for its load_users task, with the last run at 2026-04-20T03:00:00Z.
5. The dashboard metabase.user_growth_dashboard is a downstream consumer impacted by dbt.default.dim_users.

Remediation steps

1. Investigate and resolve the load_users task failure within the airflow.ingest_users_hourly pipeline.
2. Rerun the airflow.ingest_users_hourly pipeline to ensure that mysql.default.default.users is correctly populated with the latest data.
3. After the upstream data issue is resolved, monitor the data in dbt.default.dim_users and re-run relevant data quality tests.
4. Communicate the data quality incident and its resolution status to the owners of the metabase.user_growth_dashboard.