How to Undelete BigQuery Tables Using Time Travel

  • 11/1/2022
  • One-minute read

One hour ago:

bq cp mydataset.table@-3600000 mydataset.table_restored

Absolute (ms since UNIX epoch) GMT: Wednesday, 26 May 2021 13:41:53 = 1622036513000 https://www.epochconverter.com/

bq cp mydataset.table@1622036513000 mydataset.table_restored

More on Bigquery time travel

gcpbigqueryclouddatatutorial