I have an on-prem SQL Server DB with many table using SQL Server’s temporal feature to to historical data. Our users use SQL Server’s native query “FOR SYSTEM_TIME AS OF ‘2024-….'” to query recent historical data.
We’d like to migrate the recent historical data to Snowflake, so that Time Travel can be used to do similar queries. After the project’s promotion date, we at least need to provide user with the last 60 days’ hsitory to query.
Is there a matured tool/process to do this migration? I tried to search arong and even ask ChatGPT. There seems no answer. Many mentioned Copy Into command. But this command does not seem to provide ability to load data into Snowflake table and keep the record’s timestamp as a historical timestamp for Time Travel purpose. It looks like only keep the data’s timestamp as of the time it is loaded.
Please help !
Tried “Copy Into” command, expected it has ability to specify a historical timestamp of the data load. But there is no such option.
Daniel Jin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.