Root cause summary

The anomaly_detection_growth test on dbt.default.dim_users failed because the upstream pipeline airflow.ingest_users_hourly did not complete its load_users task, leading to stale or incomplete data in mysql.default.default.users and subsequently in dbt.default.dim_users.

Evidence chain

1. The anomaly_detection_growth test on dbt.default.dim_users aborted at 2026-04-26T10:56:04.567112Z.
2. Multiple other DQ tests on various tables also aborted around the same time, indicating a broader data availability or processing 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.
4. The mysql.default.default.users table is populated by the airflow.ingest_users_hourly pipeline.
5. The airflow.ingest_users_hourly pipeline has a Failed status, with the load_users task specifically failing.
6. The last_run_at for the airflow.ingest_users_hourly pipeline was 2026-04-20T03:00:00Z, indicating that the data for users is outdated and potentially caused the anomaly detection test to fail due to a lack of recent data.

Remediation steps

1. Investigate the failure of the load_users task within the airflow.ingest_users_hourly pipeline.
2. Fix the issue causing the load_users task to fail and rerun the airflow.ingest_users_hourly pipeline to backfill mysql.default.default.users.
3. Once the upstream data in mysql.default.default.users is corrected and fresh, trigger a refresh for the dbt.default.dim_users table to resolve the data quality issue.