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.
Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
B.
The transient table version cannot be retrieved after 24 hours.
C.
Contact Snowflake Support to have the data retrieved from Fail-safe storage.
D.
Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0e504b5
11 months, 1 week agotimcooks
1 year, 3 months agoMultiCloudIronMan
1 year, 5 months agogirgir
1 year, 10 months agofahfouhi94
1 year, 11 months agoSV1122
2 years agoLavpak
2 years, 1 month ago