Snowflake for Data Engineers

2h 4m 8s
English
Paid
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 Snowflake for Data Engineers

Join premium to watch
Go to premium
# Title Duration
1 Introduction 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

Similar courses to Snowflake for Data Engineers

Case Study in Causal Analysis

Case Study in Causal AnalysisLunarTech

Category: Data processing and analysis
Duration 2 hours 3 minutes 34 seconds
Azure Data Pipelines with Terraform

Azure Data Pipelines with TerraformAndreas Kretz

Category: Azure, Terraform, Data processing and analysis
Duration 2 hours 15 minutes 58 seconds
Data Engineering on Azure

Data Engineering on AzureKristijan Bakarić

Category: Azure, Data processing and analysis
Duration 1 hour 20 minutes 57 seconds
Building APIs with FastAPI

Building APIs with FastAPIAndreas Kretz

Category: Python, Data processing and analysis
Duration 1 hour 35 minutes 40 seconds
Machine Learning A-Z : Become Kaggle Master

Machine Learning A-Z : Become Kaggle Masterudemy

Category: Python, Data processing and analysis
Duration 36 hours 23 minutes 54 seconds
Data Engineering on GCP

Data Engineering on GCPAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 17 minutes 33 seconds
Becoming a Better Data Engineer

Becoming a Better Data EngineerAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 46 minutes 10 seconds
Complete linear algebra: theory and implementation

Complete linear algebra: theory and implementationudemy

Category: Python, Data processing and analysis
Duration 32 hours 53 minutes 26 seconds
Apache Spark Certification Training

Apache Spark Certification TrainingFlorian Roscheck

Category: Python, Data processing and analysis
Duration 15 hours 13 minutes 1 second
Storing & Visualizing Time Series Data

Storing & Visualizing Time Series DataAndreas Kretz

Category: Data processing and analysis
Duration 2 hours 11 minutes 34 seconds