dbt is a transformation and testing framework for analytics engineering teams working primarily in SQL warehouses. It provides version-controlled models, data tests,...
Pros
- Combines transformations, tests, documentation, and lineage in one workflow
- Excellent fit for teams already managing warehouse SQL with Git
- Tests run naturally in CI and deployment pipelines
Cons
- Does not provide general-purpose row-level cross-database diffs by itself
- Best suited to SQL warehouse transformations rather than arbitrary source systems
- Cloud features and collaboration add subscription costs
Free (Core); Cloud from $100/user/mo
