dbt Platform
dbt LabsExternal reviews
185 reviews
from
External reviews are not included in the AWS star rating for the product.
Love it, so far. Still getting up to speed.
What do you like best about the product?
Could based; transparency of how everything is built and executed; the support from dbt and the user community; integrated documentation, testing, and git repository; dbt leverages team SQL knowledge.
What do you dislike about the product?
How to find and use packages and macros is not intuitive. If you're new to dbt, it's hard to know what's available, or how to approach a specific use case.
What problems is the product solving and how is that benefiting you?
Loading data vault on snowflake. We are replacing another tool that was too cumbersome and inefficient.
dbt is easy dynamic sql on steroids
What do you like best about the product?
easy to learn, very dynamic and powerful. dbt allows teams to work together using skills they already know (sql) along with a powerful templating language. this allows you do develop dynamic sql in a very easy, maintainable fashion. Using text files, it also allows you to easily see what's changed and who made those changes via github integration. It also eliminates the tedious ddl creation, and allows you to switch between using views and tables with a single configuration argument. It has powerful testing capabilities built in.
What do you dislike about the product?
compiling sometimes when not needed - it can slow down your development if you're saving a lot of files at once. Usually performance is not a problem but in some cases (not the typical workflow) it can be slow.
What problems is the product solving and how is that benefiting you?
solving data transformations. dbt lets you create dynamic sql very easily. you can onboard new teammates easily as everyone knows sql. transformations are stored in plain text in github so you can easily identify what's changed. easy to use - you only write 'select' statements - dbt handles all the ddl for you dynamically, keeping target environments separate. Integrated documentation and testing. packages (libraries) are available with great utilities.
Recommendations to others considering the product:
dbt is great for transformation - you still need another tool like FiveTran or Stitch to get the data into your warehouse. It's very powerful, and the dbt tools and support are great. Onboarding is quick as there are many developers who know sql. Being familiar with python is an additional bonus to becoming productive rapidly, but not required. One thing I really like is that dbt is open-source, so you can keep your business logic transformations even if you decide not to use dbt cloud. In most other etl tools, if they hike the rates you are stuck using their product or re-writing everything from scratch. dbt core offers a good alternative under those circumstances. However, the company provides good value for its services so I'm happy to stay with them.
With a prior GUI-based tool it was impossible to easily see what had changed, and merge with other developers. This is built for teamwork and accountability.
There are also out-of-the-box tools and libraries that can help you test and maintain data quality with no coding required.
The online dbt documentation is very good. In addition to regular support, they have slack channels and are very responsive.
The online training and personalized rapid onboarding training was excellent too.
Using dbt we were able to set up a Snowflake data warehouse and bring in 21 different sources, servicing hundreds of reports, in 8 months with a team of 2-3 data engineers and 3 BI engineers.
With a prior GUI-based tool it was impossible to easily see what had changed, and merge with other developers. This is built for teamwork and accountability.
There are also out-of-the-box tools and libraries that can help you test and maintain data quality with no coding required.
The online dbt documentation is very good. In addition to regular support, they have slack channels and are very responsive.
The online training and personalized rapid onboarding training was excellent too.
Using dbt we were able to set up a Snowflake data warehouse and bring in 21 different sources, servicing hundreds of reports, in 8 months with a team of 2-3 data engineers and 3 BI engineers.
Very powerful tool
What do you like best about the product?
DBT is critical to my organization and so far the tool has been very simple to use. My favorite feature is the interactive flowchart! absolutely game changing
What do you dislike about the product?
I think editing in DBT could get a little confusing with the different steps that are needed to update the code.
What problems is the product solving and how is that benefiting you?
We use DBT to clean and transform our data before it is synced into our BI tool
DBT Review
What do you like best about the product?
While running into a problem with creating an autorefresh cadence in Snowflake for a table I created, DBT was an alternative that I could use to help solve this issue.
What do you dislike about the product?
You have to pay for the software once you have more than one user. I understand everyone has a profit to be made, but I believe this tool should be 100% free for what it provides.
What problems is the product solving and how is that benefiting you?
I am using the tool to create an auto refresh cadence for a table I have created in Snowflake. DBT has made this process for us automated, which has been extremely helpful.
Great tool for Model creation and data transformation - DBT
What do you like best about the product?
DBT is one of the most straightforward command-line tools for data transformation. Creating tables or views with incremental strategies doesn't get easier than this.
What do you dislike about the product?
DBT doesn't have any data profiling features, and the auto-generated DBT documentation is not as user-friendly for non-technical users. Other than that, it's excellent with nothing to dislike.
What problems is the product solving and how is that benefiting you?
We use DBT for creating data models and implementing incremental strategies for data refreshes . DBT helps maintain DAG for the models and helps ensure correct dependency order for models.
Recommendations to others considering the product:
DBT is one of the easiest ways to create data models using simple SQL and easy-to-use config for incremental logic for data.
Great way to transform data
What do you like best about the product?
Easy to learn how to create models and tests. Very lightweight and quick run times.
What do you dislike about the product?
It can be cumbersome to host yourself - but there are good service providers to help you with that (like DBT Cloud).
What problems is the product solving and how is that benefiting you?
Taking raw data and transforming it into clean analytics tables. This allowed our reports to have significantly faster run time and reduces development time of our analtyics team.
showing 51 - 56