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
173 reviews
from
and
External reviews are not included in the AWS star rating for the product.
DBT review
What do you like best about the product?
Using SQL queries, it is easy platform to transform the data.
What do you dislike about the product?
For legacy system its is not useful for tranformation
What problems is the product solving and how is that benefiting you?
Data transformation
ELT made easy with just SQL
What do you like best about the product?
All I need is to write some SQL select statements and specify materialisation type. My table will be created with the type of load I want to perform.
Support tickets are resolved quickly from support team.
Support tickets are resolved quickly from support team.
What do you dislike about the product?
Sometimes the error is not described aptly. This makes parsing error and debugging difficult.
What problems is the product solving and how is that benefiting you?
DBT eliminates the need for writing complex code and tedious orchestration jobs.
I can create any model with just SQL and orchestration made easy with creating job. Tags feature with lineage made my job easy by running sequence of models.
Lineage is helpful in visualising data flow. Lint feature helps with code formatting
I can create any model with just SQL and orchestration made easy with creating job. Tags feature with lineage made my job easy by running sequence of models.
Lineage is helpful in visualising data flow. Lint feature helps with code formatting
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.
so usefull
What do you like best about the product?
we can made maintainalble and scalable data infrastructure, this make user easy for working with data, transforming data become easy, that is why we use it in our projects also provides some standardies features
What do you dislike about the product?
we can not able to load the data from source , we can only able to use data present in dataware houses, new users may face difficulties while learning, support also not that good from community
What problems is the product solving and how is that benefiting you?
It provides standardize transformation process that help in less error, version control is also a good feature
Good if you have the software development experience and desire to manage database models as code
What do you like best about the product?
The ease, or in fact requirement, to use a repository is great if you are a developer who is used to that sort of thing and like what it offers you. Having the history of the data models tracked in this manner is great.
What do you dislike about the product?
Moves a lot of work to the data warehouse and doesn't replace an ETL tool. Nothing says dbt should be replacing an ETL tool but that's very much how I see it being used, which is unfortunate.
What problems is the product solving and how is that benefiting you?
Keeping track of changes to the database structure and the logic used in the creation of metrics is now a very simple process using dbt and a git repository. Additionally being able to easily build tests into those models is a time saver.
showing 1 - 5