SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ23

Implement Data Protection and Recovery

Database XYZ has its data_retention_time_in_days parameter set to 7 days, while table XYZ.public.ABC has data_retention_time_in_days set to 10 days.

A Developer accidentally dropped the database containing this only table 8 days ago and has just discovered the error.

How can the table be recovered?

Explanation

When a database is dropped, its 7-day database-level Time Travel retention governs recovery, and explicitly different retention values on child tables are not honored. After 8 days, the database has moved beyond Time Travel into Fail-safe; recovery during Fail-safe requires Snowflake Support.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!