Load Data into Snowflake
Making data available to analyze is a key event for any data analyst. This course will teach you the skills needed to load data into a Snowflake data warehouse and monitor the progress of the data load.
What you'll learn
Data is as valuable as gold these days. To gain insights from large amounts of data, it's important to efficiently load data into the right tool for the job.
In this course, Load Data into Snowflake, you’ll gain the ability to load data into Snowflake and monitor the progress of the data load operation.
First, you’ll explore the different methods to load data into Snowflake.
Next, you’ll discover loading data files into Snowflake with the web UI and use the COPY command to bulk load data.
Finally, you’ll learn how to monitor the status of the data loading operations.
When you’re finished with this course, you’ll have the skills and knowledge of loading data into Snowflake needed to successfully analyze data in Snowflake.
Table of contents
- Introduction 2m
- Snowflake Data Loading Methods 3m
- Monitoring Data Loading Operations 2m
- Demo: Load Data Files Using Snowflake Web UI 2m
- Demo: Use Copy Statement to Bulk Load Data into Snowflake 2m
- Demo: Monitor Status of Data Loading Operations in Snowflake UI 2m
- Demo: Monitor Data Loading Operations with SQL 2m
- Summary 1m
About the author
Matt Stenzel is a Data and AI Cloud Solution Architect at Microsoft. He has 15+ years of experience in the data and analytics industry working in various roles including a software developer, data engineer, DW developer, DBA and integration architect. He has spent the last 8 years working at Microsoft helping companies across the US successfully implement Azure solutions that provide business value.