Issue with Bigquery

[AlexDab]

from 10h00 26 april, in my project on bigquery my datasets and tables has been lost. Moreover bigquery doesn't execute my sql queries  that I've been regularly executing until yesterday. I didnt change anything from yesterday. The only message error I get is 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.

[kvandres]

Good day @AlexDab,

If your data are located in region europe-west9, There is currently an ongoing outage in the said region where multiple services are impacted including Dataflow due to water intrusion in a data center(europe-west9) which had affected multiple zones, currently there is not ETA when it will be solved but you can track the status of this outage using the link below.
https://status.cloud.google.com/incidents/TbcwMSkKy8MTmeeEiqaq

If this is your case, please check this documentation for disaster recovery:
https://cloud.google.com/bigquery/docs/reliability-disaster#use_cases_for_disaster_recovery

Hope it helps!

[databaseman]

That's very unsettling. Are you able to retrieve any data using the timetravel feature ?

SELECT *
FROM `mydataset.mytable`
FOR SYSTEM_TIME AS OF <DATE|TIMESTAMP>