Data Loading in Snowflake: Fundamentals of Stages

Snowflake 2022    |    Intermediate
  • 17 videos | 2h 9m 27s
  • Includes Assessment
  • Earns a Badge
Snowflake is a modern data cloud solution/ platform that uses an abstraction known as a stage to provide bulk loading of data for analysis, resulting in faster query processing. Begin this course by exploring the internal and external stages in Snowflake. Then, you will load data using Snowflake's classic user interface (UI). Next, examine erroneous data and discover how to query the data and download the results. You will also load data from the stage into an actual table using the SnowSQL command-line interface. Finally, you will create and use table stages, as well as named stages. When you have completed this course, you will be able to differentiate between internal and external stages, list types and features of internal stages, and load data using the classic Snowflake UI.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    recognize internal and external stages in Snowflake
    outline how data is loaded in Snowflake
    recall how user, named, and table stages work
    set up a warehouse and table to load data
    create a file format and load data with errors
    load and query data
    load data and download query results
    explore queries executed under-the-hood while loading data
  • load data into the user stage
    load data from stages
    use named stages
    use table stages and validation mode
    use table stages and error modes
    create named stages
    load data from named stages
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1.  Course Overview
    1m 37s
  • Playable
    2.  Stages in Snowflake
    7m 12s
  • Locked
    3.  Data Loading in Snowflake
    8m 5s
  • Locked
    4.  Bulk Loading and Snowflake Stages
    7m 38s
  • Locked
    5.  Creating a Warehouse for Loading Data into Snowflake
    9m 12s
  • Locked
    6.  Loading Erroneous Data into Snowflake
    8m 34s
  • Locked
    7.  Loading Data into Snowflake
    7m 15s
  • Locked
    8.  Downloading Query Results from Snowflake
    9m 13s
  • Locked
    9.  Recognizing Limitations of the Classic Snowflake UI
    9m 5s
  • Locked
    10.  Loading Data into the User Stage of Snowflake
    8m 46s
  • Locked
    11.  Loading Data from Stages in Snowflake to a Table
    7m 19s
  • Locked
    12.  Using Named Stages in Snowflake
    4m 36s
  • Locked
    13.  Using Table Stages in Snowflake
    9m 51s
  • Locked
    14.  Using Error Modes for Table Stages in Snowflake
    10m 16s
  • Locked
    15.  Creating Named Stages in Snowflake
    10m 10s
  • Locked
    16.  Copying Data with Named Stages in Snowflake
    5m 49s
  • Locked
    17.  Course Summary
    4m 51s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Mastering Snowflake Solutions: Supporting Analytics and Data Sharing
Book Snowflake Architecture and SQL
Course Advanced Analytics: Performing Analytics Using Snowflake