Getting Started with Snowflake: Using Time Travel & the SnowSQL CLI

Data in Snowflake goes through a three-phase lifecycle: current data storage where the data is stored in regular database tables; Time Travel where you can access data from a specific time; and Fail-safe which preserves historical data for a configurable retention period. In this course learn how to use Time Travel to access historical data using query ID filters relative time offsets and absolute timestamp values. Next practice cloning historical copies of tables into current tables and restoring dropped tables with the UNDROP command. Finally discover how to install SnowSQL define and use variables and spool query results to files. Upon completion youll be able to utilize Time Travel and Fail-safe in Snowflake configure SnowSQL define and use variables and utilize SnowSQL features.