Airbnb End-To-End Data Engineering Project (For Beginners) | DBT + Snowflake + AWS

End-To-End Data Engineering Project | Snowflake | DBT | AWS | AWS Data Engineer 🔍What You'll Learn? This is a complete 6-hour end-to-end Data Engineering project built using Snowflake, DBT, AWS, and Git. It’s beginner-friendly and focuses on real-world challenges like incremental data loads, dimensional data modeling, and the Medallion Architecture. If you want to learn this stack by actually building something hands-on, this project is perfect for you. Timestamps: 0:00 Introduction 1:29 Medallion Architecture 16:37 Tech Stack Fundamentals 27:50 AWS Account Setup 32:58 Snowflake Account Setup 36:28 Upload Data To S3 Buckets 41:37 Create Snowflake DB and Tables 47:09 Snowflake Stage With AWS IAM 1:07:11 Python, Git, VS Code Installation 1:16:39 DBT With Snowflake Adapter 1:24:25 DBT Init & Connection 1:31:20 DBT Profiles & YAML 1:44:22 Bronze Layer With DBT 1:54:07 DBT Models 2:11:28 DBT Sources 2:24:48 DBT Custom Schema 2:30:46 DBT Jinja Functions 2:51:12 Incremental Load With DBT 3:07:31 DBT Macros 3:19:38 Silver Layer With Upsert 3:58:11 Metadata Driven Pipelines 4:33:52 STAR Schema Data Model 4:48:07 DBT Snapshots for SCD Type-2 5:24:34 Data Quality With Data Tests Data Engineer Roadmap [WITH RESOURCES] https://github.com/anshlambagit/Data_Engineer_Roadmap Notes & Code Repository https://github.com/anshlambagit/Airbnb_Snowflake_DBT_Data_Engineer_Project WATCH MY PREVIOUS VIDEOS ➡️Azure End To End Data Project https://youtu.be/ESWqAZP2qA4?si=eWBmBQYOk5pMYfxh ➡️ Data Modeling Masterclass https://youtu.be/K7C1sWKQU-o?si=ExuraMvfpXtuzkku ➡️PySpark Full Course https://youtu.be/94w6hPk7nkM?si=i3u_8ZWkGf6fiGyh ➡️Databricks Tutorial https://youtu.be/7pee6_Sq3VY?si=pPBrTnE2R8PhhHu5 ➡️Apache Spark The Ultimate Guide https://youtu.be/FNJze2Ea780?si=MHszd1EpzUtFzZR9 ======================================= Join this channel to SUPPORT MY HARDWORK: https://www.youtube.com/channel/UCu7lQE-L5gzt8aD7zuuufjw/join ======================================= Connect with ME LinkedIn - https://www.linkedin.com/in/ansh-lamba-793681184/ Telegram - https://t.me/anshlambadatafam ========================= For COLLABORATION 👇 anshlambacollab@gmail.com ========================= ⭐Hashtags⭐ #dataengineering #snowflake #aws #dataengineer #pyspark