Copying Data From RDS Into Amazon Redshift w/ Matillion ETL

  • Richard Thelwell
  • February 15, 2016

Matillion ETL for Amazon Redshift makes data ingestion from sources such as Amazon RDS incredibly easy. Copy data from RDS into Amazon Redshift using a single orchestration component in our powerful ETL/ EL-T tool and use this to create awesome transformation jobs.

Getting data from Amazon RDS into Amazon Redshift can be an arduous task. The typical steps required involve writing a query to get the data from RDS, putting this into a flat file, uploading that to S3 and then copying it into your Redshift table.

Sounds like a lot of hard work right?

Well, with Matillion ETL for Amazon Redshift you can do ALL of that with a single component and can set it up in a matter of minutes.

Don’t believe us? Watch this short tutorial video to see the tool in action.

Using the RDS Query component

The RDS Query component in Matillion ETL for Amazon Redshift allows you to run an SQL Query on an RDS database and copy the result to a Redshift table, via S3.

rds amazon redshift rds query component

By creating a simple orchestration job in Matillion ETL for Amazon Redshift, you can use this component to ingest data from RDS.

Simply hook up the RDS Query component and fill in the missing parameters, as shown below. Once these fields validate, the component will work and the job will run.


From there you can carry out further data processing, creating transformations in our high performance, user-friendly, graphical job development environment.

You can find out more about the RDS Query component by visiting our Redshift support site.

Matillion ETL for Amazon Redshift

The RDS Query component is just one of many fantastic features in Matillion ETL for Amazon Redshift.

You can find out more about our tool by visiting the product page here.

Alternatively you can schedule a free demonstration with a member of our team, who can run through any questions you might have.

You can access a free 14-day trial of Matillion ETL for Amazon Redshift on the AWS Marketplace right now.

New Call-to-action