How to build an ELT pipeline in 1 hour using industry-standard tools like dbt, Snowflake, and Airflow. This is a live coding tutorial where I walk you through the thought process and show you each step. We'll cover basic data modeling techniques (fact tables, data marts), Snowflake RBAC concepts, and how to orchestrate a dbt project using Airflow. Write in the comments section what data engineering topics you'd like to see in the future!

time stamp
0:00 – Introduction
1:35 – Setting up dbt + Snowflake
7:52 – Configure dbt_project.yml and packages
11:45 – Creating source and staging tables
17:41 – Transformed models (fact tables, data marts)
20:25 – Macro functions
24:23 – Generic and singular tests
29:35 – Providing models with airflow

Notes on live coding
https://bittersweet-mall-f00.notion.site/Code-along-build-an-ELT-Pipeline-in-1-Hour-dbt-Snowflake-Airflow-cffab118a21b40b8acd3d595a4db7c15

Who am I?
I'm Jay and I love making videos about travel, self-help and tech. I currently work in New York City as a data engineer, but I grew up in Malaysia and lived in the UK when I was 19. Back then I had no idea what life meant, moving to so many places and pursuing a career in tech. Today I've learned a lot and want to share my perspective through filmmaking.

Social
linkedin: https://www.linkedin.com/in/jayzern/
insta: https://www.instagram.com/jayzern/

Number of subscribers: 7,163

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.