Undrop for recovering dropped objects in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the UNDROP command do in Snowflake?

The UNDROP command recovers a dropped object, such as a table or schema, restoring it to its state before deletion.

beginner

Which types of objects can you recover using UNDROP in Snowflake?

You can recover tables, schemas, and databases that were dropped, as long as they are within the retention period.

intermediate

What is the retention period for dropped objects in Snowflake before they are permanently deleted?

Dropped objects are retained for a default period of 1 day (24 hours), but this can be extended up to 90 days depending on account settings.

intermediate

How do you find the name of a dropped object to use with UNDROP?

You can use the SHOW <object_type> HISTORY command (where <object_type> is TABLES, SCHEMAS, or DATABASES) to see recently dropped objects and their names.

beginner

What happens if you try to UNDROP an object that no longer exists in the dropped objects list?

The UNDROP command will fail because the object is permanently deleted and cannot be recovered.

What is the main purpose of the UNDROP command in Snowflake?

A To recover a dropped object

B To permanently delete an object

C To rename an object

D To create a new object

UNDROP is used to recover objects that were dropped, restoring them to their previous state.

Which of the following helps you find recently dropped objects in Snowflake?

A INFORMATION_SCHEMA.SCHEMATA

B INFORMATION_SCHEMA.TABLES

C INFORMATION_SCHEMA.COLUMNS

D SHOW TABLES HISTORY

The SHOW TABLES HISTORY command lists objects that were recently dropped and can be recovered.

How long is the default retention period for dropped objects in Snowflake?

A 90 days

B 7 days

C 24 hours

D 30 days

By default, dropped objects are kept for 24 hours before permanent deletion, but this can be extended up to 90 days depending on account settings.

What happens if you try to UNDROP an object after the retention period has expired?

A The command fails because the object is permanently deleted

B The object is recovered anyway

C The object is renamed

D The retention period is extended automatically

Once the retention period expires, the object is permanently deleted and cannot be recovered.

Which of these objects can you NOT recover with UNDROP?

A A dropped table

B A dropped file in external storage

C A dropped database

D A dropped schema

UNDROP only works for Snowflake objects like tables, schemas, and databases, not external files.

Explain how to recover a dropped table in Snowflake using the UNDROP command.

Think about how to find the dropped object and the command syntax.

Describe the retention period concept for dropped objects in Snowflake and its importance.

Consider why Snowflake keeps dropped objects temporarily.