1866558 - Airflow task bqetl_artifact_deployment.publish_new_tables failed for exec_date 2023-11-24

Status: RESOLVED FIXED

(Data Platform and Tools :: General, defect)

Description

[Leli [:Leli]]

Airflow task bqetl_artifact_deployment.publish_new_tables failed for exec_date 2023-11-24

Task link:
https://workflow.telemetry.mozilla.org/dags/bqetl_artifact_deployment/grid?dag_run_id=scheduled__2023-11-23T00%3A00%3A00%2B00%3A00&task_id=publish_new_tables&tab=logs

Log extract:

[{'message': 'Access Denied: Table moz-fx-data-shared-prod:casa.users: User does not have permission to query table moz-fx-data-shared-prod:casa.users, or perhaps it does not exist in location US.'

Comment 1

[Mike Williams [:mwilliams]]

This has now failed for the 4th day in a row, for both publish_new_tables and publish_views.

Comment 2

[Anna Scholtz [:ascholtz]]

This should be fixed via: https://github.com/mozilla/bigquery-etl/commit/d642cefd59f89bf6fbefc78fb29f4ac978adccda

Comment 3

[Mike Williams [:mwilliams]]

Confirmed resolved for last task execution.