dbt Platform
dbt LabsExternal reviews
208 reviews
from
and
External reviews are not included in the AWS star rating for the product.
great product, helpful team and community
What do you like best about the product?
dbt itself is a great tool - it's flexible and easy to use, and the learning curve isn't too steep (as it's largely SQL-based). It's easy to transform, test, and move data around, and because dbt sits between raw data and BI tools, it's possible to experiment, add business logic, and make changes to how data is transformed even retroactively.
Also, the team is very helpful (we engaged them as consultants to set up our data stack), the documentation is clear, and the slack community is a good resource.
Also, the team is very helpful (we engaged them as consultants to set up our data stack), the documentation is clear, and the slack community is a good resource.
What do you dislike about the product?
It's just one piece of a complete stack - you'll need a warehouse, a tool like Stitch or Fivetran to get data there, and a BI tool.
I mostly use dbt with a CLI, but the cloud product can be a bit slow.
I mostly use dbt with a CLI, but the cloud product can be a bit slow.
What problems is the product solving and how is that benefiting you?
It's a core part of our data stack that centralizes how data is transformed and how business logic is applied so that everyone at our company can see the same results. It organizes and joins data from disparate sources so it's easier to understand and use.
DBT is fantastic!
What do you like best about the product?
I like that DBT allows users to write complex SQL queries using Python-style coding blocks. It makes data transformations more fluid and achieveable.
What do you dislike about the product?
I have yet to find something that I dislike about DBT.
What problems is the product solving and how is that benefiting you?
We have messy data and inefficient SQL queries supporting some of our views. DBT has been able to streamline our data capabilities to increase our performance and clean up our data.
DBT is incredible and the people who work there are awesome!
What do you like best about the product?
DBT truly feels like it was created by analysts for analysts! It is intuitive, approachable, functional and honestly really fun to use. In the past, at another company, our analytics team was very dependent on Data Engineering to build our ETLs (primarily in Java) and aggregate tables even though we already had SQL created for the table we wanted to build. With DBT, you can remove the dependency on Engineering, move quickly, iterate, and learn more about analytics engineering as its own interesting functional area. We also worked with consultants at DBT labs for two 3-month engagements to refactor our growing repository and they were extremely professional, knowledgable, and fun! Would highly recommend it!
What do you dislike about the product?
It's difficult to think of things I dislike about DBT and it just keeps getting better and better as DBT continually listens and learns from its vibrant community. One thing I can think of is I wish it was possible to integrate DBT Docs directly into existing BI Tools.
What problems is the product solving and how is that benefiting you?
We use DBT for cleaning, transforming, testing, and modeling our source of truth datasets in our data warehouse. Our BI tools then leverage these datasets for important analysis and KPI tracking. We've also built important data frameworks within DBT to enable dynamic downstream ananlysis.
Recommendations to others considering the product:
Go for it! You won't regret!
DBT is the BEST (and most fun?) transformation tool. Mind blowing.
What do you like best about the product?
The whole paradigm of representing data models as SELECT statements is so approachable and functional. Starting out as a SQL novice, I was able to model complex database schemas into a common data standard. Documentation was good, and support was helpful. DBT Cloud is an ideal environment for learning DBT in real-time. Most of all, I love that everything is version-controlled and easy to roll back. DBT is one of the most innovative tools I've encountered period.
What do you dislike about the product?
Honestly, I can't think of anything significant. The online IDE has some bugs (as all do), but after the initial learning curve, we switched to VSC and GitHub, so problem solved. Documentation for Jinja _as it relates specifically to DBT_ was a little difficult to parse, and there were fewer articles about that online. If you already know Jinja this won't be an issue, but starting cold that was the steepest part of the learning curve by far.
What problems is the product solving and how is that benefiting you?
We use DBT for radical transformations of many source schemas into a common standard. We pair it with Fivetran to create an end-to-end data loading and transformation solution. It's been a quantum leap in scalability compared to our own, custom solutions as used previously.
Recommendations to others considering the product:
The paradigm of "every model is a SELECT statement" may not be the correct fit for every situation. Understanding how to use joins, sub-queries, and window functions is necessary for advanced transformations. DBT's own examples provide great reference asn best practices for most these concepts.
dbt is THE way to manage your SQL transformations - version control and all kinds of other tools!
What do you like best about the product?
Dbt is a revelation for the analytics/BI engineering space. The seamless version control and 'don't repeat yourself' tools make your data and analytics pipelines WAY more reliable and efficient. Build data like a developer!
What do you dislike about the product?
There are still some things that dbt can handle better like managing ALL your SQL data warehouse functionality like UDFs and other non-model-building things. I have high hopes that dbt will 'fast follow' features like this though.
What problems is the product solving and how is that benefiting you?
I'm now adapting ALL my data transformations in my Fivetran -> Snowflake -> visualizations data pipelines using dbt. The productivity gains + better accuracy/less bugs introduced are HUGE. There's definitely some upfront work to learn dbt (not hard if you're already a SQL expert AND if you have a little git or coding familiarity), but man is it worth it!
Recommendations to others considering the product:
I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT there's a FREE version for 1 dev seat with no read-only access for anyone else, so you can always start with that and then buy yourself a seat later.
Must-have tool for every analytics team
What do you like best about the product?
dbt formalizes software engineering best practices into our analytics workflow. Version control, data modeling, testing, documentation, etc. rolled into one toolkit that accommodates a big chunk of our data team's (and even a data engineer's) work. It's a life-changer, especially for diverse analytics teams whose members do not necessarily come from an engineering background.
What do you dislike about the product?
Nothing at all. The least favorable aspect I can think of is that the price for dbt Cloud is a bit high (per user), which may be prohibitive for larger teams who would like to test it out first without the need to measure ROI. Still, dbt-core is open-source and can be set up easily without purchasing subscriptions yet, so the price is not exactly a blocker.
What problems is the product solving and how is that benefiting you?
With dbt, we're able to clean and model our datasets flexibly. The main benefits are, our data engineers were able to focus on data integration, while our data analysts (who know our data better) were able to develop and maintain data models themselves. The flexibility in delegating the modeling work to our analysts has unlocked significant value, both in terms of data pipeline stability and the quality & usability of our downstream datasets.
Recommendations to others considering the product:
Just do it. Help your team be more productive.
Transform, materialize, and automate your data with ease!
What do you like best about the product?
DBT allows users to perform data engineer tasks in the language of SQL efficiently. In addition, the use of Jinja language allows for testing automation. DBT also has a community on Discord to further learning.
What do you dislike about the product?
Since DBT is new, the learning resources are not robust. Therefore, new users may have difficulty in knowing how to maximize efficiency. When the materialization fails, error messages are also not very descriptive.
What problems is the product solving and how is that benefiting you?
DBT allows our company to stay lean by giving the responsibilities of a data engineer to a data analyst. In addition, we can automate a good portion of our ELT process.
Dbt is one of the kind awesome tool for data build
What do you like best about the product?
The version control in dbt is fantastic , we can implement data tests for all possible failures and capture them . The cloud feature is great.
What do you dislike about the product?
There are very minor issues with DBT , the team is constantly working on improving it .
What problems is the product solving and how is that benefiting you?
Data security
Data Validation
Version controlling
CI/CD
Data Validation
Version controlling
CI/CD
Recommendations to others considering the product:
I would say dbt is incredible, The only tool dedicatedly built for transformation and data built. In the next few years all cloud computing companies will start using DBT.
best elt tools
What do you like best about the product?
ease of use and having control in you data pipline
What do you dislike about the product?
it has some feature limitations and also still not support all data warehouses
What problems is the product solving and how is that benefiting you?
our data pipeline monitoring and also controling
dbt Labs review
What do you like best about the product?
A comprehensive place to manage the application of business rules through SQL
What do you dislike about the product?
Missing some features, but the company is quite young so this is forgiveable
What problems is the product solving and how is that benefiting you?
Centrally managing the transformation of application data to business data
showing 121 - 130