1858184 - Airflow task dim_active_users_aggregates_desktop.firefox_desktop_active_users_aggregates_dim_check failed for exec_date 2023-10-10

Status: RESOLVED WONTFIX

(Data Platform and Tools :: General, defect)

Description

[Alekhya Kommasani [:Alekhya]]

Retry did not work.

Task link:
https://workflow.telemetry.mozilla.org/log?dag_id=dim_active_users_aggregates_desktop&task_id=firefox_desktop_active_users_aggregates_dim_check&execution_date=2023-10-09T04%3A30%3A00%2B00%3A00&map_index=-1

dim_active_users_aggregates_desktop has failed for the corresponding execution date 2023-10-10

Airflow task kpi_forecasting.wait_for_firefox_desktop_active_users_aggregates_dim_check failed for exec_date 2023-10-10 also failing.

Comment 1

[Lucia Vargas]

Task failed on execution date 2023-11-01 due to a mismatch of one client_id missing in firefox_desktop.active_users_aggregates when comparing to the live upstream table.

Query to investigate
https://console.cloud.google.com/bigquery?project=data-monitoring-dev&j=bq:US:ef912526-60f4-4335-96f3-60ca0e2758c1&page=queryresults

Comment 2

[anicholson]

dim has since been decommissioned (https://github.com/mozilla/dim/pull/94)