Introducing G2.ai, the future of software buying.Try now

dbt Reviews & Product Details - Page 2

dbt Product Details

Claimed

dbt Integrations

(4)
Verified by dbt

dbt Media

Play dbt Video
Play dbt Video
Play dbt Video
Play dbt Video
Play dbt Video
Product Avatar Image

Have you used dbt before?

Answer a few questions to help the dbt community

170 dbt Reviews

4.8 out of 5
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
170 dbt Reviews
4.8 out of 5
170 dbt Reviews
4.8 out of 5

dbt Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
MAMIDALA  V.
MV
Senior System Engineer
Information Technology and Services
Enterprise (> 1000 emp.)
"DBT(Data Build Tool) to build Excellent data models for Quickly and collaboratively"
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 helps in managing and performing transformations in a view and integrates easily with Big-query

i can use and configure the transformation as per the object like table,view or incrementalalong with features like auto-generated lineage graphs and can perform native testing with few lines of codes in a YAML file and can able to re use them. Review collected by and hosted on G2.com.

What do you dislike about dbt?

There is not much about to dislike in dbt the reusable code can be 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
Data Analyst
Enterprise (> 1000 emp.)
"Overwhelming when it comes to optimize and centralize your big data."
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.

Sangavi D.
SD
Data Engineering
Mid-Market (51-1000 emp.)
"DBT review"
What do you like best about dbt?

Using SQL queries, it is easy platform to transform the data. Review collected by and hosted on G2.com.

What do you dislike about dbt?

For legacy system its is not useful for tranformation Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
Enterprise (> 1000 emp.)
"DBT review"
What do you like best about dbt?

DBT is user friendly and helps keep our data reliable, updated and secure Review collected by and hosted on G2.com.

What do you dislike about dbt?

Upgrading from core is really expensive without there being any significant differences besides number of users Review collected by and hosted on G2.com.

Verified User in Financial Services
AF
Mid-Market (51-1000 emp.)
"Great experience with dbt"
What do you like best about dbt?

dbt is the best Transformation tool out there in the industry and I love dbt for its testing capabilities and modeling and semantic layer. Ease of use and how easily you could maintain

It is easy to integrate with other tools like integration. Review collected by and hosted on G2.com.

What do you dislike about dbt?

dbt should add more AI apacilities faster Review collected by and hosted on G2.com.

📈 Rho L.
📈L
Business Intelligence Analyst
Mid-Market (51-1000 emp.)
"It's like seeing an old friend that you really liked but haven't seen for a while."
What do you like best about dbt?

At it's core, DBT aligns three technologies to deliver knowledge better: SQL, YAML, & Jinja. You can do a lot with just SQL and YAML. Adding in Jinja makes SQL feel a lot more like traditional development. I kinda missed that. It's like seeing an old friend that you really liked but haven't seen for a while.

dbt is magic for transforming and modeling data. It's a platform that allows us to wrangle, shape, and organize the data to model the business. With the help of DBT, we can implement the principle of separation of concerns to organize and manage our transformations.

One of the key tools DBT offers is Directed Acyclic Graphs (DAGs), maps that illustrate the path our data takes from source to the final destination. These maps illustrate the data transformation arc. We start with the source data, which is often messy and unrefined. We use DBT to perform a series of transformations, taking the data on a journey from a multiverse of chaos to a world of understanding. We clean the data, apply business rules, and ensure the data conforms to our business dimensional models. These models or core business logic serve as the foundation for reporting.

As we progress along the transformation arc, our data starts to take shape. We can build data marts for specific business areas or functions. These data marts are built with our business dimensional models, ensuring that the data is structured in a way that supports efficient analysis and reporting.

Reporting on top of our business dimensional models. With the data now organized and modeled in a meaningful way, we can unlock valuable insights and empower decision-makers with actionable information . . . at scale. We can slice and dice the data, apply filters, and drill down into specific dimensions to understand trends, patterns, and outliers. The reports we develop are consistent because they come from a single source of truth, the business dimensional model. Review collected by and hosted on G2.com.

What do you dislike about dbt?

dbt requires a mindset change. You have to buy into how they think about modeling. It's opinionated. dbt is method-agnostic (data vallt, mesh, kimball). But structure matters and you need to spend some time to understand dbt's mindset around stricture. Review collected by and hosted on G2.com.

Rulyan R.
RR
Mid-Market (51-1000 emp.)
"dbt makes it easier to onboarding analysts to good software engineering best practices"
What do you like best about dbt?

Its easy to use even for newcomers and dbt also uses sql that is the most democratic language for data manipulation. From the start is very quick to integrate with your data stack in just a few clicks. I use dbt for for data transformation and data modelling every day and its many features like data lineage, version control, ci and slim ci, testes, documentation, model contracts make it easy to apply DataOps in you project Review collected by and hosted on G2.com.

What do you dislike about dbt?

Its feature to model in python depends on the data plataform you are using. Its IDE still misses some of the functionalities that other IDE have that make development more easy, but new features are rolling out every new release of dbt cloud Review collected by and hosted on G2.com.

Uddipan M.
UM
Engineering Manager
Enterprise (> 1000 emp.)
"Data Trasformazione to to enable Analytics Engineering"
What do you like best about dbt?

Easy to write transformation in SQL language augmented by Jinja templating techniques. Support of Python models is powerful. Good library of Open source Macros makes life easy for Analytics engineers. Write test cases to test model results,. Powerful documentation capabilities. Works very well with Snowflake. Review collected by and hosted on G2.com.

What do you dislike about dbt?

To use DBT effectively, one needs to learn how to modularize SQL using CTEs. Bit advanced knowledge in SQl really helps. Review collected by and hosted on G2.com.

DM
Mid-Market (51-1000 emp.)
"A great environment and a powerful daily tool for Data Analysts and Engineers."
What do you like best about dbt?

dbt Cloud - I recommend it to every org to get Data Analysts & Analytics engineers up and running quickly without having difficulty setting up during the onboarding.

It's easier to adopt new teammates when they get to dive into the models immediately and add value sooner and solidify their grasp early. Review collected by and hosted on G2.com.

What do you dislike about dbt?

I dislike navigating the logs in the Job Runs tab.

The titles don't seem intuitive and the content could be more streamlined for finding faults. Review collected by and hosted on G2.com.

Emily B.
EB
Labor Law Specialist
Staffing and Recruiting
Mid-Market (51-1000 emp.)
"Our analytics are more reliable and efficient"
What do you like best about dbt?

Im thrilled to e­xplore how dbt revolutionizes our work by de­lving deeply into the data world. Its a total game­changer providing remarkable simplicity in formulating and utilizing data code­ within our warehouse. When it come­s to version control dbt streamlines the­ entire process e­nsuring a smooth experience­ and maintaining crucial data models for analysis. Review collected by and hosted on G2.com.

What do you dislike about dbt?

It would be good if dbt made it easier for new folks. It can do a lot with data stuff, but figuring how to set it up and use all its cool things can feel hard at first. More intuitive guides or a simpler way to learn the basics would make it nicer for people just starting with data changes. Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

1 month

Return on Investment

8 months

Average Discount

9%

Perceived Cost

$$$$$
dbt Comparisons
Product Avatar Image
Azure Data Factory
Compare Now
Product Avatar Image
Databricks Data Intelligence Platform
Compare Now
Product Avatar Image
Matillion
Compare Now
dbt Features
Breadth of Data Sources
Ease of Data Connectivity
Data Modeling
Data Joining
Data Blending
Data Workflows
Governance
dbt