No more typing reviews! Try our Samantha, our new voice AI agent.

dbt pros and cons

Vendor: dbt Labs

4.0 out of 5

12 reviews
100% willing to recommend

Leave a review Why PeerSpot?

Pros & Cons summary

dbt is developer-friendly, optimizing work through code-based transformations and reducing data refresh time to four hours. It simplifies complex processes, enhances AI model quality by reducing errors, and optimizes operational efficiency with modular SQL. While dbt's initial setup can be complex and its license costly for smaller companies, it can also struggle with advanced SQL features and managing reporting standards, making Git migrations confusing for developers during handovers.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

dbt is developer-friendly, optimizing work through code-based transformations.

Migration to dbt reduced data refresh time to around four hours, increasing client satisfaction and minimizing downtime.

Orchestrating transformations in one location with dbt simplifies complex processes.

Implementation of dbt's testing layer has reduced data errors by catching issues early, enhancing downstream AI model quality.

dbt optimizes operational efficiency and increases data quality and governance with modular SQL and version control.

CONS

If users want to use more advanced or complicated SQL features, dbt doesn't support them currently, which can be challenging.

Since dbt has a license cost, smaller companies with limited budgets might find it more expensive compared to other tools offering similar functionality.

The initial setup of dbt is somewhat complex, which may pose difficulties.

Managing multiple reporting standards can be an operational pain point with dbt.

Migrating code to Git and GitHub sometimes fails, confusing developers during handover.

dbt Pros review quotes

Harshwardhan Gullapalli

AI Engineer at a educational organization with 51-200 employees

Apr 7, 2026

The most concrete outcome was a significant reduction in data errors reaching our downstream AI models, and after implementing dbt's testing layer, we caught roughly 70% of those issues at the transformation stage itself, before they ever touched the model.

Read full review

AS

Principal Data Engineer at Integrant, Inc.

Mar 2, 2026

I would say the best feature or the most desirable feature for dbt is the ability to write everything in code.

Read full review

Surjit-Choudhury

Data Architect at Envision Pharma, Inc.

Apr 30, 2026

Overall, I find dbt to be optimized compared to other tools.

Read full review

Free Report: dbt Reviews and More

Learn what your peers think about dbt. Get advice and tips from experienced pros sharing their opinions. Updated: October 2026.

920,769 professionals have used our research since 2012.

Lead Software Engineer at Momentus

Feb 20, 2026

From a developer point of view, I find the ease of development and the code to be the most useful capabilities of dbt.

Read full review

Shubham-Agarwal

Manager - Projects at Cognizant

Jan 22, 2026

Since we migrated from SSIS to dbt model architecture, it takes around four hours only to complete a full refresh, and the client is now happy because our downtime was drastically reduced when we perform a complete refresh of the data.

Read full review

reviewer2780388

Senior Data Engineer at a pharma/biotech company with 10,001+ employees

Dec 10, 2025

There is operational efficiency achieved, and data quality and governance have also been achieved with modular SQL and version controlling, which reduced duplication of data and data errors.

Read full review

Head of Data & AI engineering at One NZ

Dec 2, 2025

dbt has positively impacted my organization by allowing us to create our data pipelines much faster, going from ingestion of data to creating a data product in weeks instead of months, and we can do it in-house with the skillset we already have.

Read full review

reviewer2846985

Data Engineer at a comms service provider with 10,001+ employees

May 28, 2026

dbt has positively impacted my organization by allowing us to expand the ceiling of complexity because once we have written the SQL, we can manage significantly more complexity since we are not spending all of our time doing it ourselves.

Read full review

JA

JohamAlvarez-Montoya

Data Engineer at Georgia Institute of Technology

Apr 6, 2026

It is very convenient because at the end, I have the opportunity to orchestrate all my transformations in just one single place, rather than having them spread out.

Read full review

Senior DevOps Engineer at a manufacturing company with 10,001+ employees

Oct 23, 2026

dbt is quite unique in that it is the only one supporting testing with SQL as a first-class language.

