Snowflake for Data Engineers

2h 4m 8s
English
Paid

Course description

Snowflake is a next-generation cloud data storage solution that everyone is talking about today. The platform operates 100% in the cloud, providing flexible access to data, scaling on demand, and allowing for the integration of disparate sources, data sharing, and the execution of various analytical tasks. Snowflake is actively used by large companies, and the skill of working with this platform is becoming increasingly in demand among data engineers and analysts. To effectively use Snowflake, one must be able to prepare and integrate data, manage it within the platform, and connect with external tools and services. Therefore, knowledge of Snowflake is relevant not only for analysts but also for data engineers.
Read more about the course

What you will learn

In this hands-on course, you will gain all the basic knowledge needed to start working with Snowflake immediately.

  • We will start with the basics: what Snowflake is, who uses it, and how it fits into the data processing platform architecture.
  • Then you will move on to practice:
    • get acquainted with an e-commerce dataset,
    • set up Snowflake and SnowSQL,
    • create tables, file formats, and load data through internal staging areas by uploading CSV files from your computer.

You will also:

  • create visual reports in Snowflake,
  • connect Power BI to Snowflake for building dashboards,
  • learn how to execute SQL queries via Python,
  • set up and run automated tasks,
  • test a complete ETL pipeline.

Working with AWS and automation

At the end of the course, you will learn how to integrate Snowflake with AWS S3:

  • first, manually import data from external staging areas,
  • then set up automatic loading via Snowpipe.

What's included in the course

  • Source codes
  • Links to useful resources
  • Prepared data for work

Requirements

  • Knowledge of the basics of relational databases
  • AWS account for integration with S3

Watch Online

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 21 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Introduction

All Course Lessons (21)

#Lesson TitleDurationAccess
1
Introduction Demo
02:07
2
Snowflake basics
04:17
3
Data Warehousing bascis
04:14
4
How Snowflake fits into data platforms
03:15
5
Snowflake Account setup
04:25
6
Creating your warehouse & UI overview
04:16
7
Our dataset & goals
03:02
8
Setup Snowflake database
10:30
9
Preparing the upload file
08:32
10
Using internal stages with snowsql
12:38
11
Splitting a data table into two tables
06:39
12
Creating a visualization worksheet
07:09
13
Creating of a dashboard
05:24
14
Connect PowerBI to Snowflake
06:04
15
Query data with Python
07:36
16
Create import task
09:19
17
Create table refresh task
03:41
18
Test our pipeline
03:15
19
Working with external stages for AWS S3
10:21
20
Implementing snowpipe with S3
06:20
21
Summary
01:04

Unlock unlimited learning

Get instant access to all 20 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

The Data Engineering Bootcamp: Zero to Mastery

The Data Engineering Bootcamp: Zero to Mastery

Sources: zerotomastery.io
Learn to build streaming pipelines with Apache Kafka and Flink, create data lakes on AWS, run ML workflows on Spark, and integrate LLM models into...
13 hours 23 minutes 15 seconds
The Data Bootcamp: Transform your Data using dbt™

The Data Bootcamp: Transform your Data using dbt™

Sources: udemy
Are you looking for a cutting-edge way to extract load and transform your data? Do you want to know more about dbt™ and how to use it? Well, this is the course
4 hours 10 minutes 51 seconds
Schema Design Data Stores

Schema Design Data Stores

Sources: Andreas Kretz
During my coaching sessions, one important topic repeatedly comes up - designing diagrams. Therefore, I decided to create a separate course in the academy to...
2 hours 30 minutes 25 seconds
Deep Learning: Advanced Computer Vision

Deep Learning: Advanced Computer Vision

Sources: udemy
This is one of the most exciting courses I’ve done and it really shows how fast and how far deep learning has come over the years. When I first started my deep
15 hours 10 minutes 54 seconds
Dockerized ETL With AWS, TDengine & Grafana

Dockerized ETL With AWS, TDengine & Grafana

Sources: Andreas Kretz
Data engineers often need to quickly set up a simple ETL script that just does its job. In this project, you will learn how to easily implement...
29 minutes 12 seconds