Log In
0% completed
All Lessons
Free Lessons (4)
Introduction to dbt and Its Setup
Introduction to dbt
dbt Core, Cloud, BigQuery: Unveiling Data Transformation
Creating a dbt Project
Quiz: Introduction to dbt
Overview of the Project Architecture
Profiles
Folders Structure
Model Configurations
Accessing Compiled Code
Quiz: Project Architecture
Coding Challenge: Complete the project.yml File
Solution: Complete the project.yml File
Models
Creating a SQL Model
Referencing Another Model
Coding Challenge: Join Two Models
Solution: Join Two Models
Changing Model Configuration
Overriding Default Schema
Organizing the Models with Folders and Tags
Python Models
Quiz: Models
Sources
Setting Up and Referencing a Source
Loading CSV Data with Seeds
Quiz: Sources
Coding Challenge: Querying a Public Dataset
Solution: Querying a Public Dataset
Materializations
View
Table
Incremental Model with the MERGE Strategy
Incremental Model with the insert_overwrite Strategy
Ephemeral Models
Quiz: Materializations
Coding Challenge: Daily Incrementation
Solution: Daily Incrementation
Dynamic Models with Jinja
Introduction to Jinja
Project Variables
Environment Variables
Setting Up Jinja Variables
Iterations
Coding Challenge: Loop Through a List of Columns
Solution: Loop Through a List of Columns
Macros
Quiz: Jinja
Coding Challenge: Daily Aggregation Macro
Solution: Daily Aggregation Macro
Packages
Overview of Packages
Downloading a Package from dbt Hub
Using Macros from a Package
Creating Your First Package
Quiz: Packages
Coding Challenge: Pack Your Macro
Solution: Pack Your Macro
Advanced dbt Concepts
Data Tests
Targets
Snapshots
Hooks
Challenge: Store Model Runs Inside a Table
Solution: Store Model Runs Inside a Table
Analysis
Documentation
Go Even Further with dbt
Quiz: Advanced dbt Concepts
Challenge: Targets, Tests, and Documentation
Solution: Targets, Tests, and Documentation
Conclusion
Wrap Up
Learn Data Build Tools ( DBT )
/
...
/
Coding Challenge: Complete the project.yml File
Coding Challenge: Complete the project.yml File
Complete your first coding challenge!
We'll cover the following...
Challenge
Restaurant project
...