The dbt Accelerator by Mastering Snowflake
2h 57mIntermediate2026-07-15
Authors

Mastering Snowflake
Course details
As organizations increasingly rely on dbt to manage data transformations, the ability to build reliable, tested pipelines is essential for data professionals. This course guides you through dbt on Snowflake: from setting up your environment and building your first model to implementing advanced materializations, incremental loading, and Jinja macros.
Explore how to test and document your models, automate deployments with CI/CD pipelines, leverage the dbt Semantic Layer, and extend dbt with hooks and packages. Each module builds on the last, providing a structured path from foundational concepts to production-ready workflows through hands-on demonstrations that mirror real production environments.
Explore how to test and document your models, automate deployments with CI/CD pipelines, leverage the dbt Semantic Layer, and extend dbt with hooks and packages. Each module builds on the last, providing a structured path from foundational concepts to production-ready workflows through hands-on demonstrations that mirror real production environments.
Concepts
Introduction and Onboarding
- Welcome to the dbt Accelerator
- How to set up the Snowflake trial account
- How to set up the dbt Partner Connect account
- How to connect dbt to Snowflake (not Partner Connect)
- Prepare the Snowflake environment
- IDE orientation
Introduction to dbt
- What is dbt
- Creating your first model in dbt
- The reference function
- Modularity at work
- Configuring sources
- YAML files
- Source freshness
- Manifest file
Transforming Data with dbt
- Introduction to materializations
- Incremental data loading
- Incremental strategies
- Incremental demo
- Snapshots
- Reference data using seeds
Testing Pipelines with dbt
- Introduction to testing in dbt
- Generic tests in dbt
- Singular tests in dbt
Extending dbt
- Jinja
- Macros and DRY
- Hooks and operations
- Tagging
- Analyses
- Exposures
Deployment and Automation
- Custom schemas
- Documentation
- Environments
- Jobs
- Notifications
- Environment variables
- Continuous integration
Semantic Layer
- Connect dbt to the complete Jaffle Shop project
- Semantic layer
Example Project Walk-Through
- Jaffle Shop project walk-through