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."The product has a good user interface."
"It has helped us to get onto the cloud quickly."
"It's been able to do everything we require."
"The most valuable feature of Matillion ETL is its user-friendly graphical interface."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"It is pretty user-friendly, even for people who aren't super technical."
"It has good integrations with Amazon Redshift and other AWS services."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"Snowflake is faster than on-premise systems and allows for variable compute power based on need."
"The speed of data loading and being able to quickly create the environment are most valuable."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"The most valuable features of Snowflake are its performance and power."
"The features I found most valuable with this solution are sharing options and built-in time zone conversion."
"It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
"As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"It needs integration with more data sources."
"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."
"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."
"The cost of the solution is high and could be reduced."
"In the next release, we would like to have connections to more databases."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"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."
"Currently, Snowflake doesn't support unstructured data."
"Pricing is an issue for many customers."
"Snowflake has to build more capabilities because they have only built very few adapters, but they're growing and they're building. They should provide provisions to collect ETL pipeline capabilities, reduce developer work, and make more rapid application development, rather than some customizations. There are very few options, but they are building. I hope they will build ETL rapid application development provisions with more variety."
"The cost is a bit high."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"I am still in the learning stage. It has good security, but it can always be more secure."
"I have heard people having difficulty with the machine learning model, so there may be room for improvement."
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 Apache Hadoop.
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.