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.

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

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.

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.

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.

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

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.

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

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

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

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

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

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.

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

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.

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

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.

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

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

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.

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

View All Alternatives

Elia M.

Data transformation engineer

Accounting

Small-Business (50 or fewer emp.)

11/30/2025

"Reliable data project workflow"

4/5

What do you like best about dbt?

What I like about dbt most is that my modeling work is much more comfortable. I spend my entire time modifying logic or verifying the changes and the set of features is what I actually need. I operate it with Snowflake, and that integration ensures that my updates are regular. The installation was relatively fast and the number of times the tool has been used demonstrates the extent to which it has come to my rescue in order to maintain projects and ensure they are well organized. Review collected by and hosted on G2.com.

What do you dislike about dbt?

The thing I do not like is that there are some spots that do not provide me with the flexibility that I need when I work on large portions of work. It imposes additional procedures which disrupt my rhythm. These weak spots are visible since I am in dbt so many times. There is a good response of the customer support but still the restrictions influence my speed during peak weeks. Review collected by and hosted on G2.com.

What problems is dbt solving and how is that benefiting you?

Dbt addresses our problem of disorganized model upkeep in the team. I apply it in my daily activities keeping track of the changes and updating and ensuring that all goes in the right direction. The size of the features suits very well into our workflow and the frequency of use demonstrates how much easier our process is now. It has assisted us in preventing the instances of miscommunication and enabled all of us to be more certain of the work we drive forward. Review collected by and hosted on G2.com.

Aneesh T.

Associate Data Engineer

Mid-Market (51-1000 emp.)

6/12/2026

"Great UI Makes Data Lineage and Flow Easy to Understand"

4/5

What do you like best about dbt?

Great UI—it's easy to see the lineage and the data flow. Review collected by and hosted on G2.com.

What do you dislike about dbt?

Lineage isn’t exactly easy to follow when it’s rendered. I wish there were a better explorer so I could view the lineage properly. Review collected by and hosted on G2.com.

Mohamed A.

General Management

Small-Business (50 or fewer emp.)

12/15/2025

"Reliable Data Automation and Trustworthy KPIs"

4/5

What do you like best 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 that the KPIs displayed were accurate, thanks to transformation logic that had been thoroughly tested and addressed, which I found particularly valuable. Review collected by and hosted on G2.com.

What do you dislike about dbt?

The learning curve could be smoother, and the user interface would benefit from some enhancements. Review collected by and hosted on G2.com.

What problems is dbt solving and how is that benefiting you?

My priority is to ensure that the strategic decisions I make are grounded in reliable and consistent data. DBT enables this by providing a column that transforms data into clear metrics, eliminating any mistrust in the data. This is achieved without requiring its own visualization, allowing the focus to remain on the quality of the data model. As a result, the agility and speed of reporting are significantly improved. Review collected by and hosted on G2.com.

Jay P.

Data Analyst

Mid-Market (51-1000 emp.)

12/26/2025

"Effortless Data Transformation with Easy Setup and Integration"

5/5

What do you like best 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 and leverage the tool with lots for features. Review collected by and hosted on G2.com.

What do you dislike about dbt?

Sometimes, it experiences server downtime. Review collected by and hosted on G2.com.

nayan S.

Manager Analytics

Mid-Market (51-1000 emp.)

4/8/2026

"Best-in-Class SQL Transformations in dbt"

4.5/5

What do you like best about dbt?

SQL Transformation is the best thing which dbt have. Review collected by and hosted on G2.com.

What do you dislike about dbt?

Nothing as of now. but pricing seems high for model run Review collected by and hosted on G2.com.

Dylan C.

RevOps Lead

Enterprise (> 1000 emp.)

5/5/2026

"Easy-to-Use DBT for Version-Controlled SQL Models"

4/5

What do you like best about dbt?

I use DBT for a lot of our sql models to version control. It's easy to use and helpful Review collected by and hosted on G2.com.

What do you dislike about dbt?

So far there really hasnt been anything wrong with the platform. You need admin that know what they're doing Review collected by and hosted on G2.com.

Olena C.

Analytics Engineer

Small-Business (50 or fewer emp.)

4/24/2026

"Fast, High-Performance Cloud Modeling"

4.5/5

What do you like best about dbt?

speed of building models, performance, cloud based Review collected by and hosted on G2.com.

What do you dislike about dbt?

a steep learning curve for non-technical users, high resource consumption with large datasets, and lack of built-in scheduling. Review collected by and hosted on G2.com.

Praveen K.

Data Engineer

Mid-Market (51-1000 emp.)

6/1/2026

"Simplifying Data Transformations"

4/5

What do you like best about dbt?

Easy SQL-based data transformations and testing. Review collected by and hosted on G2.com.

What do you dislike about dbt?

Large projects can become difficult to manage. Review collected by and hosted on G2.com.

Ali A.

Analytics Engineer / BI Analyst

Mid-Market (51-1000 emp.)

10/1/2025

"If its worth it, a data transformer with amazing features"

4.5/5

What do you like best about dbt?

I appreciate how this tool brings software engineering principles to our data collection process, making it more scalable, auditable, and reliable. I also really enjoy the ability to write straightforward tests that execute automatically. Review collected by and hosted on G2.com.

What do you dislike about dbt?

At times, handling very complex transformations or preprocessing tasks requires the use of more advanced Python packages, which means I often need to rely on external solutions. Review collected by and hosted on G2.com.

Marissa M.

Data Engineer

Small-Business (50 or fewer emp.)

10/27/2025

"Powerful Features and Git Integration, but Error Messages Need Improvement"

4.5/5

What do you like best about dbt?

DBT provides valuable features for rapid software development, and what I appreciate most is its seamless integration with Git. Its modular design, which includes the ability to build reusable models, conduct code reviews, and generate automatic documentation, is excellent. Additionally, I am impressed by its capability to define and run quality tests, which further enhances the development process. Review collected by and hosted on G2.com.

What do you dislike about dbt?

When a DBT run fails, the error messages displayed in the terminal are quite generic. I find this frustrating because it means I have to spend extra time searching through the logs to figure out what went wrong. Review collected by and hosted on G2.com.