We performed a comparison between Matillion ETL and Snowflake based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."It is pretty user-friendly, even for people who aren't super technical."
"The product has a good user interface."
"It's been able to do everything we require."
"Matillion ETL is one hundred percent stable."
"It has helped us to get onto the cloud quickly."
"The loading of data is the most valuable feature of Matillion ETL."
"The most valuable feature of Matillion ETL is its user-friendly graphical interface."
"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."
"It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability."
"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."
"The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications."
"They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises."
"The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."
"The technical support on offer is excellent."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"The cloning functionality has been the most valuable. I have been able to completely copy databases. The data sharing concept is also useful. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"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."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"I would like to see a client version of the GUI."
"Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database."
"In future releases, it can also support full unstructured data."
"Support needs improvement, as it can take several days before you get some initial support."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. Matillion ETL is rated 8.6, while Snowflake is rated 8.4. The top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Matillion ETL is most compared with Azure Data Factory, AWS Glue, Informatica PowerCenter, SSIS and Informatica Cloud Data Integration, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and Amazon Redshift.
We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.