What is dbt?
dbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.
Categories & Use Cases
Top Performing Features
Simple transformations
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
Category average: 8.1
Collaboration
Collaboration is enabled by a shared repository of project information and metadata
Category average: 7.3
Data model creation
Ability to create and maintain data models using a graphical tool to define relationships between data
Category average: 8.4
Areas for Improvement
Business rules and workflow
Ability to define and manage business rules and workflows
Category average: 8.3
Metadata management
Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management
Category average: 7.9
Testing and debugging
Tool to debug and tune for optimal performance
Category average: 7
