Complete Snowflake Tutorial

Data Engineering Simplified
2 min readAug 6, 2023

--

Check out my courses in Udemy. Popular course include building utility using Snowpark Python API to ingest CSV data as well as JSON data automatically without writing any DDL/DML statement and save 95% of manual effort.

Complete Snowflake Learning Guide & Playlist With SQL Scripts

Check out my free and paid courses in Udemy

Complete Snowflake Guide

You can watch the complete playlist containing 25 chapters covering all the fundamental concept of Snowflake Cloud Data Warehouse.

Complete Snowflake Tutorial & Study Material
Complete Snowflake Tutorial & Video Playlist

Chapter-01

Description coming soon…

Chapter-02

Description coming soon…

Chapter-03

Description coming soon…

Chapter-04

Description coming soon…

Chapter-05

Description coming soon…

Chapter-06

Description coming soon…

Chapter-07

This chapter focuses on the hierarchy concept of databases, schemas, tables, and containers. It provides hands-on exercises for creating tables with different types, constraints, and data loading methods, including standard and external tables and insert statements, create as select, insert as select, and copy commands. The tutorial also covers topics such as not-null constraints, case sensitivity with table names, describing tables, primary and unique key constraints, and querying external stages in Snowflake.

Chapter-08

Description coming soon…

Chapter-09

Description coming soon…

Chapter-10

Chapter-10 covers continuous data loading and data ingestion in Snowflake. The tutorial provides a hands-on approach to help data developers ingest streaming and micro-batch data using Snowpipe, a SQL object designed to support streaming data, delta data, and CDC data into Snowflake. The tutorial covers SnowPipe’s architecture, components, internal stages, and Python program, as well as monitoring and pausing/resuming pipes. The video guide includes live examples to explain Snowpipe’s most important features. This tutorial is a comprehensive guide to continuous data loading and data ingestion in Snowflake.

Chapter-11

Description coming soon…

Chapter-12

Description coming soon…

Chapter-13

Description coming soon…

Chapter-14

Description coming soon…

Chapter-15

Description coming soon…

Chapter-16

Description coming soon…

Chapter-17

Description coming soon…

Chapter-18

Description coming soon…

Chapter-19

Description coming soon…

Chapter-20

Description coming soon…

--

--

Data Engineering Simplified

Passionate About Data Engineering, Snowflake Cloud Data Warehouse & Cloud Native Data Services