what is time travel in bigquery?
Using big-query’s time travel concept we can access any modified(updated or delete) data. we can access this data till last 7 days. This concept in Bigquery help for creating backup and disaster recovery.
You can access data from any point within the time travel window, which covers the past seven days by default. Time travel lets you query data that was updated or deleted, restore a table or dataset that was deleted, or restore a table that expired.
Big query time travel – query for extracting data for last 24 hour.
CREATE OR REPLACE TABLE ch.restored_cycle_station AS
SELECT *
FROM bigquery-public-data.landon_bicycles.cycle_stations
FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 24 HOUR) The above query will extract data upto last 24 hours old copy.
More >> Read here