Скачать или смотреть Snowflake Medallion Architecture: From JSON Files to Star Schema DWH

In this video I walk through building a complete Star Schema data warehouse model in Snowflake, using a Medallion Architecture starting from a raw JSON file as the source.

You’ll see step-by-step how I:

Ingest a JSON source file into Snowflake
Land the data in the Bronze layer
Clean and structure it into a Silver layer
Design and implement a Gold Star Schema (Fact + Dimension tables)
Use Type 1 SCD merging in SQL to keep dimensions up to date

=======================================

Timestamps:
0:00 Introduction
07:00 Snowflake features
14:00 Snowflake SQL
34:00 SCD Type1 merging

=======================================

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