
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




