Matillion Pricing, Features, Reviews & Comparison of Alternatives


Extract, transform, load platform for cloud data warehouses

4.27/5 (95 reviews)

Matillion overview

Matillion is an extract, transform, load (ETL) solution for cloud data warehouses including Amazon Redshift, Snowflake and Google BigQuery. It enables users to gather data from various sources and deliver them in structured and semi-structured frameworks using platform's data transformation capabilities. The search functionality lets enterprises find specific results across notes, jobs, and components within projects through term-based searches.

Key features of Matillion include data export/import, collaboration, audit logs, scripting, job scheduling, version control and task management. Businesses can use the automation tools to schedule multiple orchestration jobs against a project at predefined time intervals. Plus, it enables administrators to ensure data security by managing user access across Active/LDAP directories, SSL certificates and authentication to use information from the local directory.

Matillion facilitates integration with several third-party applications to aid with data management across cloud warehouses such as Facebook, MailChimp, Amazon RDS, Hubspot, Salesforce, Elasticsearch, Google Analytics, JIRA, Marketo, and more. It also comes with an application programming interface (API) query component, which allows users to integrate the platform with any JSON or XML-based API.


Pricing options
Value for money
View Pricing Plans


Business size



United States, Asia, Australia, Brazil, Canada and 8 other markets, China, Europe, Germany, India, Japan, Latin America, Mexico, Middle-East and Africa

Supported languages

Matillion screenshot: Matillion ETL workflow screenshotIntroducing Matillion ETL for Snowflake | Available on Azure or AWS MarketplaceMatillion screenshot: Matillion SQL editor screenshotMatillion screenshot: Matillion component failure screenshotMatillion screenshot: Matillion RDS query screenshotMatillion screenshot: Matillion documentation screenshot

Matillion reviews

Value for money
Ease of use
Customer support
Graham Lannigan

Easy to use solution, allowing rapid delivery of ELT processes

Used daily for 2+ years
Reviewed 2019-06-14
Review Source: Capterra

We came to Matillion while looking for a tool that would allow us to orchestrate our load processes for Amazon Redshift. We'd used other ETL tools previously, were blown away by how easy it was to pick up and understand Matillion. We liked the simplicity, and the fact that we could always dig into the SQL that was generated. New features are added frequently, and we usually find one or two improvements that directly impact us with each release. Their support team are also very responsive, and Matillion are always keen to help you get the most out of their software, so there's a lot of support if you want it. 2+ years later, and we're using Matillion to run all our ELT jobs across various data warehouse projects, and very happy with it.

Read the full review

Sandeep Kumar

Need on the fly connectivity to different instance of Redshift

Used daily for 2+ years
Reviewed 2019-06-14
Review Source: Capterra

I like the bunch of API integrated in Matillion it helps me to directly grab the data from different sources without manually extra and import in my database.

Read the full review

Michael Sprague

Great for pipelining data to warehouse/lake, not getting it back

Used occasionally for 6-12 months
Reviewed 2019-06-13
Review Source: Capterra

It was easy to get set up, and it worked great for pushing data into Snowflake as a data warehouse. However, we quickly realized that we would need yet another tool to get the data back out to the source systems to synchronize/integrate it. We could sort of do it with Matillion, but it required a lot of custom programming and was not very intuitive. We ended up using a different iPaaS tool that could handle traffic/integration in both directions.

Read the full review

Bruce Linn

Matillion - orchestrating complex ELT for analytics

Used daily for 2+ years
Reviewed 2019-07-08
Review Source: Capterra

Our business requires us to ingest large amounts of data from customers on a frequent basis. Once typical ELT has been performed, we create customized data stores which are used in a variety of ways including modeling, machine learning and a SaaS front end. Matillion has been instrumental in our ability to move this processing from file systems to Big Query where our performance has moved from days to hours.

Read the full review



Used daily for 6-12 months
Reviewed 2019-06-24
Review Source: Capterra

I like working on matillion , but this tool can be made more flexible by providing some of the additional features.

Read the full review

User recommendation
Based on 95 user reviews

Matillion pricing

Pricing options
Free trial
View Pricing Plans

Pricing is available on an hourly basis, starting at $1.37. Matillion versions for Amazon Redshift and Snowflake also support annual billing. Contact Matillion for more information.

Value for money
Based on 79 user ratings

Matillion features

Activity Dashboard
Collaboration Tools
Data Import/Export
Permission Management
Role-Based Permissions
Third Party Integration

Access Control (12 other apps)
Applications Management (11 other apps)
Automatic Notifications (20 other apps)
Commenting (11 other apps)
Custom Development (19 other apps)
Customizable Branding (14 other apps)
Customizable Templates (15 other apps)
Drag & Drop Interface (21 other apps)
Offline Access (10 other apps)
Real Time Notifications (13 other apps)
Reporting & Statistics (10 other apps)
Testing Management (11 other apps)
Workflow Management (15 other apps)

Based on 95 user ratings

Additional information for Matillion

Key features of Matillion

  • Non-Relational Transformations
  • Orchestration Components
  • Project Import/Export
View All Features