Skip to main content
TrustRadius
Matillion

Matillion

Overview

What is Matillion?

Matillion is a productivity platform for data teams.Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed…

Read more
Recent Reviews

in my opinion, Meh

1 out of 10
March 29, 2024
Incentivized
We are moving away from Matillion to MWAA Airflow with dbt.
Maintaining source control in github is important to us.

We have used Matillion …
Continue reading

Matillion - Decent

6 out of 10
March 19, 2024
Incentivized
We use Matillion to schedule and run our ETL jobs. This helps our company to have accurate and timely data in order to make data-driven …
Continue reading

Matillion Review

8 out of 10
February 07, 2024
Incentivized
We use Matillion for loading data from various sources into Snowflake Data Lake. We have data in various source systems such as SQL …
Continue reading
Read all reviews

How Matillion Differs From Its Competitors

Time to Value

One of the key strengths of Matillion is its user-friendly interface, which allows non-technical users to easily set up data integrations and transformations. The platform supports a wide range of data sources, including cloud-based databases, file systems, and APIs, making it an excellent choice …
Continue reading

Time to Value

We have started doing some research about ETL tools since we decided to do not to develop it a house, and after talking with some colleagues and reading about Matillion, we decided to move it forward, and that was our time schedule: Research and ETL tools try 45 days Developing our project on …
Continue reading

Cost Savings

The long term savings from Matillion have primarily come through decreased work hours associated with building, maintaining and trouble shooting ETL processes.
Continue reading

Business Outcomes

Matillion's connection options are robust. We have been able to connect to many different database types, as well as build direct connections with our partner APIs.
Continue reading

Onboarding

Maybe two weeks to get over the initial hurdle and then we were off to the races. For the most part Matillion is very intuitive, simple, and easy to implement.
Continue reading

Time to Value

My learning curve was long. Matillion is simply not like any other ETL / ELT tool out there, because Snowflake isn't like other cloud databases out there. I had to first learn a different pattern of data movement and error checking. Next, I had to learn which components to use and when. There …
Continue reading

Onboarding

a full year to get fully implemented. The onboarding was immensely painful given the documentation was lite and incorrect in many places. Many patterns of use I had to figure out for myself. At the time of implementation there was no developer community and the only company contact was through the …
Continue reading

Time to Value

The internal communication and collaboration than the setup of Matillion, once the EC2 instance triggered, we were able to get started with transformation jobs within 1 hour.
Continue reading

Time to Value

Matillion was implemented within one week in our organization for full functionality. Our company secured its deployment within this period of time and all our programs were able to run smoothly. The learning curve was easy to master and get it run as expected within a short period of time. Our …
Continue reading

Time to Value

I started reading about Matillion and after one week and talking to their support team I started my project and it was up and running after 2 weeks of developing.
Continue reading

Time Saved

Yes, after I started using Matillion our ETL process became much faster and we are running the instance on AWS only 1 or 2 hours per day which means we are not spending too much money but we are having many benefits once the process is much faster now and our visualization team can find the data …
Continue reading

Cost Savings

Before Matillion we used to use software created by our own company which was already old to date and it was really hard for our new employees to get in of it. Using Matillion we are saving money on training for new partners and now we have a much more organized ETL environment.
Continue reading

Business Outcomes

Yes. We don't have a lot of data sources but all of them we were able to connect smoothly and import our data easily.
As an example of our data sources I can mention, Relational Databases on AWS running SQL SERVER, we have some input from S3 (text files) and of course, some excel files.
Continue reading

Onboarding

Matillion's implementation was really really easy and smooth, most of my questions I could find solve questions using their forum or sending them an e-mail which was replied to within 1 or 2 days. Their documentation about all the components I consider complete and with good examples of how to …
Continue reading

Time to Value

It took some days in order to figure out how to configure the environment and all the basic configurations. Writing simple jobs took a really short time to learn (hours), while in some other days I was able to prepare a full orchestrator. Parameters configuration is a little more complex and I had …
Continue reading

Time Saved

We're using Matillion for ELT and processes are slower. It is a mix of Matillion efficiency and DB performance, but the total result is better than before. We are using a Large account and it is the right choice, while with the Medium size we weren't able to performe the same results and we had …
Continue reading

Cost Savings

We are reading from many different sources. Extraction times are better than before and we found almost all the connectors we needed and the support helped us to obtain the best extraction performance. Matillion costs are coherent with the usage, and it is useful that we are not paying when the …
Continue reading

Business Outcomes

