🔧 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... [Weiterlesen]