--- 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

5 Cons or Disadvantages of dbt

Shubham K.
SK
Shubham K.
Mid-Market (51-1000 emp.)
"DBT is best data modelling tool"
5/5
What do you like best about dbt?

Cross Referencing of models, Macros and custom functions Review collected by and hosted on G2.com.

What do you dislike about dbt?

Error Messaging and no cross-query functionality Review collected by and hosted on G2.com.

Onkar N.
ON
Onkar N.
Associate Software Engineer
Small-Business (50 or fewer emp.)
"Making data transformations easier"
5/5
What do you like best about dbt?

Its simplicity and focus on transforming data in a reproducible and maintainable way. Review collected by and hosted on G2.com.

What do you dislike about dbt?

Sometimes, its learning curve can be steep for beginners and managing complex transformations might require advanced knowledge. Review collected by and hosted on G2.com.

Verified User in Computer Software
IC
Verified User in Computer Software
Mid-Market (51-1000 emp.)
"so useful"
3/5
What do you like best about dbt?

we can create maintainable and scalable data infrastructure, making it easy for users to work with data. Transforming data becomes easy, which is why we use it in our projects. It also provides some standardized features. Review collected by and hosted on G2.com.

What do you dislike about dbt?

we cannot load data from the source, we can only use data present in data warehouses. New users may face difficulties while learning, and support from the community is not that good. Review collected by and hosted on G2.com.

David L.
DL
David L.
Senior Solutions Architect
Enterprise (> 1000 emp.)
"DBT, the unified codegen of downstream model heterogeneous complexity"
5/5
What do you like best about dbt?

DBT creates a new SQL-like syntax, use select statement and configuration file and headers to control behavior, make data model task more reliable and readable. Easy for data analysis with existing basic SQL knowledge. Review collected by and hosted on G2.com.

What do you dislike about dbt?

We can rarely go through all features in dbt, since it is too much. Solutions are sometimes duplicated. You can always find 2-4 ways to fulfill one purpose, and it can overwrite with each other. DBT integration with CI/CD is not easy, even in DBT cloud since file is the first citizen in dbt world. You can only have them tested in dbt project, even for only unit tests. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care
UH
Verified User in Hospital & Health Care
Small-Business (50 or fewer emp.)
"DBT"
4/5
What do you like best about dbt?

Cloud.dbt has proven to be an invaluable tool for our data modeling and analytics needs. Its seamless integration with cloud platforms, user-friendly interface, and robust features have significantly streamlined our workflow. The platform's automation capabilities have allowed our team to focus more on deriving insights from data rather than dealing with intricate modeling processes. The collaborative environment enhances team productivity, making it a standout solution for organizations aiming to elevate their data analytics game. I use it daily. Review collected by and hosted on G2.com.

What do you dislike about dbt?

Remember me during sign in doesn't work. Review collected by and hosted on G2.com.

VB
Vinod B.
Data Warehouse Engineer
Enterprise (> 1000 emp.)
"Best in class ELT"
5/5
What do you like best about dbt?

Best in-class SQLCentric tool providing ELT, orchestration with Lineage on the models. Make the development much easier and help to concentrate more on the Business. Review collected by and hosted on G2.com.

What do you dislike about dbt?

DBT only supports SQL and Python models for now, and being an ELT, reading from external sources will not be possible, which makes DBT very constrained and the libraries quite limited. Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising
CM
Verified User in Marketing and Advertising
Mid-Market (51-1000 emp.)
"DBT - easy transformation tool"
5/5
What do you like best about dbt?

Can perform transformation using SQL statement. Very easy to perform Review collected by and hosted on G2.com.

What do you dislike about dbt?

Nothing much......simple and easy to use Review collected by and hosted on G2.com.

PK
Praveen K.
QA Engineer
Information Technology and Services
Small-Business (50 or fewer emp.)
"MetricFlow"
5/5
What do you like best about dbt?

I like the most in MetricFlow is, it will simplify the code governance with autogenerated SQL. It will pull metrics into downstream applications. And also I like the UI most. Review collected by and hosted on G2.com.

What do you dislike about dbt?

Need to introduce more new interesting features in frequent releases. Should increase support of the application as well. Also better to support new integrations. Review collected by and hosted on G2.com.

SC
Stuart C.
Senior Data Analyst
Mid-Market (51-1000 emp.)
"dbt adds so many features to SQL that I hadn't even realised were missing"
4.5/5
What do you like best about dbt?

There's a lot that I really like about dbt, particularly in the way it automates so much of the 'grunt work' out of transforming data. It's now tough to imagine how we handled refreshing our data warehouse before dbt!

Specifically I am a fan of how dbt:Works out dependencies rather than you having to stay on top of which models need to be run before others

Automates testing, running tests on a schedule rather than when you remember to run the testing!

Handles version control, allowing you to keep track of changes

Provides a straightforward way of handling separate development and production environments, so you can see the impact of your changes before making them live

Has a very active community of Slack users and package developers Review collected by and hosted on G2.com.

What do you dislike about dbt?

This is quite minor, but with documentation it can be a bit onerous to keep .yml files up to date, as the formatting needs to be exact and it is not always obvious when something is wrong, for example, with the amount of tab spacing. Review collected by and hosted on G2.com.

JT
Joseph T.
Data consultant
Small-Business (50 or fewer emp.)
"dbt is currently the software I love most"
5/5
What do you like best about dbt?

dbt improves every facet of SQL transforms for analytics. My favorite features in order:

--Isolate each piece of business logic to a single model, ensuring that everything downstream inherits that definition.

--Build canonical fact tables, then combine those into report-ready aggregate marts. Once the fact tables are built, the time-to-data-mart is so fast.

--Automated testing for code and data quality

--Import code packages, either open source or private

--Managed interactive documentation Review collected by and hosted on G2.com.

What do you dislike about dbt?

The cloud IDE is still very much a work in progress. Already better than using a local IDE, but there are still enough quirks and bugs to be frustrating. Setting up a new project seems overly onerous--the same score of steps have to be done the same way, which seems like it could be just a copy/paste from a different project. Most implementations probably only have one project going, though, so that's a pain only us agency types feel. Review collected by and hosted on G2.com.