1879333 - Airflow task bqetl_org_mozilla_firefox_derived.<task name> failed for exec_date 2-8-2024

Status: NEW

(Data Platform and Tools :: General, defect)

Description

[Katie Windau]

Airflow task bqetl_org_mozilla_firefox_derived.<task name> failed for exec_date 2-8-2024

Task link:
https://workflow.telemetry.mozilla.org/dags/bqetl_org_mozilla_firefox_derived/grid?dag_run_id=scheduled__2024-02-07T02%3A00%3A00%2B00%3A00&task_id=fenix_derived__meta_attribution_country_counts__v1

Log extract:

[{'code': 403, 'errors': [{'message': 'Access Denied: Table moz-fx-data-shared-prod:org_mozilla_fenix_nightly_stable.client_deduplication_v1: User does not have permission to query table moz-fx-data-shared-prod:org_mozilla_fenix_nightly_stable.client_deduplication_v1, or perhaps it does not exist in location US.', 'domain': 'global', 'reason': 'accessDenied'}], 'response': {'headers': {'alt-svc': 'h3=":443"; ma=2592000,h3-29=":443"; ma=2592000', 'cache-control': 'private', 'content-encoding': 'gzip', 'content-type': 'application/json; charset=UTF-8', 'date': 'Thu, 08 Feb 2024 05:14:46 GMT', 'server': 'ESF', 'transfer-encoding': 'chunked', 'vary': 'Origin, X-Origin, Referer', 'x-content-type-options': 'nosniff', 'x-frame-options': 'SAMEORIGIN', 'x-xss-protection': '0'}}, 'message': 'Access Denied: Table moz-fx-data-shared-prod:org_mozilla_fenix_nightly_stable.client_deduplication_v1: User does not have permission to query table moz-fx-data-shared-prod:org_mozilla_fenix_nightly_stable.client_deduplication_v1, or perhaps it does not exist in location US.'}]
[2024-02-08, 05:15:10 UTC] {pod_manager.py:437} INFO - [base] Cannot get schema for moz-fx-data-shared-prod.org_mozilla_fenix_nightly.client_deduplication: Error when dry running SQL file moz-fx-data-shared-prod/org_mozilla_fenix_nightly/client_deduplication/query.sql