--- title: dbt Reviews meta_title: 'dbt Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 209 reviews by the users' company size, role or industry to find out how dbt works for a business like yours. aggregate_rating: rating_value: 4.7 review_count: 209 scale: '5' date_modified: '2026-09-23' parent_category: name: IT Infrastructure url: https://www.g2.com/categories/it-infrastructure ---

dbt Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users find dbt's ease of use exceptional, with straightforward setup and intuitive features enhancing their data transformation processes. (34 mentions)
Users appreciate the maintainability and clarity of dbt's SQL code base, enhancing collaboration and data transformations. (21 mentions)
Users value the automation of data workflows with dbt, enhancing maintainability and collaboration in SQL transformations. (17 mentions)
Users love the ease of transforming data with dbt, allowing for organized and efficient analytics workflows. (16 mentions)
Users value the data quality of dbt, praising its effectiveness in ensuring data integrity and operational efficiency. (14 mentions)
Users find that dbt has limited functionality due to rigidness and complex debugging, hindering project progress. (13 mentions)
Users face dependency issues in dbt, as model errors and upstream changes complicate troubleshooting and disrupt workflows. (12 mentions)
Users find the steep learning curve of dbt daunting, needing mastery of concepts like Jinja and Git. (10 mentions)
Users encounter poor error handling with unclear messages, making troubleshooting frustrating and complicating the user experience. (9 mentions)
Users often face confusing error reporting and unclear messages, making troubleshooting and identifying issues challenging. (9 mentions)

5 Pros or Advantages of dbt

1. Ease of Use
Users find dbt's ease of use exceptional, with straightforward setup and intuitive features enhancing their data transformation processes.
See 34 mentions

See Related User Reviews

Syed A.
SA

Syed A.

Enterprise (> 1000 emp.)

4.0/5

"A Developer Friendly Transformation Tool"

What do you like about dbt?

I like best about dbt is how it brings a clean, developer‑friendly structure to analytics work. It makes modeling and transforming data feel organized

SJ

Scott J.

Small-Business (50 or fewer emp.)

4.0/5

"Reliable transformation practices at scale"

What do you like about dbt?

One thing that I find impressive about dbt is that it promotes discipline in writing of transformations. It transformed my approach towards the way I

2. Features
Users appreciate the maintainability and clarity of dbt's SQL code base, enhancing collaboration and data transformations.
See 21 mentions

See Related User Reviews

Syed A.
SA

Syed A.

Enterprise (> 1000 emp.)

4.0/5

"A Developer Friendly Transformation Tool"

What do you like about dbt?

I like best about dbt is how it brings a clean, developer‑friendly structure to analytics work. It makes modeling and transforming data feel organized

Jay P.
JP

Jay P.

Mid-Market (51-1000 emp.)

5.0/5

"Effortless Data Transformation with Easy Setup and Integration"

What do you like about dbt?

DBT is a data building tool that is very easy to setup, to use and we are using it every day for our data transformation. It is very easy to integrate

3. Automation
Users value the automation of data workflows with dbt, enhancing maintainability and collaboration in SQL transformations.
See 17 mentions

See Related User Reviews

Syed A.
SA

Syed A.

Enterprise (> 1000 emp.)

4.0/5

"A Developer Friendly Transformation Tool"

What do you like about dbt?

I like best about dbt is how it brings a clean, developer‑friendly structure to analytics work. It makes modeling and transforming data feel organized

JK

Josh K.

Small-Business (50 or fewer emp.)

4.5/5

"Structured data workflows made effortless with dbt"

What do you like about dbt?

The largest benefit of dbt to me is that it provides structure to data work. I use it regularly with the BigQuery and version control tools. The integ

4. Transformation
Users love the ease of transforming data with dbt, allowing for organized and efficient analytics workflows.
See 16 mentions

See Related User Reviews

Syed A.
SA

Syed A.

Enterprise (> 1000 emp.)

4.0/5

"A Developer Friendly Transformation Tool"

What do you like about dbt?

I like best about dbt is how it brings a clean, developer‑friendly structure to analytics work. It makes modeling and transforming data feel organized

SJ

Scott J.

Small-Business (50 or fewer emp.)

4.0/5

"Reliable transformation practices at scale"

What do you like about dbt?

One thing that I find impressive about dbt is that it promotes discipline in writing of transformations. It transformed my approach towards the way I

5. Data Quality
Users value the data quality of dbt, praising its effectiveness in ensuring data integrity and operational efficiency.
See 14 mentions

See Related User Reviews

MA

Mohamed A.

Small-Business (50 or fewer emp.)

4.0/5

"Reliable Data Automation and Trustworthy KPIs"

What do you like about dbt?

What I appreciated most about DBT was its capability to automate the creation of form data models, allowing me to trust the data. I felt confident tha

FM

Florelle M.

Small-Business (50 or fewer emp.)

4.5/5

"Streamlined Development and Reliable Data with Effortless DBT Orchestration"

