Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
The dbt Accelerator by Mastering Snowflake

The dbt Accelerator by Mastering Snowflake

2h 57mIntermediate2026-07-15

Authors

Mastering Snowflake

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.

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

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
Zarinpal
Zibal