By using AWS re:Post, you agree to the Terms of Use

Incremental Copy of RDS Aurora MySql Table to RedShift



To copy/incrementally copy data from Aurora MySql 5.7 to RedShift, can anyone share implementation steps? i couldnt do it with DataPipeline, Glue, DMS due to Certificate Issues at the Db.

  1. Scheduled Jobs that does S3 exports of initial/changed data. This is the least expensive as you can decide what tables to export data from and how often. You can decide to do that every 10 mins or so. AWS Batch can be used with Lambda to accomplish this. - any references to Achieve this?

Any other better optimised ways?


asked 2 months ago25 views