What do you like about dbt?

What I appreciated most was the elimination of duplicated code that used to be spread across various scripts. This change has significantly enhanced d

5 Cons or Disadvantages of dbt

1. Limited Functionality
Users find that dbt has limited functionality due to rigidness and complex debugging, hindering project progress.
See 13 mentions

See Related User Reviews

SJ

Scott J.

Small-Business (50 or fewer emp.)

4.0/5

"Reliable transformation practices at scale"

What do you dislike about dbt?

What I do not like about dbt is that there is a huge effect of little errors in the models. Some of them may break down under the pressure of having a

JS

Joseph S.

Small-Business (50 or fewer emp.)

4.5/5

"Speedy but however it is quite pricey and resource hungry"

What do you dislike about dbt?

Vacuuming Tables… seriously, I have to manually vacuum and analyze tables to keep this thing running smoothly? It looks like 2005. Managing the cluste

2. Dependency Issues
Users face dependency issues in dbt, as model errors and upstream changes complicate troubleshooting and disrupt workflows.
See 12 mentions

See Related User Reviews

Syed A.
SA

Syed A.

Enterprise (> 1000 emp.)

4.0/5

"A Developer Friendly Transformation Tool"

What do you dislike about dbt?

I dislike about dbt is that some parts of the workflow can feel a bit inflexible, especially when you're trying to customize how tests or models behav

SJ

Scott J.

Small-Business (50 or fewer emp.)

4.0/5

"Reliable transformation practices at scale"

What do you dislike about dbt?

What I do not like about dbt is that there is a huge effect of little errors in the models. Some of them may break down under the pressure of having a

3. Steep Learning Curve
Users find the steep learning curve of dbt daunting, needing mastery of concepts like Jinja and Git.
See 10 mentions

See Related User Reviews

Syed A.
SA

Syed A.

Enterprise (> 1000 emp.)

4.0/5

"A Developer Friendly Transformation Tool"

What do you dislike about dbt?

I dislike about dbt is that some parts of the workflow can feel a bit inflexible, especially when you're trying to customize how tests or models behav

JK

Josh K.

Small-Business (50 or fewer emp.)

4.5/5

"Structured data workflows made effortless with dbt"

What do you dislike about dbt?

The negative side about dbt is that it becomes rigid when projects expand. Minor modifications in some cases need more readjustments than anticipated,

4. Error Handling
Users encounter poor error handling with unclear messages, making troubleshooting frustrating and complicating the user experience.
See 9 mentions

See Related User Reviews

Atharva P.
AP

Atharva P.

Enterprise (> 1000 emp.)

4.5/5

"Streamlined Data Transformations with Room for Debugging Improvement"

What do you dislike about dbt?

One of the pain points is debugging and error troubleshooting. Error messages can really be vague, making it difficult to pinpoint which part of the c

JM

James M.

Small-Business (50 or fewer emp.)

4.5/5

"We finally found a solution for easier management of data models"

What do you dislike about dbt?

The thing I dislike with dbt is that it may be difficult to troubleshoot model errors. The features are good, and error messages are not always helpfu

5. Error Reporting
Users often face confusing error reporting and unclear messages, making troubleshooting and identifying issues challenging.
See 9 mentions

See Related User Reviews

SJ

Scott J.

Small-Business (50 or fewer emp.)

4.0/5

"Reliable transformation practices at scale"

What do you dislike about dbt?

What I do not like about dbt is that there is a huge effect of little errors in the models. Some of them may break down under the pressure of having a

Atharva P.
AP

Atharva P.

Enterprise (> 1000 emp.)

4.5/5

"Streamlined Data Transformations with Room for Debugging Improvement"

What do you dislike about dbt?

One of the pain points is debugging and error troubleshooting. Error messages can really be vague, making it difficult to pinpoint which part of the c

Top-Rated Alternatives

Informatica Data Integration and Engineering
Informatica Data Integration and Engineering
4.3/5(337)
Databricks
Databricks
4.6/5(1,374)
Alteryx
Alteryx
4.6/5(902)
Verified User in Financial Services
UF
Verified User in Financial Services
Mid-Market (51-1000 emp.)
"User-Friendly Data Modeling with Seamless Integration"
5/5
What do you like best about dbt?

DBT is great for organizing data models. It is user friendly, integrates well with other tools, and they had a great onboarding process. Review collected by and hosted on G2.com.

What do you dislike about dbt?

In dbt Cloud, I cant work on two different branches at the same time in different browsers. Review collected by and hosted on G2.com.

Sai Krishna K.
SK
Sai Krishna K.
Infra technology specialist
Enterprise (> 1000 emp.)
"Pro and cons of DBT at Professional area"
5/5
What do you like best about dbt?

I worked on DBT for 2 years as a data engineer, It is helpful in writing dynamic SQL queries by creating models and we can write pyspark code. Using both features we can do complex data transformations. Proper lineage is an added advantage Review collected by and hosted on G2.com.

