Accidentally deleted Bigquery data — data recovery

BigQuery matins a 7-day history and allows you to query a point-in-time snapshot of your data by using either table decorators or SYSTEM_TIME AS OF in the FROM clause. You can easily revert changes without having to request recovery from backups

To revert a change you can either use standard SQL or bq command-line tools.

For example,

bq cp project:dataset.table@-36000 project:dataset.table

This command will replace the table with data from the same table 1 hour ago.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store