Matillion ETL for Snowflake

Starting from $1.37/hr or from $9,950.00/yr (17% savings) for software + AWS usage fees

Matillion ETL for Snowflake makes loading and transforming data on Snowflake fast, easy, and affordable. Prices start at $1.37/hour with no commitments or upfront costs. Need to cut your ETL development time in half and shave months off your projects? No problem. The AMI takes less than five minutes to set up and delivers results much faster than traditional ETL technologies. With just a few clicks, you can load data into Snowflake from dozens of sources, including S3 and RDS; multiple databases and APIs; common systems like Google Analytics, Salesforce, Netsuite, and SAP; and even social m... See more

Customer Reviews

  • 5
  • 4 star
  • 3 star
  • 2 star
  • 1 star
Create Your Own Review

5-star reviews ( Show all reviews )

Continually Impressed!

  • By Mark
  • on 06/29/2018

Our consulting firm first leveraged Matillion for a medium sized data mart. This tool does everything we need and more. The out-of-the-box orchestration components can get you pretty far, and the SQL script component and Python component pretty much covers the rest. Our data mart is iterating through text files, excel files, and firing API's (setting cookies, handling pagination and rate limiting). Everything works great, and I can access the project from anywhere.

The support team has been absolutely fantastic throughout the process of our product ramp up. The documentation is very robust, albeit sometimes difficult to locate. The Snowflake documentation isn't as comprehensive as the Redshift documentation, but it is 95% similar. I got hung up once on a feature revision that wasn't added to the core documented. The API input parameter example in the document simply no longer worked as documented. I later found that a change was highlighted in the release notes, but not before support resolved my issue. I have also had a version release break my code (script tasks stopped allowing SELECT statements for instance). These release management activities will need attention as the the number of clients grow, but the strong support team has done a great job of mitigating the fallout.

So far the only gap I have hit is the lack of a Dropbox connector, and some file management tasks. Both can be handled with Python so it has been a relative non-issue. I've worked around some of the other built-in features to give myself better control of processes and better error trapping. This was using standard components, such as a loop iterator instead of the out-of-box API pagination (which is also quite cool).

That's it! I encourage folks to try the tool. After years of avoiding SSIS, I'm falling back in love with ETL development!

Matillion - Just What We Needed

  • By Happy Customer :)
  • on 03/28/2018

We are using Matillion ELT to rearchitect existing and build new data pipelines for our cloud analytics platform. We have seen immediate value-add in loading large amounts of data, which was a previous problem using AWS Data Pipeline. The easy user interface and powerful components have been a major plus amongst developers. Setup could not have been simpler, and the support from both sales and tech has enabled us to drive speed to value.

Solid solution, strong feature set, very cost effective.

  • By cfranklin
  • on 03/20/2018

We are using Matillion ELT for Snowflake to re-architect a legacy solution. The capabilities, features and user-experience have dramatically simplified the project.
All in all, Matillion (product and team) have helped accelerate our time to value with pre-built connectors, a robust feature set, tutorials and rich content. Definitely recommend putting it on your short list if you want a solution to build ELT pipelines for Snowflake (or Redshift).

ETL for the cloud : about time

  • By Happy User
  • on 12/20/2017

Having used most of the on-prem based ETL tool in the past its great to see an entirely cloud based approach built ground up for the cloud.

Orchestratation and logic are easy to perform with Matillion. We used it at a major UK power company for general ETL,testing and managing data flows.

I would suggest anyone looking to peform ETL (or ELT as it should be called) on cloud based infrastructure should consider Matillion.

Matillion - They Got it Right (Matillion Rocks)!!

  • By apatel
  • on 10/05/2017

Matillion ETL Amazon Snowflake is very innovative ETL/ELT tool. They have done an excellent job providing all of the powerful components for Snowflake. The user interface is very model and extremely easy to navigate. I personally have a ton of experience with SSIS and Informatica, and I believe this tool is something I would like to use on my next project.

I have been extremely impressed with Daniel and Ian over Matillion. They both have made the setup and training very easy and they are extremely helpful. I am very impressed with their knowledge, and not just in their own tool, but other ETL/ELT tools. I believe that Matillion has a great product along with unbelievable support. I am excited about collaborating with Matillion because I firmly believe it will be very cool and rewarding adventure.

showing 1 - 5