Introduction to dbt
Set up a dbt project, write SQL models, template them with Jinja and order them with ref, through interactive SQL and shell exercises.
dbt, the data build tool, organizes the extract, load and transform work of a data warehouse into a project of SQL-based models, with declared dependencies that make the models execute in the correct order. You learn what dbt is and when it should be used, then set up a project and its profile, create, update and troubleshoot models, simplify them with Jinja templates, and generate documentation for the result.
What You Will Achieve
- Initialize a dbt project, create its profile and run it with the dbt command
- Write SQL-based dbt models, adjust their config files and troubleshoot models that fail
- Use the ref function to declare hierarchical dependencies so models execute in the correct order
- Simplify repeated model code with Jinja templates and generate documentation for a project
Program Overview
Foundations of dbt and Project Setup
Why dbt exists, who uses it, and how a new project is created and configured before any models are written.
- The dbt command, versions and getting help
- Users of dbt
- Initializing a project
- Creating a project profile
Building and Updating SQL Models
What a dbt model is and the workflow for creating, running and changing models inside a first project.
- dbt project workflow
- Features of a data model
- Creating and updating models
- Config files and model issues
Documentation, Jinja Templates and Model Hierarchies
Generating project documentation, templating models with Jinja and ordering execution through hierarchical dependencies.
- dbt docs command options
- Documentation flow
- Processing Jinja templates
- Hierarchical model creation with ref
Certificate Awarded (Paid)
Job Outlook
dbt skills are used wherever teams build and maintain data warehouses, in data analyst, data engineering and analytics engineering work that turns loaded data into modeled, documented tables.
Good for: SQL users who already load data into a warehouse and want a structured, repeatable way to write and order their transformations.
Keep in mind: Building tests is named as a goal, yet no lesson covers it: the chapters center on project setup, models, Jinja templates, documentation and model hierarchies.
Bottom line: Its SQL and shell exercises cover the core dbt loop of initializing a project, writing models and declaring the order they run in.
Frequently Asked Questions
What is a dbt model?
In this course a dbt model is a SQL-based model inside a dbt project that transforms data. The lessons cover the features of a data model, how to create, update and troubleshoot one, and the config files around it.
How does dbt decide the order in which models run?
You declare the dependencies between models with the ref function, which builds a hierarchy. dbt then runs models in that order, and the last chapter has you create and update such hierarchies.
Which tools do the exercises use?
The exercises use SQL to write models and shell commands to run dbt, its documentation commands and project setup, working with real datasets inside an example data warehouse.
Is the course tied to one kind of data warehouse?
The exercises implement a single example warehouse, but the course presents its material as a foundation that applies whichever type of data warehouse you plan to build with dbt.


There are no reviews yet.