Skip to main content

dbt (data build tool)

dbt is the modern standard for transforming data inside your warehouse. It brings software engineering best practices — version control, testing, documentation, and modular design — to SQL-based data transformation.

What You'll Learn​

  • The dbt project structure and how models work
  • Writing your first dbt model
  • Referencing other models with ref()
  • Testing data quality with schema tests and custom tests
  • Documenting your models in schema.yml
  • Running dbt in development and production

Lessons​

LessonDescription
Introduction to dbtWhat dbt is, how it fits into the modern data stack, and your first model
Prerequisites

Comfortable writing SQL queries. Familiarity with the command line is helpful.