CODEWITHSUNDEEP
google-bigquery
Tuan Vu
Tuan Vu

Reputation: 716

Restore overwritten table in BigQuery

How can I restore accidentally overwritten table in BigQuery? I have tried to do a copy (bq cp) of a snapshot by timestamp previous to the overwritten timestamp but it does not work.

bq cp my_table@1480406400000 new_table

Upvotes: 1

Views: 2232

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172993

This might be equivalent to Undeleting a Table which is possible within two days (and performed on a best-effort basis and are not guaranteed)

Timestamp in your question looks like 3-4 days back - so that's might be an explanation

As an option try to query that snapshot and see if old data is still there.

Upvotes: 1

Related Questions