• Online, Self-Paced
Course Description

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, you'll be able to utilize Time Travel and Fail-safe in Snowflake, configure SnowSQL, define and use variables, and utilize SnowSQL features.

Learning Objectives

{"discover the key concepts covered in this course"}

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration