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 has improved the costs of managing my customer’s data."
"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 technical support treats us well. They already have a support portal, and they are responsive, which helps."
"The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"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."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"I like the idea that you can assign roles and responsibilities, limiting access to data."
"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"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."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"Snowflake has three great features: Snowpiping is proving to be very valuable, Time Travel is excellent, and Snowpipes are another great functionality the solution has made available."
"The most valuable feature has been the Snowflake data sharing and dynamic data masking."
"It's user-friendly. It's SQL-driven. The fact that business can also go to this application and query because they know SQL is the biggest factor."
"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 tool's lineage is very weak."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"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."
"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."
"Performance can be improved for efficiency, and it can be made faster."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"We would like to be able to do modeling with Snowflake. It should support statistical modeling."
"The cost of the solution could be reduced."
"They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better."
"Snowflake has support for stored procedures, but it is not that powerful."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
"The design of the product is easily misunderstood."
"They should improve the reporting tools."
"These days, they are pushing users towards the GUI or graphical version. However, I am more familiar with the classic version. I'd like to continue to work with it using the older approach."
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, SSIS, Informatica PowerCenter 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.