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."Matillion ETL is one hundred percent stable."
"The loading of data is the most valuable feature of Matillion ETL."
"The product's initial setup phase was easy."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"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)."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"The most valuable feature of Snowflake is it's an all-in-one data warehousing solution."
"Time travel is one feature that really helps us out."
"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"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."
"Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."
"The most valuable features of Snowflake are that you have to pay per usage, and you don't have to worry about the maintenance of the data warehouse because it is on the cloud."
"The product must enhance its near-real-time data capture feature."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"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."
"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"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."
"They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in."
"The pricing of the solution should be much easier to calculate or find by yourself."
"There is room for improvement in Snowflake's integration with Python. We do a lot of SQL programming in Snowflake, but we go to a different tool to program when we have to in Python."
"It's not that flexible when compared to Oracle."
"Snowflake needs transparency over costs and pricing."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
"The documentation could improve. They should provide architecture information."
"Product activation queries can't be changed while executing."
Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews while Snowflake is ranked 1st in Data Warehouse with 94 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.