alepuccetti · March 8, 2021 11:22
diff --git a/delayed_analytics.sql b/delayed_analytics.sql
 -- returning the total number of devices and events seen by the system at the beginning of the precious hours.
 SELECT
 count(distinct device_id) as devices,
 count(*) as events,
 FROM table_a
  FOR SYSTEM_TIME AS OF TIMESTAMP_TRUNC(TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR, HOUR));
diff --git a/point_in_time_analytics.sql b/point_in_time_analytics.sql
 -- returning the total number of devices and events seen by the system at a specific timestamp
 SELECT
 count(distinct device_id) as devices,
 count(*) as events,
 FROM table_a
  FOR SYSTEM_TIME AS OF “point_in_time_timestmap”;
 )
diff --git a/recover_table_point_in_time.sql b/recover_table_point_in_time.sql
 CREATE OR REPLACE TABLE `project.dataset.table_a_recovered` as (
 SELECT
  *
 FROM `project_id.datasaet_id.table_a` FOR SYSTEM_TIME AS OF “point_in_time_timestmap”;
 )
diff --git a/Time Travel with BigQuery.md b/Time Travel with BigQuery.md
diff --git a/time_travel_query_interval.sql b/time_travel_query_interval.sql
 SELECT
  *
 FROM `project_id.datasaet_id.table_a` FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 3 HOUR)
diff --git a/time_travel_query_point_in_time.sql b/time_travel_query_point_in_time.sql
 SELECT
  *
 FROM `project_id.datasaet_id.table_a` FOR SYSTEM_TIME AS OF "point_in_time_timestmap"
	-- returning the total number of devices and events seen by the system at the beginning of the precious hours.
	SELECT
	count(distinct device_id) as devices,
	count(*) as events,
	FROM table_a
	FOR SYSTEM_TIME AS OF TIMESTAMP_TRUNC(TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR, HOUR));
	CREATE OR REPLACE TABLE `project.dataset.table_a_recovered` as (
	SELECT
	*
	FROM `project_id.datasaet_id.table_a` FOR SYSTEM_TIME AS OF “point_in_time_timestmap”;
	)