Moving Data with Snowflake

Focused View

Mohit Batra

1:22:03

59 View

1. Course Overview

1. Course Overview.mp4

01:20

2. Getting Started with Snowflake

1. Introduction and Course Outline.mp4

01:21

2. Setting up Snowflake Environment.mp4

06:04

3. Configuring SnowSQL.mp4

01:56

4. Understanding Data Loading Options.mp4

05:04

5. Summary.mp4

01:17

3. Working with Batch Data in Snowflake

1. Introduction.mp4

00:46

2. Understanding Batch Loading Process.mp4

03:27

3. Working with Stages.mp4

08:43

4. Configuring External Stages.mp4

08:42

5. Working with External Tables.mp4

05:05

6. Loading CSV Data Using COPY Command.mp4

10:36

7. Loading JSON & Parquet Data Using COPY Command.mp4

05:18

8. Unloading Data from Snowflake.mp4

02:43

9. Summary.mp4

01:46

4. Working with Streaming Data in Snowflake

1. Introduction.mp4

00:38

2. Understanding Snowpipe.mp4

03:51

3. Loading Streaming Data Using Snowpipe.mp4

03:35

4. Automating Snowpipe Refresh.mp4

07:58

5. Summary.mp4

01:53

Description

In this course, you'll learn how to build batch and streaming pipelines in Snowflake - by understanding data load options, securely connecting to external stores & querying them, handling errors, and working with structured & semi-structured formats.

What You'll Learn?

Snowflake is one of the most popular cloud data platforms. It allows data storage, data processing, and analytics at massive scale, with extremely less administrative effort, one of the key areas for any data platform is to build data pipelines.

In this course, Moving Data with Snowflake, you’ll learn how to quickly & reliably, ingest the data into the tables of Snowflake database - by building Batch and Streaming pipelines in Snowflake.

First, you’ll delve into each different data loading options in Snowflake.

Then, you’ll see how the batch loading process works in Snowflake - how to connect to external data stores, like Azure Storage; and how to directly query the files in Snowflake.

Next, you’ll explore how to work with structured, and semi-structured file formats, like CSV, JSON, and Parquet.

finally, you’ll see how to process streaming data in Snowflake – how to continuously load the data using Snowpipe; and how to automate this loading process.

By the end of this course, you’ll have the knowledge and skills, to Move Data with Snowflake, by building batch and streaming pipelines.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Big Data

Mohit Batra

Instructor's Courses

Mohit is a Data Engineer, a Microsoft Certified Trainer (MCT) and a consultant. Mohit has 15+ years of extensive experience in architecting large scale Business Intelligence, Data Warehousing and Big Data solutions with companies like Microsoft and some leading investment banks. As an expert in his field, Mohit has often shared his knowledge in Azure, Spark, SQL Server and Power BI at various public forums and as a corporate trainer. Mohit truly loves to teach and enjoys producing high-quality, engaging learning materials for his sessions. In his free time, Mohit loves to read, enjoys photography and music.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.