Read full review

Show 1 more reviews (out of 11)

dbt Cons review quotes

Harshwardhan Gullapalli

AI Engineer at a educational organization with 51-200 employees

Apr 7, 2026

Managing multiple reporting standards was our biggest operational pain point with dbt.

Read full review

AS

Principal Data Engineer at Integrant, Inc.

Mar 2, 2026

Every upgrade is a little bit of a risk for us because we do not know if the workarounds that we developed will be available for the next version.

Read full review

Surjit-Choudhury

Data Architect at Envision Pharma, Inc.

Apr 30, 2026

The initial setup of dbt is somewhat complex.

Read full review

Free Report: dbt Reviews and More

Learn what your peers think about dbt. Get advice and tips from experienced pros sharing their opinions. Updated: October 2026.

920,769 professionals have used our research since 2012.

Lead Software Engineer at Momentus

Feb 20, 2026

If I needed to name a few areas for improvement, I would mention the migration of code to Git and GitHub, which sometimes fails and can be confusing for developers during handover.

Read full review

Shubham-Agarwal

Manager - Projects at Cognizant

Jan 22, 2026

Since dbt has a license cost, if a company is small and does not have much budget, they can explore other tools because there are other tools that provide the same functionality at a lower cost.

Read full review

reviewer2780388

Senior Data Engineer at a pharma/biotech company with 10,001+ employees

Dec 10, 2025

Dbt is not as stable as preferred, as it has had a few outages in the current year itself, so improvement should be made in the outages section as it is not stable.

Read full review

Head of Data & AI engineering at One NZ

Dec 2, 2025

dbt can be improved as I find the co-pilot in dbt is not very good, and my team has tried using it but opted to move off it and use other co-pilots such as GitHub.

Read full review

reviewer2846985

Data Engineer at a comms service provider with 10,001+ employees

May 28, 2026

The main issue I have had with dbt is that when I start a project inside dbt, the structure I have to use is somewhat strict.

Read full review

JA

JohamAlvarez-Montoya

Data Engineer at Georgia Institute of Technology

Apr 6, 2026

If you compare the cost of those packages with dbt alone, it is more expensive to use dbt alone.

Read full review

Senior DevOps Engineer at a manufacturing company with 10,001+ employees

Oct 23, 2026

One thing that dbt still lacks is native support for knowing the coverage.

Read full review

Show 1 more reviews (out of 11)

Product Categories

Product Categories

Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs dbt

Teradata vs dbt

Qlik Talend Cloud vs dbt

SAP Business Data Cloud vs dbt

Palantir Foundry vs dbt

Informatica PowerCenter vs dbt

Alteryx One vs dbt

Oracle Data Integrator (ODI) vs dbt

Azure Data Factory vs dbt

SnapLogic vs dbt

Fivetran vs dbt

Pentaho Data Integration and Analytics vs dbt

See all alternatives

Product Categories

Product Categories

Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs dbt

Teradata vs dbt

Qlik Talend Cloud vs dbt

SAP Business Data Cloud vs dbt

Palantir Foundry vs dbt

Informatica PowerCenter vs dbt

Alteryx One vs dbt

Oracle Data Integrator (ODI) vs dbt

Azure Data Factory vs dbt

SnapLogic vs dbt

Fivetran vs dbt

Pentaho Data Integration and Analytics vs dbt

See all alternatives

Related questions

167

When evaluating Data Integration, what aspect do you think is the most important to look for?

154

Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?

487

What are the best on-prem ETL tools?

340

Which integration solution is best for a company that wants to integrate systems between sales, marketing, and project development operations systems?

147

Experiences with Oracle GoldenGate vs. Oracle Data Integrator?

125

What are the must-have features for a Data integration system?

91

Should we choose Data Hub or GoldenGate?

247

Is there a bulletproof KPI Data Manager for SME?

129

A recent review wrote that PowerCenter has room for improvement. Agree or Disagree?

120

Python with Numpy/Scipy vs. Pure C++ for Big Data Analysis