A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
The correct approach to revert to the first version of a transient table, if it was created three days ago, is to use Time Travel. This is only possible if DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days. Otherwise, the changes made beyond the retention period cannot be retrieved. Snowflake’s Time Travel feature allows users to access historical data within the retention period specified.
correct answer
A use time travel https://community.snowflake.com/s/article/Time-Travel-Inherited-DATA-RETENTION-TIME-IN-DAYS-Parameter-Retained-in-Transient-Tables
Correct Answer
https://docs.snowflake.com/en/user-guide/tables-temp-transient
If the snowflake edition is Enterprise and can go up-to to 90 days. If time travel set to 90 days for Transient tables.
Correct
For transient table the time travel is from 0 to 1 days.