96.3k views
3 votes
For a permanent table Snowflake provides how many days of failsafe retention?

1 Answer

4 votes

Final answer:

Snowflake provides a default failsafe retention of 1 day for permanent tables, but it can be increased to a maximum of 90 days.

Step-by-step explanation:

The Snowflake platform offer a feature called 'Time Travel', which allows users to access historical versions of their data for a certain period. This period is defined by the 'Time Travel Retention' setting at the table level. By default, Snowflake retains data for 1 day if this setting is not specified. However, the number of days of failsafe retention can be increased up to a maximum of 90 days.

User Alexander Goldabin
by
7.6k points