A user created a database and set the DATA_RETENTION_TIME_IN_DAYS to 30, but did not set the DATA_RETENTION_TIME_IN_DAYS in table T1. After 5 days, the user accidentally drops table T1.
What are the considerations for recovering table T1?
A user created a database and set the DATA_RETENTION_TIME_IN_DAYS to 30, but did not set the DATA_RETENTION_TIME_IN_DAYS in table T1. After 5 days, the user accidentally drops table T1.
What are the considerations for recovering table T1?
The table can be recovered because the table retention period default is at the database level. When the DATA_RETENTION_TIME_IN_DAYS is set for a database, it applies to all tables within that database unless a different retention period is explicitly set for individual tables. Since the user did not set a specific retention period for table T1, it inherits the retention period of 30 days from the database.
https://docs.snowflake.com/en/user-guide/data-time-travel#specifying-the-data-retention-period-for-an-object:~:text=If%20a%20retention%20period%20is%20specified%20for%20a%20database%20or%20schema%2C%20the%20period%20is%20inherited%20by%20default%20for%20all%20objects%20created%20in%20the%20database/schema.
bb By default, the maximum retention period is 1 day (i.e. one 24 hour period). With Snowflake Enterprise Edition (and higher), the default for your account can be set to any value up to 90 days: When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command. If a retention period is specified for a database or schema, the period is inherited by default for all objects created in the database/schema. A minimum retention period can be set on the account using the MIN_DATA_RETENTION_TIME_IN_DAYS parameter. If this parameter is set at the account level, the data retention period for an object is determined by MAX(DATA_RETENTION_TIME_IN_DAYS, MIN_DATA_RETENTION_TIME_IN_DAYS).
bbbbbbbbbbb
A https://docs.snowflake.com/en/user-guide/data-time-travel#specifying-the-data-retention-period-for-an-object Changing the retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set. For example: If you change the retention period at the schema level, all tables in the schema that do not have an explicit retention period inherit the new retention period.
A says "after 30 days" which will not be possible in this scenario