Matillion ELT for Snowflake
Updated June 08, 2019

Matillion ELT for Snowflake

Anonymous | TrustRadius Reviewer
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.

Pros

  • 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.

Cons

  • 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've used Matillion to start centralizing disparate data sources in one place (our Snowflake data warehouse).
  • Matillion integrates well with our Slack instance for error notifications.
  • Matillion takes advantage of Snowflake's large function library for data transformations.
It is designed to be very customizable. Even when you can't do something directly out of the box, if you know how to code, you can write up a script. Matillion users do need to be fairly tech-savvy to get the most out of this tool. Ideally, power users will have a good understanding of how to use RESTful APIs.
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 is an ELT tool - it's more about how well the cloud-based data warehouse it connects to can scale. And of course, cloud-based data warehouses are designed precisely to do just that with ease.
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.
Great for batch processing structured or semi-structured data. Streaming large data sets will be more difficult but this is not really what the tool is designed for.

Matillion Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
10
Complex transformations
8
Data model creation
9
Metadata management
10
Business rules and workflow
9
Collaboration
7
Testing and debugging
8
Integration with data quality tools
9
Integration with MDM tools
Not Rated

Comments

More Reviews of Matillion