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 courserecognize internal and external stages in Snowflakeoutline how data is loaded in Snowflakerecall how user, named, and table stages workset up a warehouse and table to load datacreate a file format and load data with errorsload and query dataload data and download query resultsexplore queries executed under-the-hood while loading data
-
load data into the user stageload data from stagesuse named stagesuse table stages and validation modeuse table stages and error modescreate named stagesload data from named stagessummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 37sUP NEXT
-
2.Stages in Snowflake7m 12s
-
3.Data Loading in Snowflake8m 5s
-
4.Bulk Loading and Snowflake Stages7m 38s
-
5.Creating a Warehouse for Loading Data into Snowflake9m 12s
-
6.Loading Erroneous Data into Snowflake8m 34s
-
7.Loading Data into Snowflake7m 15s
-
8.Downloading Query Results from Snowflake9m 13s
-
9.Recognizing Limitations of the Classic Snowflake UI9m 5s
-
10.Loading Data into the User Stage of Snowflake8m 46s
-
11.Loading Data from Stages in Snowflake to a Table7m 19s
-
12.Using Named Stages in Snowflake4m 36s
-
13.Using Table Stages in Snowflake9m 51s
-
14.Using Error Modes for Table Stages in Snowflake10m 16s
-
15.Creating Named Stages in Snowflake10m 10s
-
16.Copying Data with Named Stages in Snowflake5m 49s
-
17.Course Summary4m 51s
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.