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?

Question

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?

Kehinde Ifarinde · Accepted Answer

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

Kehinde Ifarinde · Answer

The transient table version cannot be retrieved after 24 hours.

Kehinde Ifarinde · Answer

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

Kehinde Ifarinde · Answer

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 177 - COF-C02 discussion

Suggested answer: A

0 comments