Hi folks I got a weird issue in Big Query's schedule query section around 2022-10-11 22 : hour UTC. My queries don't have any arguments as well as sql related error. Why did I get this error ? Is this something from GCP side ? What should I do in order to avert these kind of errors ?
EDIT : My schedule queries do query on Biglake tables on GCS using external connection
Job scheduled_query_633dbcd9-0000-2919-8479-f4030438ebe4 (table )
failed with error INVALID_ARGUMENT:
An internal error occurred and the request could not be completed.
This is usually caused by a transient issue.
Retrying the job with back-off as described in the BigQuery SLA
should solve the problem: https://cloud.google.com/bigquery/sla.
If the error continues to occur please contact support at https://cloud.google.com/support. at [4:44];
JobID: 487768604647:scheduled_query_633dbcd9-0000-2919-8479-f4030438ebe4
Job scheduled_query_634520ab-0000-2147-9f7d-f40304393fb8 (table )
failed with error UNAVAILABLE: Error encountered during execution.
Retrying may solve the problem.;
JobID: 487768604647:scheduled_query_634520ab-0000-2147-9f7d-f40304393fb8