CODEWITHSUNDEEP
amazon-web-servicesamazon-s3amazon-redshiftamazon-rdsamazon-aurora
Hary S
Hary S

Reputation: 140

Move incremental data (CDC) from Amazon RDS to Redshift?

I have a requirement to move incremental data from Amazon Aurora Postgres to Amazon Redshift. This will be a daily job. New data will be inserted into Redshift and if there is a change in existing data it will be updated. Any recommendations for doing this?

Upvotes: 1

Views: 1577

Answers (1)

Chris Williams
Chris Williams

Reputation: 35258

There are 2 methods for doing this by AWS services.

Your first option is looking at DMS, using the Postgres dB as the source and the redshift dB as the target. After performing a one time import you can perform imports of the differential between the last run.

Your second option is to look at data pipeline to build an incremental pipeline.

Upvotes: 2

Related Questions