BigQuery time travel is pretty neat

SELECT * FROM `mydataset.mytable` FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR); That query allows you to get data from the table as it was an hour ago. In a setup where th...