We were able to connect all data source, but we had some issues with SAP: the native Netweaver connector do not allow to read SAP tables in join, as the 2 tables are loaded in memory and the join is apply at the end. Therefore we had "out of memory" issues with this strategy. But we could find …
Continue reading

Onboarding

Matillion is really easy to use, so we were able to start writing our flows easily. The activation is still easy, but you need to have some tech skills to work with putty and install what is missing (specific ODBC etc). For these aspects we moved questions directly to Matillion's support and the …
Continue reading

Time to Value

Within a month of getting Matillion we had an established pipeline that was extracting data from the company's application database and updating the corresponding data in the warehouse. Additional data source (e.g. Salesforce and Netsuite) were quick to implement (c. 2 weeks per data source) …
Continue reading

Time Saved

Yes we did. It was possible to update the data warehouse database every 3-4 hours instead of every 24 hours. In addition, and perhaps more importantly, it provided a more stable ETL process. The previous one was prone to breaking/failing and Matillion provided a more reliable process and one that …
Continue reading

Cost Savings

In terms of infrastructure costs, our costs have gone up using Matillion. Historically we used AWS DMS to clone the production database into a Postgres database. This old process, however, was prone to issues and failures, e.g. when the production database was updated with new column(s)/table(s) …
Continue reading

Business Outcomes

We were able to connect to our main data sources using Matillion (a MySQL database, Salesforce and Netsuite). Other data sources, that are API based and didn't have specific components in Matiilion were more of a challenge at the time. Although API functionality has been improved since we …
Continue reading

Onboarding

Onboarding was quick and relatively pain free. The team did have experience using Matillion prior to implementation which obviously helped. However, once the server was setup with the appropriate security groups to access data sources, building the Matillion jobs was straight forward and the UI …
Continue reading

Time to Value

Proof of concept took a couple of weeks. Getting access to private SQL databases was a little fiddly as we needed to install some drivers which we would have expected to be installed as default, but once up and running, we have had no issues. Tweaking firewalls settings to allow Matillion access …
Continue reading

Time Saved

Reports that took approximately 3 hours to pull together and performed on a manual monthly basis were handled automatically and daily in a matter of minutes. These manual reports were pivots in Excel and were pushing Excel to its limit (Excel would freeze). There was a lot of data being shifted …
Continue reading

Cost Savings

As it was automating a manual process, the savings were more in terms of saving resource. Automating has also opened up the report to more internal users.
Continue reading

Business Outcomes

We are able to connect our bespoke systems and third party systems. One that proved quite difficult was the Xero connector. Although hooking up with Matillion was straightforward, the data Xero connector was not provided the data we needed so are looking at our ETLs for this this specific issue.
Mor…
Continue reading

Onboarding

The project has been stop and start over a couple of years. We moved from AWS Matillion to Azure Matillion but it is now stable and pulling various sources in reliably. Setting up success/failure notifications has been key.
Continue reading

Time to Value

I watched training and example videos/seminars for about two weeks before getting an instance set up for the company. And from there, I had a usable workflow going within another week.
Continue reading

Time Saved

Yes, Matillion allowed for daily schedules to provide updated data for reporting at the same time each morning. It also removed any need for manual data updates.
Continue reading

Business Outcomes

Yes, Matillion allowed for connections to all SQL based data sources via JDBC, all files from FTP sites, and all REST API sources. It simplified all of the different data pipelines and allowed for more interaction between them.
Continue reading

Time to Value

Matillion being ELT cloud tool offers easy to implement which requires an AWS EC2 instance and licensing.
Training on Matillion and getting the development team on-board was quite a challenge. Would require immense experience to explore the core functionality of Matillion. Matillion was running …
Continue reading

Time Saved

Yes, there were absoultely increased in reporting speed that our team was able to delivery. Intially we had our own scripting tool to generate result which took 2 weeks (around 80 hours of development time + testing time) whereas using matillion we were able to complete the development in 32-40 …
Continue reading

Cost Savings

While moving away from legacy system towards matillion it offered some significant cost on matillion hosting and licensing part but we were able to save some on legacy system hosting but majority of saving where on people resource which was huge cost saver for our organization. along with that …
Continue reading

Business Outcomes

Our organization work in digital marketing industry and matillion do provides lots of connector related to digital marketers. Matillion was able to solve 90% of our data sources connection problem but there were few of the rarer sources which matillion din't provide the connection to. Hopefully …
Continue reading

Onboarding

