1693370 - moz-fx-data-shared-prod bigquery-etl-dryrun Cloud Function Not Found

Status: RESOLVED FIXED

(Data Platform and Tools Graveyard :: Operations, defect)

Description

[Anna Scholtz [:ascholtz]]

There seems to be a problem with the bigquery-etl-dryrun Cloud Function. https://us-centrmoz-fx-data-shared-prod.cloudfunctions.net/bigquery-etl-dryrun returns a 404 Not Found. Looking into the GCP console, bigquery-etl-dryrun is listed as cloud functions but clicking on it for more details shows:

Failed to load. 

There was an error while loading /functions/details/us-central1/bigquery-etl-dryrun?project=moz-fx-data-shared-prod. Please try again. 

Comment 1

[Jason Thomas [:jason]]

https://us-central1-moz-fx-data-shared-prod.cloudfunctions.net/bigquery-etl-dryrun is the actual trigger URL. Did something change in our configuration?

Comment 2

[Anna Scholtz [:ascholtz]]

Yes, that is the trigger URL that has been used in bigquery-etl for quite a while: https://github.com/mozilla/bigquery-etl/blob/2306620c8d41a75a17a2840e494cbc408a553d44/bigquery_etl/dryrun.py#L188
Not sure if there have been any recent configuration changes, but it just started failing earlier today.

Ah I misread, looks like the URL changed...

Comment 3

[Anna Scholtz [:ascholtz]]

Ah looks like bigquery-etl is using the right URL. All good.