Skip to content

dbt

Open source

SQL transformation tool for building and testing data models

dbt preview

About dbt

dbt is a tool for transforming data inside a warehouse using SQL. It lets analysts and engineers turn raw tables into clean models that other people can trust and reuse.

What it does

You write each model as a SQL select statement in a project folder. dbt works out which models depend on which, then builds them in the right order. Tests check for problems such as duplicate keys or missing values, and documentation can be written next to the models so the project stays readable as it grows.

Who it's for

Analytics engineers, data analysts and data teams who already keep their data in a warehouse. It suits people who are comfortable with SQL and want version control, testing and review for their transformations.

Pricing and good to know

The core tool is open source under the Apache 2.0 licence, so it can be installed and run for free. A hosted version with a web interface and scheduling is offered separately. The tool does its work inside your warehouse, so warehouse costs still apply to every run.

Highlights

  • Write transformations as SQL select statements
  • Build models in the right order from their dependencies
  • Run tests for unique keys and missing values
  • Keep documentation next to the models
  • Track changes in version control and review them

Ratings & reviews

Rate dbt

Stars alone count straight away.0/300

Checking that you are human…

Was this page helpful?
Open source

Meltano

Open source ELT platform that runs data pipelines as code

Data Pipelines
Open source

Lightdash

Open source BI that builds on your dbt metrics

BI and Charts
Freemium

Fivetran

Managed connectors that move data into a warehouse or lake

Data Pipelines
Freemium

GitLab

Code hosting, merge requests, CI/CD and security in one place

Git & Version Control