Our team member had already the knowledge of other ETL tool in market which made us easier to transform to Matillion as ETL tool. Initally when there were more rigrous update on tool, it took us few months to understand all the different features of the product and use them. We used to reach out …
Continue reading

Time to Value

We were able to get up and running with Matillion within a month. With no real training in the tool, we were able to develop useful jobs and an entire job framework on Matillion within that month. As we got more familiar with it, within three months, we were able to take advantage of additional …
Continue reading

Time to Value

From the moment we bought it on AWS marketplace to connecting to our monolith database it took a matter of hours. Deciding the Redshift table structure we needed for storage actually took longer than the actual setup time! That is a definite plus for anyone who wants to get up an running as soon …
Continue reading

Time to Value

To migrate an existing ETL solution from an old product to Matillion, will require a compete rework with some redesign. Estimate depends on the complexity required. Would estimate anywhere between 3-9 months.
Continue reading

Time to Value

Within 2-3 weeks from starting Matillion, we had our first simple pipeline in production: extracting data from our operational database and putting it into data warehouse.
Continue reading

Time to Value

Our initial POC demonstrated that migrating to Matillion was the logical next step for our organization. Our expectation had been six months to migrate our production loads from legacy tooling to Matillion. We were able to migrate complex production workflows, validate the result, and promote the …
Continue reading

Time to Value

About 1 week which included hands on and looking at online documentation. Part of the delay was just getting access to internal company data.
Continue reading

Time to Value

Used the trial edition initially and was able to set up an ETL process for production, which then started populating real reports in 6 weeks. Previous process was quite manual, a combination of Alteryx and Excel which took a lot of time.
Continue reading

Time to Value

Took 1 day to deploy, get logged in, and connect to Redshift.

Took 1 month to make it useful in production, and 9 months in, I'm still learning features and quirks of Matillion.
Continue reading

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 11 features
  • Simple transformations (124)
    8.1
    81%
  • Connect to traditional data sources (122)
    7.7
    77%
  • Complex transformations (123)
    6.4
    64%
  • Testing and debugging (109)
    5.5
    55%

Reviewer Pros & Cons

View all pros & cons
Verified User
Employee in Information Technology
Consumer Services Company, 51-200 employees
Verified User
Team Lead in Engineering
Consumer Services Company, 201-500 employees
Return to navigation

Pricing

View all pricing
Matillion

Matillion

N/A
Unavailable

What is Matillion?

Matillion is a productivity platform for data teams. Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality…

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.matillion.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

26 people also want pricing

Alternatives Pricing

Fivetran

Fivetran

$0.01
What is Fivetran?

Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using…

Astera Centerprise

Astera Centerprise

N/A
Unavailable
What is Astera Centerprise?

Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.

Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

7.6
Avg 8.3

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

7.3
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

7.2
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

8.2
Avg 8.2
Return to navigation

Product Details

What is Matillion?

Matillion is a productivity platform for data teams.

Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed and scale that matches the business’s data ambitions.

The vendor states enterprises including Cisco, DocuSign, Pacific Life, Slack, and TUI use Matillion to move, transform, and orchestrate their data for a wide range of use cases from insights and operational analytics, to data science, machine learning, and AI.

Native integration with popular cloud data platforms such as Snowflake, Databricks, Amazon Redshift and Google BigQuery lets data teams at every skill level automate management, refinement, and data delivery for every data integration need.


Matillion Features

Data Source Connection Features

  • Supported: Connect to traditional data sources
  • Supported: Connecto to Big Data and NoSQL

Data Transformations Features

  • Supported: Simple transformations
  • Supported: Complex transformations

Data Modeling Features

  • Supported: Business rules and workflow
  • Supported: Collaboration
  • Supported: Testing and debugging

Matillion Screenshots

Screenshot of Matillion's GUI, used to orchestrate jobs with control data flow functionality, automating the ETL process.Screenshot of where structured and semi-structured data can be prepared to create clean data sets that can be used with any BI/reporting/visualization tool of choice. Matillion reads and combines data across a target warehouse external storage, such as S3 or Blob.Screenshot of Matillion's self-validating components, sample and row counts. If a job does fail, the warehouse queue services available with Matillion can be used get an alert to a connected email or Slack account.Screenshot of the SQL component used to run custom scripts from within Matillion. With hundreds of pre-built connectors out of the box, Matillion can handle complex transformation needs.

Matillion Integrations

Matillion Competitors

Matillion Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

Talend Data Integration, Informatica Intelligent Cloud Integration Services, and Fivetran are common alternatives for Matillion.

Reviewers rate Data model creation and Metadata management highest, with a score of 9.1.

The most common users of Matillion are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(204)

Attribute Ratings

Reviews

(26-50 of 125)
Companies can't remove reviews or game the system. Here's why
March 18, 2023

Matillion for driving Data Mesh

Verified User
Team Lead in Information Technology
Transportation/Trucking/Railroad Company, 5001-10,000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited for organizations who would like to start on small scale as Matillion has their offerings on AWS marketplace.
Matillion is quite good when it comes to cloud connectivity
One of the best tool while working with Snowflake
March 14, 2023

Matillion - Robust ETL tool

Vinod Kumar C | TrustRadius Reviewer
Vinod Kumar C
Technical Systems Analyst
Juniper Networks (Telecommunications, 10,001+ employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
I prefer Matillion for:
  1. Salesforce integrations. Not just extracting the data from Salesforce, but it has capability to even push the data to Salesforce.
  2. API integrations: Nowadays, all the applications are exposing their data using APIs instead of direct connectivity for security and other reasons, and Matillion has the ability to extract from all kinds of API sources.
  3. The ability to run the same job in other environment by setting up different environments within the same project.
Scheduling is very basic and does not have advanced capabilities. So this needs to be improved.
March 08, 2023

Matillion... Right tool for the right time.

CO
Clay Owensby
Directory, Data and BI Technology
NASCAR (Entertainment, 1001-5000 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is a great tool for mid sized data platforms. Most of the components are easy to understand and data movement is swift. Matillion's documentation is less than desirable and the customer support is at minimum painful.
March 08, 2023

Low Code and Python component review

JS
Jason Schwartz
Programmer Analyst
BISSELL (Consumer Goods, 1001-5000 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is very strong when it comes to its SQL components and plays very nicely with loading files from S3 to Redshift. It is less desirable for those who want to use a lot of python though, at that point their experience would be limiting.

March 08, 2023

Matillion - easy to use ETL tool

Trupal Patel | TrustRadius Reviewer
Trupal Patel
Senior Software Engineer
Autodesk (Computer Software, 10,001+ employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is powerful and easy-to-use data integration and transformation platform which can handle large volumes of data like our company where we process billions of data every day. Also, it's customer support helped our team to achieve our goal on time.We use AWS in our company and Matillion provide integration with it
March 08, 2023

Matillion easy and faster

Sahil Bhange | TrustRadius Reviewer
Sahil Bhange
Sr Data Engineer
Enova International (Financial Services, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited for:Data warehouse with moderate technical skill can do wonder with SQL based ELT data pipelinesIf Org has data lake in Snowflake or other Cloud database, Matillion can access all data and DWH/BI team can create their data marts with less frictionReduces dependency on highly technical folks for data processing.

Matillion is less suited for:
Complex machine learning and data science task.
September 21, 2022

Matillion, a nice ETL tool.

Verified User
Analyst in Information Technology
Computer Software Company, 10,001+ employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
I always suggest Matillion for organizations that do not want to spend money and time developing their own ETL tool, Matillion is a mature one and meet all requirements about it. It is important to check if you have any edge case and have a look if it is covered by Matillion or not.
April 18, 2022

Build your own customized version of a Stitch and FiveTran-like data replication process, but better, faster and able to evolve with your needs

Jay Archer | TrustRadius Reviewer
Jay Archer
Manager of Data, Reporting, and Analytics
ReCharge Payments (Internet, 51-200 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Great if you need a visual, customized, powerful data engineering and data integration platform that can do pretty much anything. I have yet to hit a situation that I can't solve one way or another. Not great if you only have time for a plug-and-play solution. This is not Stitch or FiveTran, but if you invest the time to learn and use Matillion you can end up with a vastly better solution to your data needs.
November 06, 2021

Most flexible and user-friendly ELT platform to support a modern data stack

Verified User
Engineer in Engineering
Restaurants Company, 501-1000 employees
Score 10 out of 10
Vetted Review
Verified User
Likelihood to Recommend
If your company has ever had issues with un-transparent data pipelines, difficulty understanding orchestration of workflows, and issues with data engineering retention and ramp-up, then Matillion is likely the right solution for you. It doesn't require heavy technical skills, just a strong understanding of Data-Eng Concepts. It's low-code/no-code optionality allows for everyone to come in and quickly understand how jobs are interconnected without having to cross navigate multiple systems for connectors, transformations, loads, and logging. It's an all-in-one solution that complements more specialized solutions like Fivetran and Hightouch. You can even set up python connections to orchestrate Fivetran and Hightouch into a Matillion workflow.
August 02, 2021

Data Integration and transformation platform

Austin Lee | TrustRadius Reviewer
Austin Lee
Data Scientist
Saggezza (Information Technology & Services, 501-1000 employees)
Score 9 out of 10
Vetted Review
Verified User
Likelihood to Recommend
It is very well suited in data management and integration. It has saved our organization from data fraud and mismanagement of information from various sources. It has driven our company forward by delivering useful information that is suited to support our goals. Taking data from various sources and sorting it and uploading it in a cloud warehouse has enabled our departments to handle data properly.
July 09, 2021

Matillion Review

Verified User
Employee in Information Technology
Computer Software Company, 11-50 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is nice if you don't want to spend time developing a home-built application to perform the ETL step and of course if you have a budget to spend on it. I don't suggest Matilion if you want to customize a lot or if you have a really specific environment to handle data.
July 08, 2021

Ease and complete tool, I would suggest it!

Verified User
Consultant in Information Technology
Information Technology & Services Company, 501-1000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It is useful when you need to create a Datawarehouse and put together a complex workflow. The development time is reduced compared to other ETLs. When you are more confident, you can also create complex flows using different job parameters and orchestrator jobs. Buttons for start and end success/end errors are also useful. Connection with source systems is also good.
July 02, 2021

Building a data warehouse from the ground up with Matillion

Verified User
Engineer in Other
Financial Services Company, 201-500 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is great for handling bulk and 'delta' loads to your warehouse, i.e. updating the warehouse with only those records updated since the last execution of the pipeline. The components and Python scripting provide a huge amount of flexibility in what the pipeline does, but you do need to have the expertise to know how to implement it properly.

Matillion has been less good at extracting data from APIs. The functionality was found to be complex and it was unclear how to manage things like pagination and rate limiting in API calls.

June 30, 2021

Visual ELT at its best

Verified User
C-Level Executive in Information Technology
Insurance Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is very well suited to connecting to online data sources, as it has an array of connectors that are already set up with third parties. It is easy to get started and can be hosted in AWS or Azure. You only get charged per hour so it is cost-effective if set up correctly.
June 29, 2021

Matillion Review

Sudarshan Kothari | TrustRadius Reviewer
Sudarshan Kothari
Lead Analyst
iQuanti, Inc. (Information Technology and Services, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion works best when automating the workflow from the various digital platforms. It provides the best use-case for automation of any dashboarding/reporting requirement where data is stored in one of the databases and updated regularly. Matillion might not be the best use-case for core ETL operation as it lacks stability for enterprise (but is improving to high standards with every update).
January 05, 2021

ETL made easy for non-programmers

Verified User
Team Lead in Information Technology
Information Technology and Services Company, 501-1000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
ETL development can happen without much programming using graphical ETL dev tools and Matillion makes it simple. If data movement is what your organization needs then Matillion is your tool. If you need heavy programming for most performant or reusability then Matillion is not very useful.
November 30, 2020

Ease of Use and Reusability for Excellent ROI

MB
Matthew Burr
Sr. Data Engineer
HireVue (Information Technology and Services, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is really well suited to environments using Redshift or Snowflake, and that rely on Amazon Web Services. It is also well suited to scenarios where you need to perform a lot of similar ETL tasks with small variations that could be parameterized. It's great if you want to get up-and-running quickly, and don't want to spend a ton of time in configuration and setup; you can get going very quickly out-of-the-box. It would be less appropriate in on-premise scenarios, where all of your data is stored on-premise. If you don't use AWS, you won't get as much value out of it. Also, in environments with large teams and lots of developers modifying jobs simultaneously, it can be a challenge to coordinate work and manage changes.
October 06, 2020

Beautiful UI and UX to compete with any ETL, but at a cost!

Adel Helal | TrustRadius Reviewer
Adel Helal
Tech Lead Engineer
Campaign Monitor (Marketing & Advertising, 201-500 employees)
Score 3 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Essentially Matillion is a nice tool to build a bunch of Redshift queries with added benefits of having a range of integration features. Considering the annual cost is almost equivalent to a junior engineer, we could spend the time to manually write the Redshift queries we need to transform and load our data that can run on our own microservices, and scale them as we see fit so we aren't faced with the hard limits of EC2 instance sizes. We also wont have to worry about hitting Java heap space limits since we can focus more on the Redshift query/transforms optimizing.
Return to navigation