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
Score 9 out of 10
Vetted Review
Verified User
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.
Pros
- 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
Cons
- 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
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.
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.
Comments
Please log in to join the conversation