BigQuery tables connected to Google Sheets suddenly vanished

[nzar]

Hi all,

Several BigQuery tables disappeared and I'm having trouble figuring out why that happened. I checked the activity log to make sure I did not delete them on accident, but there is only logs of the tables being created, but not deleted or moved. Is there a way to investigate this or restore the data?

Any help would be greatly appreciated. Thanks-

[kvandres · Accepted solution]

Good day @nzar,

Welcome to Google Cloud Community!

Your table might have been deleted due to the expirationTime configured to your table or dataset level so when it expired it was automatically deleted unless you haven't configured it, other reason, if there are other users to your project, they might have deleted it thru API. You can check this documentation to learn more about expiration time on tables: https://cloud.google.com/bigquery/docs/managing-tables#updating_a_tables_expiration_time

You can try to restore your deleted tables using time travel, by default the time travel window has a duration of 7 days so I recommend that you try restoring it as soon as you can. Otherwise, you won't be able to restore it, you can check these documentations on how to restore the table using the bq command. https://cloud.google.com/bigquery/docs/managing-tables#bq_5
https://cloud.google.com/bigquery/docs/time-travel#restore_a_table_from_a_point_in_time

Hope this helps!

[nzar]

Thank you