Root cause summary

The airflow.ingest_users_hourly pipeline failed on the load_users task, preventing fresh user data from being loaded into mysql.default.default.users, which in turn caused the data quality incident on dbt.default.dim_users.

Evidence chain

1. The row_count_dim_users test on dbt.default.dim_users failed at 2026-04-26T13:22:03.412000+00:00.
2. Other DQ tests on dbt.default.dim_users (e.g., dbt.default.default.dim_users.anomaly_detection_growth) also Aborted around 2026-04-26T13:22:06.382582Z, indicating a broader data freshness or availability 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 and the airflow.ingest_users_hourly pipeline.
4. The airflow.ingest_users_hourly pipeline has a Failed status for its last_run_at, with the load_users task specifically failing.

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 user data is properly loaded into mysql.default.default.users.
3. Monitor dbt.default.dim_users for successful completion of data quality tests after the upstream pipeline is fixed and data is refreshed.