Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Big query [Schedule query issue]

RC1
Bronze 4
Bronze 4

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

 

 

 

0 1 626
1 REPLY 1