dbt - bang for your buck for transformation in ETL stack
June 24, 2022

dbt - bang for your buck for transformation in ETL stack

Yoshlin Pillay | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Software Version

dbt Developer

Overall Satisfaction with dbt (data build tool)

I use dbt on the T part of ETL in my data tech stack. It is amazing and also does the change control quite well. So, to summarize - ingest, do a multitude of transforms, spit out to data mart. Allows various business logic applications to data to happen simultaneously and well tracked for the data marts.
  • Transformation
  • Change Control
  • Organisation
  • Flow build
  • Learning Curve is steep
  • Better documentation
  • Better YouTube tutorials
  • Change Control
  • Transformation
  • Developer vibe for data analysts
  • Quicker insights
  • Quicker data
  • Quicker solves
Most ETL pipeline products have a T layer, but dbt just does it better. The transformation is on steroids compared to the others. Also, just allows much more Adhoc solutions for very specific projects. Those ETL tools are probably better on the T part if you don't need too many transforms - also dbt is pretty much free dependent on how you work it, also extremely scalable.

Do you think dbt delivers good value for the price?

Yes

Are you happy with dbt's feature set?

Yes

Did dbt live up to sales and marketing promises?

Yes

Did implementation of dbt go as expected?

Yes

Would you buy dbt again?

Yes

I use dbt on the T part of ETL in my data tech stack. It is amazing and also does the change control quite well. So, to summarize - ingest, do a multitude of transforms, spit out to data mart. Allows various business logic applications to data to happen simultaneously and well tracked for the data marts. Not very well suited so a single data mart, low scale data volume.

dbt Feature Ratings

Simple transformations
7
Complex transformations
10
Data model creation
10
Metadata management
10
Business rules and workflow
10
Collaboration
Not Rated
Testing and debugging
8