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:
Oben 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
Second: Open a console.
If not installed yet get BigQuery command line tools:
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.