Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Snowflake - Datawarehouse and Datalake solutions using AWS

person icon Siddharth Raghunath

4.4

Snowflake - Datawarehouse and Datalake solutions using AWS

Data engineering and architecting pipelines using snowflake & AWS cloud

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Siddharth Raghunath

English [CC]

category icon Development ,Data Science,Big Data

Lectures -97

Resources -12

Duration -8.5 hours

Lifetime Access

4.4

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Snowflake is the next big thing and it is becoming a full-blown data eco-system. With the level of scalability & efficiency in handling massive volumes of data and also with several new concepts in it, this is the right time to wrap your head around Snowflake and have it in your toolkit. This course not only covers the core features of Snowflake but also teaches you how to deploy python/pyspark jobs in AWS Glue and Airflow that communicate with Snowflake, which is one of the most important aspects of building pipelines. 

Anyone who has a basic understanding of the cloud and belongs to one of the below backgrounds can benefit from this course :

  • Data Scientists / Analysts 
  • Data Engineers / Software Developers 
  • SQL Programmers or DBAs 
  • Aspiring Data analysts and scientists who are learning SQL and Python

This course covers : 

  • What is Snowflake 

  • Most Crucial Aspects of Snowflake in a very practical manner 

  • Writing Python/Spark Jobs in AWS Glue Jobs for data transformation

  • Real-Time Streaming using Kafka and Snowflake 

  • Interacting with External Functions & use cases

  • Security Features in Snowflake 

Important Note -  You need to have an active AWS Account to perform tasks in sections related to Python and PySpark. This course will help you with Snowpro certifications as well 

Goals

  • Snowflake as a data warehouse & automated pipelines within the Snowflake ecosystem
  • Use AWS Cloud with Snowflake as a Data-warehouse/Data lake
  • Integrating real-time Streaming Data and Data orchestration with Airflow and Snowflake
  • Enough Knowledge to clear SnowPro Certification

Prerequisites

  • Knowing SQL or at least some prior knowledge in writing queries 

  • Scripting in Python (or any language )

  • Willingness to explore, learn and put in the extra effort to succeed 

  • An active AWS Account & know-how of basic cloud fundamentals

    • Prior programming experience in SQL and Python is a must.

    • Prior basic experience or understanding of cloud services like AWS is important

Snowflake - Datawarehouse and Datalake solutions using AWS

Curriculum

Check out the detailed breakdown of what’s inside the course

Course Introduction

3 Lectures
  • play icon Course Roadmap 02:54 02:54
  • play icon Prerequisites and How to Success in this course 02:51 02:51
  • play icon Repo for the Course

Introduction to Snowflake and AWS

9 Lectures
Tutorialspoint

Snowflake - Tables

6 Lectures
Tutorialspoint

Snowflake - Partitioning , Clustering and Performance Optimization

9 Lectures
Tutorialspoint

Snowflake - Data Loading/Ingestion and Extraction

9 Lectures
Tutorialspoint

Snowflake - Tasks and Query Scheduling

4 Lectures
Tutorialspoint

Snowflake - Streams and Change Data Capture

11 Lectures
Tutorialspoint

Snowflake - User Defined Functions

7 Lectures
Tutorialspoint

Snowflake - External Functions

7 Lectures
Tutorialspoint

Snowflake with Python,Spark and Airflow on AWS

12 Lectures
Tutorialspoint

Real Time Streaming with Kafka and Snowflake

6 Lectures
Tutorialspoint

Snowpark - For Data Pipelines and Data Science

8 Lectures
Tutorialspoint

Snowflake - Data Protection and Governance

6 Lectures
Tutorialspoint

Instructor Details

siddharth raghunath

siddharth raghunath

I am a Business oriented Data Architect with a vast experience in the field of Software Development,Distributed processing and data engineering on cloud . I have worked on different cloud platforms such as AWS & GCP and also with on-prem hadoop clusters. I also give seminars on Distributed processing using Spark , real time streaming and analytics and best practices for ETL and data governance.I am also a passionate coder ,love writing and building optimal data pipelines for robust data processing and streaming solutions .

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515