What do you dislike about dbt?

DBT alone is not better, it should be integrated with other warehouses such as Snowflake, where there are other options in market which has both. Review collected by and hosted on G2.com.

Verified User in Publishing
UP
Verified User in Publishing
Mid-Market (51-1000 emp.)
"ELT made easy with just SQL"
3.5/5
What do you like best about dbt?

All I need is to write some SQL select statements and specify materialisation type. My table will be created with the type of load I want to perform. Support tickets are resolved quickly from support team. Review collected by and hosted on G2.com.

What do you dislike about dbt?

Sometimes the error is not described aptly. This makes parsing error and debugging difficult. Review collected by and hosted on G2.com.

Verified User in Media Production
UM
Verified User in Media Production
Enterprise (> 1000 emp.)
"SQL Knowledge enough to become a Data Engineer"
5/5
What do you like best about dbt?

Useage of sql. Incremental strategies - which makes append, merge and full refresh easy. Snapshots - which makes building scd type 2 model error free. High Availability - we are using Dbt cloud, I rarely see failure in pipelines. Tests - which helps to validate the data. Configuration is ease. Review collected by and hosted on G2.com.

What do you dislike about dbt?

During development sometimes - changes are cached. So changes will not reflect, which require removal of target folder or deps or clean to resolve it. Review collected by and hosted on G2.com.

SQ
Servio Q.
Software Engineer
Computer Software
Mid-Market (51-1000 emp.)
"A game changer for dashboarding"
4/5
What do you like best about dbt?

You would feel really strange at first but after you start the integration will notice how easy to use it is. Great Documentation and community. Review collected by and hosted on G2.com.

What do you dislike about dbt?

The initial deployment is not ideal, and it would be beneficial to have a interface for dbt Core to support analysts who do not use Git on a daily basis but still take advantage of its benefits. Review collected by and hosted on G2.com.

Rijul S.
RS
Rijul S.
Lead Data Engineer
Enterprise (> 1000 emp.)
"Best data modeling tool"
5/5
What do you like best about dbt?

Beautiful data lineage

Easy to use and implement

DBT learning courses provided by DBT are super useful

Data sharing and orchestration is super easy

Development in cloud IDE is very good

Customer support is extremely fast and efficient

Integration with Snowflake and GitHub is easy

Using daily this tool for building data models Review collected by and hosted on G2.com.

What do you dislike about dbt?

Beta features are very slow releasing. Rest all GREAT Review collected by and hosted on G2.com.

Sushanth U.
SU
Sushanth U.
Tableau Developer and Admin
Information Technology and Services
Enterprise (> 1000 emp.)
"We majorly use DBT cloud for ETL in the organization"
4.5/5
What do you like best about dbt?

It's simple, SQL based approach and easy to version control. Review collected by and hosted on G2.com.

What do you dislike about dbt?

Challenging to manage large scale and complex dependencies Review collected by and hosted on G2.com.

Verified User in Financial Services
UF
Verified User in Financial Services
Mid-Market (51-1000 emp.)
"Elevating Our Data Stack"
4.5/5
What do you like best about dbt?

dbt's ability to streamline data workflows is excellent Review collected by and hosted on G2.com.

What do you dislike about dbt?

While dbt is great, for extremely large datasets or highly complex transformations, native SQL compilation might still require deep optimization knowledge or workarounds to achieve peak performance Review collected by and hosted on G2.com.

MAMIDALA V.
MV
MAMIDALA V.
Senior System Engineer
Information Technology and Services
Enterprise (> 1000 emp.)
"DBT(Data Build Tool) to build Excellent data models for Quickly and collaboratively"
4/5
What do you like best about dbt?

The most and best things I like in dbt are it not only helps in creating transformations but can also help in managing and performing transformations in a view and integrates easily with BigQuery. I can use and configure the transformation as per the object like table, view, or incremental along with features like auto-generated lineage graphs and can perform native testing with a few lines of code in a YAML file and can reuse them. Review collected by and hosted on G2.com.

What do you dislike about dbt?

There is not much to dislike in dbt; the reusable code can be a little bit confusing, and jumping from one branch to another can be frustrating. Review collected by and hosted on G2.com.

Muhammad Talha A.
MA
Muhammad Talha A.
Data Analyst
Enterprise (> 1000 emp.)
"Overwhelming when it comes to optimize and centralize your big data."
4.5/5
What do you like best about dbt?

1. The documentation it generates when all the models are designed. It clearly defines which intermediate and final layers are connected to each other.

2. The incremental model runs greatly helped me in optimizing large data models as I was dealing with billions of rows of data. Review collected by and hosted on G2.com.

What do you dislike about dbt?

I did not come across any difficulty in learning DBT as it was pretty basic and I also applied SQL fluff to streamline my coding. As a user, I did not find much difficulty in operating through dbt. Review collected by and hosted on G2.com.
Categories on G2
Explore More