Closed Bug 1808964 Opened 3 years ago Closed 3 years ago

Airflow task bqetl_artifact_deployment.publish_views failing on 2023-01-06

Categories

(Data Platform and Tools :: General, defect)

Product:
Data Platform and Tools
Component:
General
Type:
defect

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: srose, Assigned: kik)

Details

(Whiteboard: [airflow-triage])

Airflow task bqetl_artifact_deployment.publish_views failing on 2023-01-06.

I think these are the errors causing the job to fail:

  • moz-fx-data-shared-prod.firefox_accounts.fxa_content_auth_oauth_events

    google.api_core.exceptions.BadRequest: 400 CREATE VIEW columns must be named, but column 1 has no name at [129:1]

  • moz-fx-data-shared-prod.firefox_accounts.fxa_content_auth_stdout_events

    google.api_core.exceptions.BadRequest: 400 CREATE VIEW columns must be named, but column 1 has no name at [134:1]

  • moz-fx-data-shared-prod.firefox_accounts.fxa_content_auth_events

    google.api_core.exceptions.BadRequest: 400 CREATE VIEW columns must be named, but column 1 has no name at [104:1]

Kik it looks like this is due to your bigquery-etl PR 3463 "feat(DENG-582): commented out fxa_content_ views logic and raising error using them".

Assignee: nobody → kignasiak
Status: NEW → ASSIGNED

Thanks for opening the bug, the following PR should address this error:
https://github.com/mozilla/bigquery-etl/pull/3490

Status: ASSIGNED → RESOLVED
Closed: 3 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.