If your (accidentally) changed a Google BigQuery Scheduled Query and would like to go back to the old working version you can do following.
First: Find last correct running job:
Open scheduled queries in your browser. Click on the name to get details and select a date at the next page. On the right site look for „Job“ and copy job id. Should looks like
12345678:scheduled_query_12qwas-12qwas-12qwas
Second: Open a console.
If not installed yet get BigQuery command line tools:
https://cloud.google.com/bigquery/docs/bq-command-line-tool
or you Google Cloud web console
If installed and configured you can call now
bq --format=prettyjson show -j <your_job_id>Maybe pipe it into a file, find the query, copy query, removed „\n“ in a text editor and you have it.