In this video, I walk through the first Spill the dbt challenge:
- migrating a SQL script to a dbt project,
- adding tests, modularity, documentation
- and sharing your work on GitHub.
Develop your skills by tackling these dbt challenges:
Spill the dbt - https://github.com/wjsutton/spill_the_dbt
00:00 Intro
01:17 Working on the Code locally
03:07 Setting up a branch with Git
04:13 Setting up a virtual environment and install packages
06:17 init dbt project
08:03 Verify the SQL script runs on python and/or dbeaver
09:51 Setting profiles.yml
11:01 Migrate SQL script to create a dbt model
12:58 Run and debug a dbt model
15:09 Add basic tests to a dbt model
16:50 Modularise code for a dbt model
18:36 Generate documentation
20:14 Build the dbt model and commiting code to GitHub
23:30 Outro