TrustRadius

Coefficient vs. dbt

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Coefficient
Score 10.0 out of 10
N/A
Coefficient is a no-code solution that allows business teams to work with real-time data directly from their spreadsheets. It can sync to Google Sheets or Excel to company systems such as Salesforce, Hubspot, Google Analytics, Looker, MySQL, Redshift, and Slack. This lets users build reports and analyses that are real-time, and without any knowledge of SQL or other advanced tools.
$59
per month 5,000 row import
dbt
Score 9.1 out of 10
N/A
dbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.N/A
Pricing
Coefficientdbt
Editions & Modules
Starter
$59
per month 5,000 row import
Pro
$119
per month per user (unlimited import size)
Enterprise
Custom with Volume Discounts
No answers on this topic
Offerings
Pricing Offerings
Coefficientdbt
Free Trial
YesYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsDiscount available for annual pricing.—
More Pricing Information
Community Pulse
Coefficientdbt
Considered Both Products
Coefficient

No answer on this topic

dbt
Chose dbt
dbt is very flexible and can fit into most data pipelines. This is a pro for most organizations that aren't fully bought into one platform (Google Cloud, etc.)
Verified User
Anonymous
Chose dbt
Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt.
Verified User
Anonymous
Chose dbt
I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT …
Judy Campion | TrustRadius Reviewer
Judy Campion
Data Architect
Chose dbt
Snaplogic is great at the Extraction and Load processes of ETL. It can pull data from anywhere, even behind firewalls. So if you need to get data from various APIs, databases, files, S3, SFTP, etc it is easy to do so. However, it requires special knowledge in order to build …
Verified User
Anonymous
Chose dbt
I haven't come across anything like DBT before.
YP
Yoshlin Pillay
Senior Data Entry
Chose dbt
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 …
Obed Espina | TrustRadius Reviewer
Obed Espina
Senior Data Engineer
Chose dbt
Airflow can accomplish the same work as dbt (data build tool), however, dbt's (data build tool) development workflow and UI can open up data transformation and modeling work to non-data engineering teams. Looker might also be able to define data models via LookML with a …
Verified User
Anonymous
Chose dbt
dbt is great because of its transformation capabilities
Features
Coefficientdbt
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Coefficient
-
Ratings
dbt
9.7
Ratings
18% above category average
Simple transformations00 Ratings10.00 Ratings
Complex transformations00 Ratings9.50 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Coefficient
-
Ratings
dbt
9.1
Ratings
15% above category average
Data model creation00 Ratings9.70 Ratings
Metadata management00 Ratings8.70 Ratings
Business rules and workflow00 Ratings9.00 Ratings
Collaboration00 Ratings10.00 Ratings
Testing and debugging00 Ratings8.00 Ratings
Best Alternatives
Coefficientdbt
Small Businesses
Skyvia
Skyvia
Score 10.0 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Coefficientdbt
Likelihood to Recommend
-
(0 ratings)
10.0
(0 ratings)
Usability
-
(0 ratings)
9.7
(0 ratings)
User Testimonials
Coefficientdbt
Likelihood to Recommend
No answers on this topic
dbt (Data Build Tool) is best suited for doing the data transformation. dbt is just a transformation tool and it is not suitable for building a data pipeline which requires extraction of data and loading. dbt is well suited for SQL based transformation logic and it is less appropriate when transformation logic requires python.
Sahil Khan | TrustRadius Reviewer
Sahil Khan
Data Analyst
Read full review
Pros
No answers on this topic
  • user experience makes it easy to work with SQL and version control
  • customer success team and the dbt (data build tool) community help establish best practices
  • thorough and clear documentation
Obed Espina | TrustRadius Reviewer
Obed Espina
Senior Data Engineer
Read full review
Cons
No answers on this topic
  • Slow load times of the dbt cloud environment (they're working on it via a new UI though)
  • More out-of-the-box solutions for managing procedures, functions, etc would be nice to have, but honestly, it's pretty easy to figure out how to adapt dbt macros
Verified User
Anonymous
Read full review
Usability
No answers on this topic
dbt is very easy to use. Basically if you can write SQL, you will be able to use dbt to get what you need done. Of course more advanced users with more technical skills can do more things.
SI
Sid Iyer
BizOps
Read full review
Alternatives Considered
No answers on this topic
Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt.
Verified User
Anonymous
Read full review
Return on Investment
No answers on this topic
  • In 3 months we re-wrote the data warehouse (15-20 sources) in dbt with 3 developers.
  • We are using it continually for the past year with no issues.
  • Sorry, I don't have ROI numbers but the impact was huge.
Judy Campion | TrustRadius Reviewer
Judy Campion
Data Architect
Read full review
ScreenShots