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

dbt pros and cons

Vendor: dbt Labs
4.0 out of 5

Pros & Cons summary

Buyer's Guide

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

Prominent pros & cons

PROS

Since migrating from SSIS to dbt model architecture, the team experienced a drastic reduction in downtime during complete data refreshes.
dbt enables users to orchestrate all transformations in one location, enhancing operational efficiency and data governance with modular SQL and version control.
dbt allows organizations to create data pipelines significantly faster, transforming data ingestion into valuable data products in weeks.
Developers appreciate the ease of development, the ability to write everything in code, and the reduction of data errors before they affect downstream models.
dbt supports managing higher complexity levels within data processes, freeing up time for teams to focus on growth and transformation activities.

CONS

There are other tools that provide similar functionality at a lower cost, making dbt less appealing for small companies with limited budgets.
Dbt's initial setup is somewhat complex and can pose difficulties for new users.
Dbt has experienced several outages this year, indicating stability improvements are needed.
Code migration to Git and GitHub sometimes fails, causing confusion during the handover for developers.
Managing multiple reporting standards is an operational challenge with dbt.
 

dbt Pros review quotes

Harshwardhan Gullapalli - PeerSpot reviewer
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.
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.
Surjit-Choudhury - PeerSpot reviewer
Data Architect at Envision Pharma, Inc.
Apr 30, 2026
Overall, I find dbt to be optimized compared to other tools.
Learn what your peers think about dbt. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,747 professionals have used our research since 2012.
Ankush-Singh - PeerSpot reviewer
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.
Shubham-Agarwal - PeerSpot reviewer
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.
reviewer2780388 - PeerSpot reviewer
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.
JohnnyHuang - PeerSpot reviewer
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.
reviewer2846985 - PeerSpot reviewer
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.
JA
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.
Ninad Magdum - PeerSpot reviewer
Senior Machine Learning Engineer at Happiest Minds Technologies
Aug 13, 2024
The product is developer-friendly.
 

dbt Cons review quotes

Harshwardhan Gullapalli - PeerSpot reviewer
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.
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.
Surjit-Choudhury - PeerSpot reviewer
Data Architect at Envision Pharma, Inc.
Apr 30, 2026
The initial setup of dbt is somewhat complex.
Learn what your peers think about dbt. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,747 professionals have used our research since 2012.
Ankush-Singh - PeerSpot reviewer
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.
Shubham-Agarwal - PeerSpot reviewer
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.
reviewer2780388 - PeerSpot reviewer
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.
JohnnyHuang - PeerSpot reviewer
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.
reviewer2846985 - PeerSpot reviewer
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.
JA
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.
Ninad Magdum - PeerSpot reviewer
Senior Machine Learning Engineer at Happiest Minds Technologies
Aug 13, 2024
The solution must add more Python-based implementations.