I use the solution for transformation. When we perform the ELT process, we need to transform the data according to the business requirements. We can also use the tool for testing.
dbt Platform
dbt LabsExternal reviews
185 reviews
from
External reviews are not included in the AWS star rating for the product.
Great experience with dbt
What do you like best about the product?
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.
It is easy to integrate with other tools like integration.
What do you dislike about the product?
dbt should add more AI apacilities faster
What problems is the product solving and how is that benefiting you?
dbt is solving all the data integration, integrity and data quality problems for our company while serving as a great transfomration tool
Developer-friendly and easy to use, but doesn't have many optimization options
What is our primary use case?
What is most valuable?
The product is developer-friendly. A person who understands SQL can develop the transformation. We do not have to learn a lot of things like we do for new tools. The tool has good testing and data quality features. Implementing Slowly Changing Dimensions through dbt has been easy. It is very easy for a beginner to use the product.
The tool provides multiple technical advantages if we use Snowflake. It is a good transformation tool because it is SQL-oriented. It has data lineage, data quality, and workflow scheduler.
What needs improvement?
The solution must add more Python-based implementations. Transformation tools require Python-based implementations. It would give developers more freedom to use SQL or Python. We can use Python, but it is not that user-friendly. The product doesn't have a lot of optimization options.
For how long have I used the solution?
I have been using the solution for almost three years.
What do I think about the stability of the solution?
There are no problems with the product’s stability.
What do I think about the scalability of the solution?
We have at least 25 to 50 users in our organization.
How was the initial setup?
The solution is deployed on the cloud. It can be deployed on AWS, Azure, or GCP. The initial setup is easy.
What's my experience with pricing, setup cost, and licensing?
The solution’s pricing is affordable.
What other advice do I have?
We also use stored procedures and Talend. They are not replaced by dbt completely. We use dbt only for the transformation process. My recommendations would depend on an organization’s requirements and problems. I will recommend the tool to others. The product is developer-friendly. However, it is still dependent on the data warehouse for big data and optimization.
It's just a SQL transformation tool. It doesn't have a lot of optimization options like Spark. It's a good tool for Snowflake. If it were only for Snowflake, I would have rated it an eight out of ten. However, there are other data platforms.
Overall, I rate the tool a six and a half out of ten.
Deal with data transformations with flexible learning curve and handle big data workloads
What is our primary use case?
We use the solution to deal with data transformations inside different organizations.
How has it helped my organization?
You need some knowledge. Dbt has a more flexible learning curve than other tools. You need some experience to handle big data workloads but with less experience, you can get started.
What is most valuable?
They help us orchestrate different transformations. With Dbt, you can automate the orchestration of transformations without thinking too much.
What needs improvement?
SQL statements that beyond DML, are not possible. Currently, they are not possible in Dbt. Having more features in SQL statements will support us.
Another issue is the terms of data ingestion because Dbt requires sources to be defined, and you need to handle data ingestion with other tools. So having a data injection tool integrated within dbt will be awesome.
For how long have I used the solution?
I have been using dbt for three years.
What do I think about the scalability of the solution?
It's very scalable because it's open source. You can spin up different EC2 or different compute instances to run VVT. We have 14 professionals using this solution. I rate it a nine out of ten.
How was the initial setup?
I store procedures calling within dbt statements. You can only use a selected statement in debt. If you want to use more advanced or more complicated SQL features, they are not supported right now by Dbt, so that can be a challenge.
What's my experience with pricing, setup cost, and licensing?
It is cheap because dbt is open source. If you compare the pay-per-service of Dbt with the open source option you can manage. We are managing the solution, when we were acquiring service from them. It was also cheap compared with the engineering cost that implies managing the the infrastructure.
What other advice do I have?
I have had the opportunity to teach one of the tools to level entry engineers because it's easy to learn and easy to maintain. It's pretty useful.
It depends on the architecture and the amount of company's data or the people that I'm going to advise. If you're starting a data engineering team and you don't have a lot of big data workflows, I would recommend Dbt. I recommend our tools for more advanced workflows but for starting, I recommend 100% Dbt.
Overall, I rate the solution a nine out of ten.
DBT - easy transformation tool
What do you like best about the product?
Can perform transformation using SQL statement. Very easy to perform
What do you dislike about the product?
Nothing much......simple and easy to use
What problems is the product solving and how is that benefiting you?
ELT tool which helps to perform transformation using SQL and create pipelines.
Excellent tool for data transformation
What do you like best about the product?
It has helped us transform our data and structure it better and its easy use
What do you dislike about the product?
It should provide a tool to better enable model documentation.
What problems is the product solving and how is that benefiting you?
We can have the data structured through code; This helps us when migrating data to any type of DWH.
Making data transformations easier
What do you like best about the product?
Its simplicity and focus on transforming data in a reproducible and maintainable way.
What do you dislike about the product?
Sometimes,its learing curve can be steep for beginners and managing comples transformation might require advanced knowledge.
What problems is the product solving and how is that benefiting you?
dbt simplifies data transformation making analytics pipelines easier to manage and more reliable,which benefifits users by stramling workflows and improving efficiency.
A great environment and a powerful daily tool for Data Analysts and Engineers.
What do you like best about the product?
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.
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.
What do you dislike about the product?
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.
The titles don't seem intuitive and the content could be more streamlined for finding faults.
What problems is the product solving and how is that benefiting you?
Easy onboarding - streamlined development - the guided point-and-click adventure for github saves a ton of time and is probably the best in class solution I have seen for managing state. Please dont ever change this.
dbt data modeling and test building is a fun experience on dbt cloud, my day to day work is fun because of dbt.
Testing is super easy for pro-active data quality checks.
I wish there was more visible ways to incorporate REACTIVE testing, like Metaplane's monitors, into dbt.
DBT support was a bit slow here in Africa when the Github outage took place last year - some frustration around how slow responses were, how unclear processing was but I have personally learnt how to navigate these issues outside of dbt env.
dbt data modeling and test building is a fun experience on dbt cloud, my day to day work is fun because of dbt.
Testing is super easy for pro-active data quality checks.
I wish there was more visible ways to incorporate REACTIVE testing, like Metaplane's monitors, into dbt.
DBT support was a bit slow here in Africa when the Github outage took place last year - some frustration around how slow responses were, how unclear processing was but I have personally learnt how to navigate these issues outside of dbt env.
Our analytics are more reliable and efficient
What do you like best about the product?
Im thrilled to explore how dbt revolutionizes our work by delving deeply into the data world. Its a total gamechanger providing remarkable simplicity in formulating and utilizing data code within our warehouse. When it comes to version control dbt streamlines the entire process ensuring a smooth experience and maintaining crucial data models for analysis.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
In my role as a data management specialist, I have seen how dbt changed how we change data. It keeps changes same under control and tested well guaranteeing how exact our analyzing is. The automatic things of dbt have helped us work better freeing our team for strategic things not manual data work. This made us more quick and able to answer with data that helps our group make choices based on data.
Using dbt has improved accuracy and collaboration in our data projects
What do you like best about the product?
In my role I absolutely love using dbt - its the ultimate tool for transforming data with ease. It effortlessly integrates into our current systems making our analytics work a breeze. Were all in on dbt because it excels at data transformation and organization boosting our efficiency and collaborative efforts tremendously.
What do you dislike about the product?
It would be fantastic if dbt could enhance it's toolkit for visual data modeling. At present its heavily focused on coding but integrating a more visual approach to working with data would undoubtedly elevate its utility especially for individuals who gravitate towards graphical methods for data analysis.
What problems is the product solving and how is that benefiting you?
As data enthusiasts we consider dbt our everyday superpower dramatically enhancing our data analysis while effortlessly managing complex data changes. Its our goto tool smoothing our data work and ensuring our insights are as sharp as a tack allowing us to make informed decisions to propel our business forward.
Good tranformation tool for data engineers : Complete SQL Magic.
What do you like best about the product?
DBT has been game changer in the realm of data analaytics for me.
Its One of standout feature is abilty to transform data in warehouse itself it makes it lightning fast
The powerfult modular sql based approach to define transformation makes it fall in love for data engineers.
Its automatic document generation feature is simply outstanding.
Its SQL based moduler approach makes it easy for implementation.
Its One of standout feature is abilty to transform data in warehouse itself it makes it lightning fast
The powerfult modular sql based approach to define transformation makes it fall in love for data engineers.
Its automatic document generation feature is simply outstanding.
Its SQL based moduler approach makes it easy for implementation.
What do you dislike about the product?
If someone is not well-versed in SQL it will be dificult to implement it initially.
The main feature it doesnt have is inbuilt scheduler.
The scheduler will make it complete transformation tool for data engineers.
The main feature it doesnt have is inbuilt scheduler.
The scheduler will make it complete transformation tool for data engineers.
What problems is the product solving and how is that benefiting you?
Ability to create moduler, version control models ensures my transformation code is well maintanable and scalable.
Its version control feature makes it very easy for developers to collabrate.
Its feature of auto generating insights/ documents makes it outstand.
Its version control feature makes it very easy for developers to collabrate.
Its feature of auto generating insights/ documents makes it outstand.
showing 31 - 40