BigQuery Time Travel: Query Historical Data Up to 7 Days Back

BigQuery's time travel feature lets users query table data as it existed at any point within a configurable window of 2 to 7 days. To restore a table, copy historical data to a new table; for partial repairs, copy to a temp table first. Directly inserting from a time travel query into the same table fails due to snapshot timestamp conflicts.