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 adds so many features to SQL that I hadn't even realised were missing
What do you like best about the product?
There's a lot that I really like about dbt, particularly in the way it automates so much of the 'grunt work' out of transforming data. It's now tough to imagine how we handled refreshing our data warehouse before dbt!
Specifically I am a fan of how dbt:
- Works out dependencies rather than you having to stay on top of which models need to be run before others
- Automates testing, running tests on a schedule rather than when you remember to run the testing!
- Handles version control, allowing you to keep track of changes
- Provides a straightforward way of handling separate development and production environments, so you can see the impact of your changes before making them live
- Has a very active community of Slack users and package developers
Specifically I am a fan of how dbt:
- Works out dependencies rather than you having to stay on top of which models need to be run before others
- Automates testing, running tests on a schedule rather than when you remember to run the testing!
- Handles version control, allowing you to keep track of changes
- Provides a straightforward way of handling separate development and production environments, so you can see the impact of your changes before making them live
- Has a very active community of Slack users and package developers
What do you dislike about the product?
This is quite minor, but with documentation it can be a bit onerous to keep .yml files up to date, as the formatting needs to be exact and it is not always obvious when something is wrong, for example, with the amount of tab spacing.
What problems is the product solving and how is that benefiting you?
dbt has essentially "automated the boring stuff", letting us spend less time on boilerplate SQL work and more time thinking about the design of our models and how they best serve our reporting needs.
- Leave a Comment |
- Mark review as helpful
Avid longtime customers
What do you like best about the product?
Foundational data modeling for reporting in external tools. Testing and data correctness framework. Data-as-code continious deployment and automation. Documentation.
What do you dislike about the product?
A lot of repretitive data crunching that is somewhat hard to eliminate. Even with incremental models, subsequent models still make a full data transform. More caching / incremental tools for downstream models would be appreciated.
What problems is the product solving and how is that benefiting you?
Customer data and behavioral analytics. Unifying data from multiple sources for ease of access. Creating snapshots and time series data from mutable tables in various sources.
Streamlines SQL Development
What do you like best about the product?
After years of working with cumbersome ETL flows, dbt's modular approach makes it simple to change only a small portion of a large process without breaking anything. Having version control with SQL is a game changer.
What do you dislike about the product?
There is a learning curve to working with dbt, like any new solution/process, but the upside is worth it.
What problems is the product solving and how is that benefiting you?
dbt's approach to making SQL code clean and DRY has greatly improved our workflow and code.
The best tool for data engineering on Snowflake!
What do you like best about the product?
I appreciate the ability to generate a DAG quickly. This capability is beneficial for developers to extend the data warehouse while understanding what may be impacted downstream. The recent improvements to the cloud IDE have been substantial.
What do you dislike about the product?
The cloud IDE is going through a complete revamp, and during that time, there have been some glitches in how it operates. There have also been a few outages over the past few months, but nothing of major consequence.
What problems is the product solving and how is that benefiting you?
We use DBT as part of our tech stack for our embedded analytics product. It has allowed us to go from no data warehouse to a stable and agile data warehouse in weeks.
Fantastic SQL orchestrator that bridges the gap between analysis and programming
What do you like best about the product?
* All models, configurations and tests stored as version controlled code
* OSS as well as a managed SaaS-service
* Easily overviewable lineage & dependency trees
* OSS as well as a managed SaaS-service
* Easily overviewable lineage & dependency trees
What do you dislike about the product?
* There are some hidden complexities/nitty-gritty details you need to figure out before dbt becomes a powerful tool
* Parts of the documentation lack example(s) or have examples using legacy/old standards
* Parts of the documentation lack example(s) or have examples using legacy/old standards
What problems is the product solving and how is that benefiting you?
* dbt collects and orchestrates all transformations that before were scattered between analyst's own Drives, embedded within tooling or otherwise just laying around. I think this is one of the most powerful things dbt has done for us thus far.
Our time is exclusively dedicated to providing value with this tool as it's reliable and easy to use
What do you like best about the product?
* With inherited lineage, there is clarity in the transformation process.
* Doucmentation & tests easy to config
* The transformations require only SQL.
* Open source first approach
* Doucmentation & tests easy to config
* The transformations require only SQL.
* Open source first approach
What do you dislike about the product?
* Visualization of test results & jobs run time is lacking.
What problems is the product solving and how is that benefiting you?
* ease of use & visibility to the transformation process.
* don't waste time on infra
* don't waste time on infra
Jithendra Komhar DBT
What do you like best about the product?
1. Perfect way of representing the lineage of modes.
2.Easy navigation, good videos for learning about DBT tech stack
3. Excellent support for solving the issues
2.Easy navigation, good videos for learning about DBT tech stack
3. Excellent support for solving the issues
What do you dislike about the product?
1. It would be great if the trial period could be extended to 15 days instead of 8 days.
2. we need to run the models multiple times because of system errors from the dbt cloud. It would be great if it could be solved.
2. we need to run the models multiple times because of system errors from the dbt cloud. It would be great if it could be solved.
What problems is the product solving and how is that benefiting you?
We are dbt partners and working on some POCs like Informatica to DBT models to showcase how dbt can be leveraged.
we are partnersof DBT
we are partnersof DBT
dbt is currently the software I love most
What do you like best about the product?
dbt improves every facet of SQL transforms for analytics. My favorite features in order:
--Isolate each piece of business logic to a single model, ensuring that everything downstream inherits that definition.
--Build canonical fact tables, then combine those into report-ready aggregate marts. Once the fact tables are built, the time-to-data-mart is so fast.
--Automated testing for code and data quality
--Import code packages, either open source or private
--Managed interactive documentation
--Isolate each piece of business logic to a single model, ensuring that everything downstream inherits that definition.
--Build canonical fact tables, then combine those into report-ready aggregate marts. Once the fact tables are built, the time-to-data-mart is so fast.
--Automated testing for code and data quality
--Import code packages, either open source or private
--Managed interactive documentation
What do you dislike about the product?
The cloud IDE is still very much a work in progress. Already better than using a local IDE, but there are still enough quirks and bugs to be frustrating. Setting up a new project seems overly onerous--the same score of steps have to be done the same way, which seems like it could be just a copy/paste from a different project. Most implementations probably only have one project going, though, so that's a pain only us agency types feel.
What problems is the product solving and how is that benefiting you?
SQL transforms with daily code runs.
Deploying packaged code across multiple projects.
Monitoring code and data quality through daily automated testing.
Prepare raw data for business user consumption.
Deploying packaged code across multiple projects.
Monitoring code and data quality through daily automated testing.
Prepare raw data for business user consumption.
dbt helps us manage and collaborate data transformation very efficiently
What do you like best about the product?
Easy to maneuver dbt cloud IDE to complete our models, version control for collaboration, jinja templating for python power, dbt tests to ensure accurate result, yml file, a centralized space to provide clear descriptions, and many more... oh of course, dbt docs
What do you dislike about the product?
Haven't found one yet; maybe some built-in sqlfluff? I know it's already in progress.
What problems is the product solving and how is that benefiting you?
Keeps track of changes between engineers and documents easily the "why" behind the changes.
Love the fit of dbt with dev ops, regression testing, pipelines and the like›
What do you like best about the product?
Coupling of code with tests provides assurance changes have been implemented correctly
What do you dislike about the product?
Speed in dbt cloud is not speed of thought response
What problems is the product solving and how is that benefiting you?
Financial reporting, dbt particularly good at checking and validating
showing 71 - 80