Matillion for Snowflake - Excellent (cloud-only) solution for ELT pipelines and complex transformation needs
Updated May 27, 2019

Matillion for Snowflake - Excellent (cloud-only) solution for ELT pipelines and complex transformation needs

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Matillion

Few months ago, we'd decided to migrate on-premise BI stack to cloud as on-premise solutions were not able to meet growing demands. Clearly, we were looking for cloud-only solutions. After extensive research and POC of several tools, we've onboarded Matillion. Matillion is primarily used by BI developers for ELT pipelines (External applications, API, Database, CSV ..) and transformation but the resulting data is used by the whole organization via the dashboard or Excel extracts. Direct data integration connectors, powerful transformation capabilities, user-friendly interface, error handling, logging, tight integration with Snowflake, extensive usages documentation and excellent technical support inclined our decision towards Matillion. It reduced the development time drastically. Data load performance is pretty impressive compared to on-premise deployments.
  • Seamless connectivity with Snowflake. Direct data connectors are available for popular applications
  • Powerful data transformation capabilities. Several components available to support complex data transformation
  • Python and Bash script component allows endless possibilities
  • Pretty impressive performance
  • Excellent Technical support and usage documentation
  • Timely upgrade and bug fixes. New features included in every release
  • Integration with SOAP API's especially Amazon MWS is not straight forward
  • Collaborative and autosave feature sometime become painful when multiple developers are working on the same Project
  • Merge Job or changes feature is not available which makes production deployment time consuming
  • Load data in Snowflake with minimal efforts. Loading data from REST API's require few hours instead of days. Effective manpower utilization
  • Upscale or downscale instance size on demand which makes it a cost-effective solution
  • No need to maintain and upgrade infrastructure which means no separate operational cost and downtime
Easy to configure and intuitive user interface makes development quick and easy. Usage instruction for each component is integrated within each component. Execution steps logging, clear error messages and error handling reduce development time. Auto documentations for Jobs is an excellent feature.
Matillion has published a step by step guide on support portal which makes it easy to configure up and running test instances in less than an hour. However, production instance configuration will depend on deployment strategy, familiarity with AWS ecosystem, security requirements and connectivity with on-premise applications.
Instance size can be upgraded or downgraded with few clicks and hourly billing rate will change immediately. No need to restart Matillion instance. Matillion Enterprise edition has several benefits and will be activated automatically by configuring ">=m4." large instance size
Matillion is the best alternative for on-premise ETL tools if you are looking for a cloud-only solution. None of the tools we evaluated provide same features offered by Matillion. Extensive technical documentation is available on the website which makes development easy and fast. Excellent technical support is willing to assist 24/7 and provide meaningful resolution.
Matillion ETL for Snowflake is an excellent tool to create ELT pipelines to integrate in-house and external applications. It has several integration components which simplified data loading. Provides powerful transformation capabilities which require hours of coding otherwise. Complex transformation requirements can be achieved using the Python component.

Matillion Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Metadata management
Testing and debugging
feature 1