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

Snowflake 2022    |    Beginner
  • 13 Videos | 1h 25m 59s
  • Includes Assessment
  • Earns a Badge
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.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    outline data storage in Snowflake
    configure a table for Time Travel
    use query IDs and time offsets for Time Travel
    clone historical copies of data
    restore dropped tables
    download and set up SnowSQL on Mac
  • download and set up SnowSQL on Windows
    execute queries from SnowSQL
    run queries from script files
    define and use variables in SnowSQL
    write out query results to files
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    52s
    UP NEXT
  • Playable
    2. 
    The Phases of Snowflake Data Storage
    2m 54s
  • Locked
    3. 
    Configuring a Table for Time Travel
    7m 1s
  • Locked
    4. 
    Using Query IDs and Time Offsets for Time Travel
    7m 32s
  • Locked
    5. 
    Cloning Historical Copies of Data Using Timestamps
    10m 3s
  • Locked
    6. 
    Restoring Dropped Tables
    5m 36s
  • Locked
    7. 
    Installing SnowSQL on Mac
    10m 32s
  • Locked
    8. 
    Installing SnowSQL on Windows
    7m 29s
  • Locked
    9. 
    Executing Queries from SnowSQL
    8m 43s
  • Locked
    10. 
    Running Queries in Source Files
    5m 52s
  • Locked
    11. 
    Defining and Using Variables
    9m 39s
  • Locked
    12. 
    Writing Out Query Results to Files
    6m 50s
  • Locked
    13. 
    Course Summary
    2m 57s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.