End-to-End Snowflake ETL: Convert JSON Data into a Star Schema with Medallion Architecture
This tutorial shows how to transform raw JSON data into a clean star schema in Snowflake using the Medallion architecture. You’ll follow the full ETL process through the Bronze, Silver, and Gold layers, learning how to structure, refine, and model your data into fact and dimension tables for efficient analytics and reporting.
=======================================
Timestamps:
00:00 Introduction
00:40 Snowflake Free Account
05:00 Role & Computation in Snowflake
11:13 Stages in Snowflake
26:17 SCD Type 1 & 2
=======================================
Repository:
➡️https://github.com/Mahdi-DE/Snowflake...
=======================================
Connect with me:
LinkedIn - / mahdi-nematshahi
Telegram - https://t.me/+uKYwZc8-kvk2ZjQ0
=======================================
For Collaboration 👇
[email protected]
=======================================
Join this channel to support my hardwork:
/ @gicloudalchemy