Wouter Zorgdrager
05/27/2024, 7:00 AMMartijn Visser
05/27/2024, 7:01 AMWouter Zorgdrager
05/27/2024, 7:02 AMMartijn Visser
05/27/2024, 7:03 AMWouter Zorgdrager
05/27/2024, 7:03 AMWouter Zorgdrager
06/18/2024, 8:55 AMFROM telemetry_tbl AS l
LEFT JOIN versioned_tbl
FOR system_time AS OF l.timestamp AS r
ON l.unique_id = r.unique_id
WHERE CURRENT_WATERMARK(r.timestamp) IS NULL
OR TIMESTAMPADD(HOUR, 24, r.timestamp) > CURRENT_WATERMARK(r.timestamp)
such that it will keep the latest version of the versioned table up and until 24h after the last watermark?