BigQuery - Modify scheduled query

Question

I created a query that runs every hour and dumps to bigquery table. This is working fine. However I can't see from the UI how to manually trigger this query, or edit the schedule. Clicking Scheduled Queries takes me to a wizard for creating a new scheduled query. Is this functionality available in the BigQuery web UI?

You should be able to see the Scheduled Query list in the UI (both the new and the old versions). Is your query a scheduled query? — ECris
It was a query that I wrote in the query editor in the new UI, tested and then clicked Scheduled Query -> Create new schedule query under the query editor and set it output/overwrite a table every hour. — Mâtt Frëëman
Ah found it. The scheduled query was in a different project... Thanks ECris — Mâtt Frëëman

Felipe Hoffa Felipe Hoffa · Accepted Answer · 2019-09-05T17:58:18

Go to the scheduled query, click on 'edit'.

Then edit your query.

Then click on "schedule query", which in this context has the option "update scheduled query".

BigQuery - Modify scheduled query

1 Answers