Improvement to running queries on historic data
Hi, I want to be able to query a table at a point in time. There maybe transactions or reloads that might have happened after my time of interest. I have concluded that the below are my options: 1) I can create a second table (or set of tables) and save the contents of the table(s) on which a snapshot should be taken. This is the only option that serves the purpose however it is not scalable after a certain point. 2) I can run historic queries by manipulating the HISTORY_RETENTION_* parameters. However TRUNCATE gets rid of all the historic data. 3) Database snapshots can be created but it is meant for backups and cannot be queried upon. I request a feature in future version, where a snapshot (or epoch) of a table(s), schema(s) or Database can be taken and historic queries be able to run off of it. Thank you. Zac.