--- 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-08-10' 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 love the **ease of use** of dbt, thanks to its clear structure, intuitive documentation, and seamless integration. [(34 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930388&qs=pros-and-cons#reviews) Users value dbt for its **integration of software engineering best practices** , enhancing maintainability and collaboration in SQL transformations. [(21 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930019&qs=pros-and-cons#reviews) Users value the **automation** features of dbt, significantly enhancing SQL code maintainability and transforming data workflows. [(17 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1933555&qs=pros-and-cons#reviews) Users value the **transformative power** of dbt, efficiently organizing and modeling data for actionable insights. [(16 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930623&qs=pros-and-cons#reviews) Users value dbt for its **high data quality** , ensuring integrity and enhancing analytics workflows through modularization and documentation. [(14 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930559&qs=pros-and-cons#reviews) Users face challenges with **limited functionality** in dbt due to rigid models and debugging difficulties, affecting project progress. [(13 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930756&qs=pros-and-cons#reviews) Users often face **dependency issues** with dbt, leading to time-consuming troubleshooting and disruption in workflows. [(12 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1932889&qs=pros-and-cons#reviews) Users find the **steep learning curve** of mastering concepts like Jinja and Git to be quite challenging. [(10 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930471&qs=pros-and-cons#reviews) Users struggle with **unhelpful error messages** in dbt, making troubleshooting difficult and frustrating. [(9 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1933260&qs=pros-and-cons#reviews) Users face **confusing error reporting** that complicates troubleshooting and hinders quick identification of issues. [(9 mentions)](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=2302478&qs=pros-and-cons#reviews) ### 5 Pros or Advantages of dbt ##### 1. Ease of Use Users love the **ease of use** of dbt, thanks to its clear structure, intuitive documentation, and seamless integration. [ See 34 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930388&qs=pros-and-cons#reviews) See Related User Reviews ![Syed A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "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 value dbt for its **integration of software engineering best practices** , enhancing maintainability and collaboration in SQL transformations. [ See 21 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930019&qs=pros-and-cons#reviews) See Related User Reviews ![Syed A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "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.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "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** features of dbt, significantly enhancing SQL code maintainability and transforming data workflows. [ See 17 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1933555&qs=pros-and-cons#reviews) See Related User Reviews ![Syed A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "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 value the **transformative power** of dbt, efficiently organizing and modeling data for actionable insights. [ See 16 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930623&qs=pros-and-cons#reviews) See Related User Reviews ![Syed A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "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 dbt for its **high data quality** , ensuring integrity and enhancing analytics workflows through modularization and documentation. [ See 14 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930559&qs=pros-and-cons#reviews) 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 face challenges with **limited functionality** in dbt due to rigid models and debugging difficulties, affecting project progress. [ See 13 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930756&qs=pros-and-cons#reviews) 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 often face **dependency issues** with dbt, leading to time-consuming troubleshooting and disruption in workflows. [ See 12 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1932889&qs=pros-and-cons#reviews) See Related User Reviews ![Syed A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "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 mastering concepts like Jinja and Git to be quite challenging. [ See 10 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1930471&qs=pros-and-cons#reviews) See Related User Reviews ![Syed A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "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 struggle with **unhelpful error messages** in dbt, making troubleshooting difficult and frustrating. [ See 9 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=1933260&qs=pros-and-cons#reviews) See Related User Reviews ![Atharva P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "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 face **confusing error reporting** that complicates troubleshooting and hinders quick identification of issues. [ See 9 mentions ](https://www.g2.com/products/dbt/reviews?filters%5Bsentiment_snippet%5D=2302478&qs=pros-and-cons#reviews) 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.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "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 [ ![Databricks](https://images.g2crowd.com/uploads/product/hd_favicon/135d1c9e39e19ef56dc8d0bf90fce20f/databricks.svg "Databricks") Databricks 4.6/5(1,364) ](https://www.g2.com/products/databricks/reviews) [ ![Alteryx](https://images.g2crowd.com/uploads/product/hd_favicon/5200f776b24b5976b8f7d151d1d2e8fd/alteryx.svg "Alteryx") Alteryx 4.6/5(893) ](https://www.g2.com/products/alteryx/reviews) [ ![Google Cloud BigQuery](https://images.g2crowd.com/uploads/product/hd_favicon/875b8a68eca98ce3458f26e9dd34cdf9/google-cloud-bigquery.svg "Google Cloud BigQuery") Google Cloud BigQuery 4.5/5(1,224) ](https://www.g2.com/products/google-cloud-bigquery/reviews) [ View All Alternatives ](https://www.g2.com/products/dbt/competitors/alternatives) ![Frank S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Frank S.") FS Frank S. Data Analyst, Data Protection Officer Small-Business (50 or fewer emp.) 12/8/2022 "The Only Analytics Engineering Toolkit You Need!" 5/5 What do you like best about dbt? dbt makes it very simple to plan, construct, and continuously transform our company data on regular intervals in order to power our decisions on product design, user experience, and much more. Moreover, its Slack community will not let you fail and is incredibly helpful. Review collected by and hosted on G2.com. What do you dislike about dbt? The fact that dbt is constantly expanding what you can transform and helping you to code those transformations makes it a hard software to not be married to. Marriage to a software is often the death of an operating budget over time, but the value is incredible with dbt. Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? dbt provides a cloud-based job-running environment that I can set and forget, an integrated development environment to code my SQL and Python transformations in, and a way to easily deploy automated testing of my code to ensure data quality and reliability. Moreover, dbt makes it easy to write your code with native format assistance (SQLFMT), active syntax recommendations, shortcuts, and a suite of learning videos and docs. Review collected by and hosted on G2.com. Show More Our network of Icons are G2 members who are recognized for their outstanding contributions and commitment to helping others through their expertise.G2 IconCurrent UserValidated ReviewerSource: Organic ![Max L.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Max L.") ML Max L. Senior Data Engineer Mid-Market (51-1000 emp.) 12/8/2022 "Game changing solution that brings software engineering best practices to data work" 5/5 What do you like best about dbt? dbt brings a ton of best practices from software engineering: code versioning, automated testing, documentation, and support for deploying to multiple environments to the process of transforming data (ETL/ELT). Prior to using dbt I'd either have SQL code stuck in an IDE somewhere or obfuscated through an orchestration tool like airflow that made it difficult for non-coders to contribute effectively to a data team. Even as a senior data engineer I love the best practices and simplicity that dbt has brought to my team and I'm looking forward to its continued growth! Review collected by and hosted on G2.com. What do you dislike about dbt? Nothing major, dbt is still a relatively new product with active development so some minor annoying things are constantly being improved. For example, the IDE in dbt cloud wasn't super performant and auto-completion would not always work, but both things were improved drastically through the most recent release. We had a little bit of an initial learning curve for customizing our environment to suit our specific use-case, but I like that we weren't forced to do a bunch of customization out of the box so you could easily start using the product. Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? Performing data transformation at scale using only SQL and deploying those to multiple environments while using code versioning. Our ability to create standardized reporting tables for multiple different projects has drastically improved. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic ![Maria S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Maria S.") MS Maria S. Data Platform Engineering Lead Enterprise (\> 1000 emp.) 12/8/2022 "Analytics Engineering revolution!" 4.5/5 What do you like best about dbt? dbt is a potent tool with lots to explore. The data lineage is fantastic, where you can easily see if a small change brakes a model downstream. Tests are integrated into it, which we use a lot, specially custom ones. Macros are handy and fantastic resources for controlling tests, functions, environment behaviour, etc. Building new models is effortless because the analyst only needs knowledge of SQL (and a bit of dbt but like any tool). Finally, I love the dbt community spirit, the excellent documentation and how dbt is continuously improved. Review collected by and hosted on G2.com. What do you dislike about dbt? However, I am worried about the scalability of using one repository. There were two of us when we started using dbt, but we are +10 now and this reflects in running times, release management and CI/CD. We would love to see a bit more support on this. Another thing is the alerting system, we can set up tests as warnings, but you need to enter dbt cloud on purpose and see the alerts inside the job. We are building alerts out of the box because this doesn't work for us. Lastly, it was difficult for me initially to adapt from the "old" data stack, but I am 100% dbt converted now. Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? We previously had an ETL tool which was very difficult to maintain and contribute to. This was a huge bottleneck, and dbt has allowed many people to contribute to modelling and building dashboards. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic ![Connor S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Connor S.") CS Connor S. Analytics Engineer Small-Business (50 or fewer emp.) 12/8/2022 "dbt has vastly improved how I get work done. It has changed the data industry and it's wonderful" 5/5 What do you like best about dbt? dbt gives data teams the ability to version their SQL code, execute that code as often as they'd like, maintain different environments and support multiple users in parallel. All of which require barely any thought from the user. All these functions used to be major pieces of my daily work and with dbt, they are simply memories of when I set up the product. It's wonderful. Review collected by and hosted on G2.com. What do you dislike about dbt? Once you start getting into some of the advanced functionality of dbt, you can find yourself in what feels like unexplored land. It's an open-source product, so your own creativity is your only limit. However, in those situations finding syntax examples for anything that isn't a main function of dbt is going to be extremely challenging. Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? They're constantly improving the UI and user experience in ways that enable my teammates who may have less experience with technical or database maintenance work, to take ownership of their own work projects and exceed. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic ![Alex G.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Alex G.") AG Alex G. Junior Data Scientist Mid-Market (51-1000 emp.) 12/14/2022 "Efficient, easy to use and reliable for development" 4.5/5 What do you like best about dbt? Fast development times and ease of use are my two favourite qualities of dbt. It allows our team to build and test new sql models very quickly, and even less experienced team members with basic knowledge of sql are able to contribute. Review collected by and hosted on G2.com. What do you dislike about dbt? With large complex models tracking column lineage can be tricky. Especially as fields go through many layers of transformations, identifying where certain data quality issues are arising can be challenging. I realise this is not an easy problem to solve but column level lineage would be super useful at speeding this process up. Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? The fast dev times allow us to efficiently accommodate business changes into the logic of our data transformations. As a relatively small data team of 8 serving an org of 600, keeping up with changes to the business is vital for us to be able to work on other high-value data projects. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic ![John P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "John P.") JP John P. Senior Manager - Analytics Engineering Mid-Market (51-1000 emp.) 12/6/2022 "dbt has fundamentally changed the way we work" 5/5 What do you like best about dbt? dbt has enabled us to literally re-model a data warehouse from scratch in a matter of months. All the complexities of handling scheduling dependencies, lineage, incremental models, snapshots, and robust, thorough testing have been abstracted away freeing us up to focus on the modelling and design work. If we had built all these ourselves this would have been a years-long project. dbt has also empowered our analysts to build data products without the need for BI Engineers. Review collected by and hosted on G2.com. What do you dislike about dbt? The primary downside we've all come to experience is that once you've worked with dbt you'll never want to work in an environment that doesn't transform its data with dbt. Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? dbt really solved the problem of being able to build a world-class data warehouse rapidly with a small team of analytics engineers. The benefits have been numerous, from having jobs run according to dependencies so we don't have to worry about timing or manually schedule tasks, to built-in testing which means we know about errors before the business does. Our development times are now a fraction of what they were, and the analysts love that they are no longer dependent on a team of data/BI engineers to build and maintain their own models. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic ![Matthew K.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Matthew K.") MK Matthew K. Vice President, Data Strategy & Analytics Mid-Market (51-1000 emp.) 12/13/2022 "Where has dbt been for the last 10 years?" 5/5 What do you like best about dbt? I've been an analytics professional working in databases for the last 10 years. dbt solves a large number of the problems I've encountered deploying code (be it often repeated analyses, reporting, or clinical rules) in a repeatable scalable way. dbt handles the repeatable processing and provides easy-to-consume documentation to share with others, so that I don't have to replicate the logic in separate documentation artifacts. Review collected by and hosted on G2.com. What do you dislike about dbt? Because of its youth, many highly-valuable features are distributed as add-on packages. It requires a significant commitment to understand the landscape of commonly used add-ons that are pervasive throughout the community. Looking forward to more highly-valuable functionality being built into the core software! Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? dbt allows my organization to upskill our analytics professionals. The teams that own and use the key business logic can directly deploy updates and additions into our common warehouse environment and begin to use and share it quickly. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic DA Don A. Director of Research and Development Small-Business (50 or fewer emp.) 12/12/2022 "Powerful and Easy to Use ETL Tool" 5/5 What do you like best about dbt? The best part of DBT is the power that comes with its ease of use. Once you play around with DBT a bit and get a handle on it, it can do all sorts of great tricks with just a SELECT statement and a little bit of Jinja. Review collected by and hosted on G2.com. What do you dislike about dbt? DBTs only weakness right now is I find the examples in the documentation to be a little simplistic, not covering all the options like the examples in a Microsoft help page would. Luckily, for more complicated use cases, you can get help in their Slack community, which is quite lively and helpful. Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? DBT is helping us normalize several data sources together into one master model and then exposing slices of that master model in the form of views we base our exports on. We have over 2k models between putting the sources together and then sharing the slices. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic JR James R. Sr Director of Data and Insights Mid-Market (51-1000 emp.) 12/8/2022 "Amazing Product We Have Used for Years" 5/5 What do you like best about dbt? DBT allows us to transform our data in a way that is easy to learn (with a sql background), easily adjustable, and incredibly powerful. Every dataset that is used by a business user at our company goes through DBT one way or another, some as simple as cleaning up some fields and names, and other through complex algorithms. Review collected by and hosted on G2.com. What do you dislike about dbt? The code first style can be a little daunting to teach to newer people who have never seen a tool like this before or do not know SQL. I think the investment in teaching SQL/DBT is well worth the value provided. Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? We have dozens of datasets that come in in many different formats and levels of cleanliness. DBT allows us to take any dataset and convert it in a clean, scalable way into datasets that are easy to use for analystics and process automation Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic ![Adam M.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Adam M.") AM Adam M. Head of AI and Data Mid-Market (51-1000 emp.) 12/8/2022 "If you're doing analytics, you need dbt" 5/5 What do you like best about dbt? dbt was easy to integrate into our stack, and immediately began adding value. dbt has levelled up our data practice and helps to ensure that we're shipping reliable, consistent and accurate tables to our stakeholders. It allow for repeatability so that stakeholders don't need to know sql to use a useful table. Review collected by and hosted on G2.com. What do you dislike about dbt? If you have multiple projects in your warehouse (BigQuery) in our case, you have to set up dbt for each. It would be ideal if, within BQ, we could consolidate projects somehow - although given security permissions, potentially not possible or practical. Review collected by and hosted on G2.com. What problems is dbt solving and how is that benefiting you? Previously were modelling tables in our warehouse or BI layer leading to a lot of confusion and breaks in data. Using dbt, we can easily (i) enforce PRs for any new tables, (ii) enforce tests, (iii) leverage macros and (iv) define documentation. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic ##### Categories on G2 [ETL Tools](https://www.g2.com/categories/etl-tools)[Data Quality](https://www.g2.com/categories/data-quality)[Data Preparation](https://www.g2.com/categories/data-preparation) [ETL Tools](https://www.g2.com/categories/etl-tools)[Data Quality](https://www.g2.com/categories/data-quality)[Data Preparation](https://www.g2.com/categories/data-preparation)[Big Data Integration Platforms](https://www.g2.com/categories/big-data-integration-platforms)[Semantic Layer Tools](https://www.g2.com/categories/semantic-layer-tools)[Big Data Analytics](https://www.g2.com/categories/big-data-analytics)[DataOps Platforms](https://www.g2.com/categories/dataops-platforms)[Data Warehouse Automation](https://www.g2.com/categories/data-warehouse-automation) [Show MoreShow Less](javascript:void(0);) ##### Explore More [Nintex vs NetSuite vs Emburse Expense Enterprise in the UKG Marketplace: which platform lets teams best verify security and compliance with UKG integrations before signing a long-term vendor contract?](https://www.g2.com/discussions/nintex-vs-netsuite-vs-emburse-expense-enterprise-in-the-ukg-marketplace-which-platform-lets-teams-best-verify-security-and-compliance-with-ukg-integrations-before-signing-a-long-term-vendor-contract)[Best PIM tools for app development teams](https://www.g2.com/discussions/best-pim-tools-for-app-development-teams)[Top APM solutions for mobile app businesses](https://www.g2.com/discussions/top-apm-solutions-for-mobile-app-businesses) [Which wide column database company is known for the best support and SLAs?](https://www.g2.com/discussions/which-wide-column-database-company-is-known-for-the-best-support-and-slas)[Top-rated tools for multi-factor biometric authentication](https://www.g2.com/discussions/top-rated-tools-for-multi-factor-biometric-authentication)[Pros and Cons Details](https://www.g2.com/products/dbt/reviews?qs=pros-and-cons) [Show MoreShow Less](javascript:void(0);)