Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
DBT Wow!
What do you like best about the product?
I love how powerful dbt is. I use it on a daily basis for all my ELT needs! It is compact and efficient
What do you dislike about the product?
I don't have much to say about what I dislike about dbt.. nothing!
What problems is the product solving and how is that benefiting you?
DBT solves many issues for us, including documentation, DAGs, relationship testing, data integrity constraints, performance, etc.
- Leave a Comment |
- Mark review as helpful
Best tool to handle the T of ETL
What do you like best about the product?
I've been using "traditional" graphical ETL tools for 15+ years (Informatica PowerCenter, Talend, BODS...) and they never seemed "right".
More often than not, we just ended up having to use SQL instead of the transformations of the ETL tool, as this was much more robust / performant / flexible.
With dbt, the tool finally felt right:
- No more useless graphical interfaces.
- Heavily focused on leveraging the database performance thanks to SQL.
- But still being way better than just SQL since dbt automates everything that can be automated:
* No need to create the tables, no need to specify the data types of each column: this all comes automatically from the source.
* No need to specify the order of the transformations: this is automated based on the dependencies of each model.
* Easy integration of data tests.
* Possible to use the Jinja templating language to
* Now possible to use python to transform the data.
* Good integration of the documentation.
* Possible to set up the dbt repository in git to have great version control.
* Possible to use dbt cloud with github to automate basic testing of each pull request.
* Easy deployment to production thanks to CI / CD / github integration.
* Packages available that can answer specific needs.
* Great active community behind the tool.
* And probably other things !
More often than not, we just ended up having to use SQL instead of the transformations of the ETL tool, as this was much more robust / performant / flexible.
With dbt, the tool finally felt right:
- No more useless graphical interfaces.
- Heavily focused on leveraging the database performance thanks to SQL.
- But still being way better than just SQL since dbt automates everything that can be automated:
* No need to create the tables, no need to specify the data types of each column: this all comes automatically from the source.
* No need to specify the order of the transformations: this is automated based on the dependencies of each model.
* Easy integration of data tests.
* Possible to use the Jinja templating language to
* Now possible to use python to transform the data.
* Good integration of the documentation.
* Possible to set up the dbt repository in git to have great version control.
* Possible to use dbt cloud with github to automate basic testing of each pull request.
* Easy deployment to production thanks to CI / CD / github integration.
* Packages available that can answer specific needs.
* Great active community behind the tool.
* And probably other things !
What do you dislike about the product?
The python support opens the door to a lot of possibilities, but it is still new and (at least to me) it is not super clear if we can/should use it to handle some of the "EL" part of ETL (e.g., talk with external APIs to download extra data, or push data to other services). I'm guessing this could work but it is not recommended, at least at the moment.
What problems is the product solving and how is that benefiting you?
We do all our data warehouse transformations with dbt.
The tool makes this simple and robust.
dbt helps us automate what can be automated in the development and deployment process, so we can better focus on our specific domain knowledge.
The tool makes this simple and robust.
dbt helps us automate what can be automated in the development and deployment process, so we can better focus on our specific domain knowledge.
Efficient, easy to use and reliable for development
What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product 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.
Easy to use , ci/cd, versioning control, data lineage in one app
What do you like best about the product?
Data lineage and github integration for versioning control
What do you dislike about the product?
A bit steep learning curve for first timer since it use new methodology
What problems is the product solving and how is that benefiting you?
Github integration for version control. Data lineage for ELT
Changed the game
What do you like best about the product?
Extremely user-friendly, DBT allows our analysts to build, test, document and deploy datasets independently without multiple dependencies on engineering departments. It does not require significant upskilling for junior members and eases knowledge share and confidence through lineage and documentation.
What do you dislike about the product?
Not much at all! The constant improvements to dbt-core and dbt-cloud keep pace with community requests. Being able to post run results to multiple slack channels would be favorable, but this is in the planned release.
What problems is the product solving and how is that benefiting you?
Understanding data lineage was a previous problem. Knowing the impact of changes made on downstream datasets was challenging and required significant investigation time. This resulted in slower development and reduced confidence. DBT has allowed the team to onboard new members quicker and with greater confidence leveraging documentation of datasets and lineage.
dbt makes warehousing easy
What do you like best about the product?
dbt has helped us democratize business logic as a data team and implement it as code in our data warehouse. The ability to manage the scheduling of our cleansed data assets has been a game changer.
Having an open-source version that companies can self-host or a paid cloud version creates a low barrier to entry for all companies just getting started or veterans alike.
Having an open-source version that companies can self-host or a paid cloud version creates a low barrier to entry for all companies just getting started or veterans alike.
What do you dislike about the product?
As with any software, there is a learning curve that they solve with readily accessible learning and a vibrant community on slack.
dbt is also moving quickly in its development lifecycle, which seems to introduce bugs. The team is open to feedback and hops in at a moment's notice to help fix any issues.
dbt is also moving quickly in its development lifecycle, which seems to introduce bugs. The team is open to feedback and hops in at a moment's notice to help fix any issues.
What problems is the product solving and how is that benefiting you?
dbt allows our company a low barrier to ELT in our data warehouse, handling scheduling, business logic, and version control of our transformations. This enables contributions across the org to our transformations.
Great for analytics engineering
What do you like best about the product?
Being able to easily navigate between models and see the full picture of our dag in development
What do you dislike about the product?
Not sure if this is already built, but checking for column field lineage
What problems is the product solving and how is that benefiting you?
Helps analytics engineer with developing clean and reliable data models
DBT : Instant solution (ELT) - Big Data DE Scenario's
What do you like best about the product?
The ease with which I have done multiple POC and demonstrated to the customers having their products in various domains. I would say that setup and installation were pretty simple.
What do you dislike about the product?
I don't see any as of now. Will surely share once I have any.
What problems is the product solving and how is that benefiting you?
One of the Data Engineering scenarios required an ELT operation, and I found DBT was the best fit for it. The best part is that the computation runs on the core engines.
dbt is a one-stop destination for warehouse-native modelling and transformation
What do you like best about the product?
1. Analytics as code
2. Documentation-first experience
3. New capabilities and roadmap look promising (eg. Semantic Layer)
4. dbt Community and conferences are helpful for team to grow
2. Documentation-first experience
3. New capabilities and roadmap look promising (eg. Semantic Layer)
4. dbt Community and conferences are helpful for team to grow
What do you dislike about the product?
1. Not much honestly! :) - all of the below is good to have
2. dbt Docs is slow when there are a ton of models
3. Enterprise edition pricing is unclear/not public
2. dbt Docs is slow when there are a ton of models
3. Enterprise edition pricing is unclear/not public
What problems is the product solving and how is that benefiting you?
dbt Labs is helping us model the raw data on our Snowflake instance as code. It helps us keep our team lean and make data available as models/metrics - reusable assets for our data team's consumers.
Where has dbt been for the last 10 years?
What do you like best about the product?
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.
What do you dislike about the product?
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!
What problems is the product 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.
showing 51 - 60