Matillion ELT for Snowflake
Updated June 08, 2019
Matillion ELT for Snowflake
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
Matillion is used by two different departments at our company - engineering and professional services. For engineering, it is used as an ETL pipeline tool for ingesting data into our internal data warehouse from a variety of 3rd party platforms, ultimately for the purposes of advanced analytics. For professional services, this tool is being used to automate client data load processes.
- ELT - out of the box support for a variety of popular APIs.
- Support for the big players in the cloud data warehouse marketplace - Snowflake, Redshift, and Google Big Query.
- Strong documentation and technical articles, including data models for each supported external data source.
- Support for other programming languages beyond Python.
- Expanded the number of concurrent users (limited depending on license level).
- Increased number of project environments (limited depending on license level).
We were up and running with our first Matillion jobs in about a month. As time went on, we continually iterated upon our orchestration and transformation job designs and came up with standard templates to use for new projects. We did not immediately take any professional training courses - the learning of Matillion came on the job through specific use cases.
Matillion had out of the box support for most of the third party tools we have, plus it integrates well with our data warehouse platform. We found it to meet our use cases after a trial period. It's customizable when you know what you are doing. The use of global and local variables throughout the tool is very helpful.