What is dbt?
dbt (data build tool) allows analytics engineers to write SQL SELECT statements and dbt handles the materialisation — creating views, tables, or incremental models in your data warehouse automatically.
Why Teams Love dbt
- Version Control: All SQL models live in a Git repository, enabling code review and rollback.
- Testing: Define schema tests (not null, unique, referential integrity) that run automatically with every deployment.
- Documentation: Auto-generate a data catalogue with column descriptions and lineage graphs from your model files.
- Lineage: Visualise the full dependency tree from raw source tables to final BI-ready models.