Data Loading in Snowflake: Unloading Data
Snowflake 2022
| Expert
- 12 Videos | 1h 13m 51s
- Includes Assessment
- Earns a Badge
Snowflake supports the bulk unloading, or export, of batch data using both internal and external stages. Begin this course by unloading data to all three types of internal stages - user, table, and named. Then, unload data to external stages on the Google Cloud Platform, Microsoft Azure, and Amazon Simple Storage Service (S3). Finally, query data directly from staged files, focusing on the syntax and restrictions of querying data in this manner. When you have completed this course, you will be able to unload data from Snowflake to all three types of internal storage, as well as externally to Google Cloud Storage buckets, Amazon S3 bucket, and Azure Blob Storage.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courserecognize how to unload data in Snowflakeunload data to user stagesunload data using table stagesunload data in JSON and Parquet formatsunload data to Google Cloud Storage buckets
-
unload data to Azure Blob Storage containersunload data to Amazon Simple Storage Service (S3) bucketsquery files in stagesquery table and named stagesquery external stagessummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 21sUP NEXT
-
2.Data Unloading in Snowflake4m 15s
-
3.Unloading Data in Snowflake to User Stages8m 12s
-
4.Unloading Data in Snowflake Using Table Stages9m 23s
-
5.Unloading Data in Snowflake to Named Stages6m 25s
-
6.Unloading Data in Snowflake to the GCP9m 43s
-
7.Unloading Data in Snowflake to Azure7m 44s
-
8.Unloading Data in Snowflake to Amazon S34m 23s
-
9.Querying Files in Snowflake Stages6m 50s
-
10.Querying Table and Named Stages in Snowflake7m 37s
-
11.Querying External Stages in Snowflake4m 58s
-
12.Course Summary2m 59s
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.