If a schedule that previously ran without issues suddenly starts failing with the error like the following:
Error in bigrquery::bq_job_wait(job) : Job 'job_name' failed :
Unrecognized name: column_name at [13:9] [invalidQuery]
it indicates that the referenced column (column_name) no longer exists in the target table in Google BigQuery. In your actual error, this will be the name of the column your query is trying to access.
How to Fix It
Check the schema of the target BigQuery table to ensure the referenced column is present. If the column is missing, restore it or update your query accordingly, then rerun the schedule.