Snowflake - Build and Architect Data Pipelines Using AWS - Lab - Time Travel and Data Recovery

The video tutorial covers the use of SQL in Snowflake, focusing on setting up schemas, modifying data retention times, creating and testing tables, utilizing the time travel feature to query past data, and recovering deleted objects using the undrop command. It provides practical examples and commands to demonstrate these features effectively.

What is the default data retention time for tables in Snowflake?

How can you alter the data retention time for a table in Snowflake?

What happens to the data retention time of future objects created in a database with a specified retention time?

Describe the process to implement the time travel feature in Snowflake.

Explain how to create a snapshot of a table at a specific point in time.

What command is used to recover a deleted object in Snowflake?

What is the significance of setting a data retention time between one and 90 days in Snowflake?