1. Time travel, user can set and retrieve data going back to history, based on their snowflake edition and object or account specific time travel (day-data_retention_time_in_days) setup.
2. Fail safe , user does not have control on retrieval of data applicable only after time travel period is over . In this scenario only Snowflake support can help up til 7 days only. So if you have set time travel as 6 days (Assuming) then you yourself can retrieve db objects after the transaction execution + 6 days of time. from 7th to 13th days post transaction execution snowflake support can help to retrieve your objects. After 13th days objects can not be retrieved or restored back
Posted Date:- 2021-10-07 05:15:43
What is the difference between Time-Travel vs Fail-Safe in Snowflake ?
How many days is the time travel history preserved in Snowflake ?
How does data compression works in Snowflake ?
What is Fail-safe in Snowflake?
What is the Query processing layer?
What are the various ways to access the Snowflake Cloud data warehouse?
Explain what type of database Snowflake is?
Briefly explain about different Snowflake editions?
Explain Fail-safe in Snowflake?
Where is metadata stored in Snowflake?
Explain Snowflake Time Travel?
What are the advantages of snowflake schema?
What are the cloud platforms currently supported by Snowflake?
What is a Columnar database and what are its benefits ?
What kind of SQL does Snowflake use?
What is the difference between star schema and snowflake schema?
What does Snowflake computing do?
What does the Cloud Services Layer do in Snowflake ?
What are the features of Snowflake?
Can you explain how Snowflake is different from AWS?
Who are the competitors to Snowflake?
What are the three layers of Snowflake architecture?
How do you check Snowflake history?
How is Snowflake different from redshift?
How do you execute a snowflake procedure?
What database does Snowflake use?
Does Snowflake support stored procedures?
How data is secured in Snowflake?
Give a brief idea about the Snowflake cluster?
How can we access the Snowflake data warehouse?
List out the different number of ways that can be used to access the Snowflake cloud data warehouse?
Give a brief description of software architecture?
Can AWS glue connect to Snowflake?
How is Snowflake distinct from AWS?
How is data stored in Snowflake?
What does the Cloud Services Layer do in Snowflake ?
What does the Compute Layer do in Snowflake ?
What does the Storage Layer do in Snowflake ?
What is Snowflake Architecture ?
What type of tool is Snowflake?