This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Playbook for dbt™
Introduction
Welcome / Course Overview (4:58)
What is dbt? (2:18)
The dbt Viewpoint (4:49)
Full Course Slides (PDF)
My Final Project (.zip)
Environment Setup
Environment Setup (Intro) (0:57)
Intro to Git (0:55)
Install Git (3:54)
Intro to Python (1:02)
Install Python (2:50)
Install VS Code (2:54)
Setup Github Account (2:27)
Setup Snowflake Account (Trial) (3:54)
Goals & Target DB Architecture (4:44)
Configure Snowflake (2:58)
Download dbt CLI (7:23)
Upgrading PIP (if error) (1:41)
Initialize a Project (6:29)
Recap (0:45)
Configure Your Project
dbt Project Overview (5:45)
profiles.yml (6:04)
Working w/ Git (Pt 1) (7:26)
Working w/ Git (Pt 2) (4:08)
Brief intro to YML (4:19)
Build Your Project (Pt 1)
Review SQL + Jinja (3:13)
Sources & Models (2:59)
Add Sources (8:49)
Best Practice: Naming Conventions (4:34)
Create "Staging" Models (17:42)
Merge Changes to GitHub (3:24)
Custom Schemas (8:30)
Using the "ref" function (2:55)
Materializations (3:31)
Quick Intermission
2 Quick Notes
Build Your Project (Pt 2)
Intro to Macros (1:49)
Using Macros (6:42)
Project Configs (3:46)
Variables (2:59)
Create "Warehouse" & "Reporting" Models (6:42)
Intro to Targets (3:17)
Using Targets (4:43)
Seeds & Packages
Seeds (4:28)
Packages (3:57)
Testing & Documentation
Intro to Tests (3:18)
Singular Tests (1:54)
Generic Tests (2:30)
Custom Tests (3:03)
Documentation (4:40)
Putting It All Together (3:45)
CI/CD & Scheduling
GitHub Actions (15:10)
Create a Cron Job (3:20)
dbt CLI Recap (0:50)
dbt Cloud
Intro to dbt Cloud (0:46)
dbt Cloud Setup (5:33)
dbt Cloud Layout (10:36)
dbt Cloud Workflow (7:19)
dbt Cloud APIs (1:42)
Closing
Closing & Next Steps (2:29)
Closing & Next Steps
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock