dbt (data build tool)

dbt lets analysts transform data in their warehouse using SQL SELECT statements. It applies version control, testing, documentation, and CI/CD to data transformations. Used by 30,000+ companies, it is the standard for analytics engineering.

Starting Price

Free (dbt Core open-source)

Rating

4.6/5

Reviews

7,800

SW Score

Features

91%

Reviews

93%

Momentum

90%

Popularity

95%

Overall rating based on user reviews and product dataAvg: 92%

Key Advantages

Analysts write transformations in SQL, dbt handles dependencies
Built-in testing framework ensures data quality
Auto-generated documentation stays in sync with code

Potential Drawbacks

dbt Core requires technical setup, dbt Cloud has costs
Strong SQL skills are a prerequisite

Key Features

SQL-Based Data Transformations

Dependency Management (Ref, Source)

Data Testing (Singular and Generic Tests)

Auto-Generated Documentation Site

Lineage Graphs (Visual DAG)

Materialization Strategies (Table, View, Incremental)

Jinja Templating for Modular SQL

CI/CD Integration (GitHub, GitLab)

Package Management (dbt Hub)

dbt Cloud IDE

Best For

Best for analytics teams applying software engineering to SQL transformations.

What Users Say

“Widely recognized as a leading solution in its category with strong user satisfaction ratings across major review platforms including G2, Capterra, and TrustRadius.”

Industry Consensus

CRM Review