Try our new research platform with insights from 80,000+ expert users

Matillion Data Productivity Cloud vs dbt comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jul 6, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

dbt
Average Rating
7.6
Reviews Sentiment
7.4
Number of Reviews
2
Ranking in other categories
Data Integration (36th)
Matillion Data Productivity...
Average Rating
8.4
Reviews Sentiment
7.4
Number of Reviews
27
Ranking in other categories
Cloud Data Integration (8th)
 

Mindshare comparison

While both are Data Integration and Access solutions, they serve different purposes. dbt is designed for Data Integration and holds a mindshare of 2.0%, up 0.1% compared to last year.
Matillion Data Productivity Cloud, on the other hand, focuses on Cloud Data Integration, holds 3.4% mindshare, down 4.3% since last year.
Data Integration
Cloud Data Integration
 

Featured Reviews

Ninad Magdum - PeerSpot reviewer
Developer-friendly and easy to use, but doesn't have many optimization options
We also use stored procedures and Talend. They are not replaced by dbt completely. We use dbt only for the transformation process. My recommendations would depend on an organization’s requirements and problems. I will recommend the tool to others. The product is developer-friendly. However, it is still dependent on the data warehouse for big data and optimization. It's just a SQL transformation tool. It doesn't have a lot of optimization options like Spark. It's a good tool for Snowflake. If it were only for Snowflake, I would have rated it an eight out of ten. However, there are other data platforms. Overall, I rate the tool a six and a half out of ten.
Tomáš Hronek - PeerSpot reviewer
Used for wrangling or transforming data from sources like S3 and Databricks
I use Matillion ETL for wrangling or transforming data from sources like S3 and Databricks The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation. Sometimes, we have issues with the solution's stability and need to restart it for…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The product is developer-friendly."
"The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources."
"The solution's most valuable feature is the CDC (Change Data Capture) component."
"It has improved the costs of managing my customer’s data."
"The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python."
"Matillion's technical support is excellent."
"It has helped us to get onto the cloud quickly."
"The product has a good user interface."
"We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL)."
 

Cons

"The solution must add more Python-based implementations."
"The tool's lineage is very weak."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"The product must enhance its near-real-time data capture feature."
"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."
"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."
 

Pricing and Cost Advice

"The solution’s pricing is affordable."
"It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."
"The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges."
"It was very easy to purchase through the AWS Marketplace, but it was also expensive."
"Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing."
"The price of Matillion ETL is reasonable."
"Matillion ETL is expensive."
"Matillion ETL has a pay-as-you-go pricing model of a few dollars per hour of runtime."
"The prices needs to be lower."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
862,624 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Insurance Company
13%
Manufacturing Company
6%
Healthcare Company
6%
Financial Services Firm
17%
Computer Software Company
15%
Manufacturing Company
9%
Healthcare Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for dbt?
It is cheap because dbt is open source. If you compare the pay-per-service of Dbt with the open source option you can manage. We are managing the solution, when we were acquiring service from them....
What needs improvement with dbt?
SQL statements that beyond DML, are not possible. Currently, they are not possible in Dbt. Having more features in SQL statements will support us. Another issue is the terms of data ingestion becau...
What is your primary use case for dbt?
We use the solution to deal with data transformations inside different organizations.
What do you like most about Matillion ETL?
The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
What is your experience regarding pricing and costs for Matillion ETL?
While pricing can be an issue compared to other solutions, Matillion Data Productivity Cloud offers discounts and special deals, especially when dealing with high-volume clients or fewer existing c...
What needs improvement with Matillion ETL?
There are problems with GCP connectivity. Specifically, connections to BigQuery for extracting information are complex, and the optimization of the extraction process requires improvements. I raise...
 

Also Known As

No data available
Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
 

Overview

 

Sample Customers

Information Not Available
Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: July 2025.
862,624 professionals have used our research since 2012.