1841062 - Airflow task bqetl_download_funnel_attribution.checks__ga_derived__downloads_with_attribution__v2 failed for exec_date 2023-06-29

Status: RESOLVED FIXED

(Data Platform and Tools :: General, defect)

Description

[Lucia Vargas]

Airflow task bqetl_download_funnel_attribution.checks__ga_derived__downloads_with_attribution__v2 failed for exec_date 2023-06-29

Task link:
https://workflow.telemetry.mozilla.org/log?dag_id=bqetl_download_funnel_attribution&task_id=checks__ga_derived__downloads_with_attribution__v2&execution_date=2023-06-27T23%3A00%3A00%2B00%3A00&map_index=-1

Log extract:

"Error in query string: Error processing job 'moz-fx-data-marketing- prod:bqjob_r77542d48c3576d75_0000018904768d60_1': Query parameter 'download_date' not found at [8:23] "

Comment 1

[Lucia Vargas]

The scheduler is not recognizing the query parameter download_date.
It might need to be added to the metadata E.g.

scheduling:
  parameters:
  - download_date:DATE:{{ds}}

Comment 2

[Lucia Vargas]

Monitoring this task today, ran successfully.