I am using AWS Data Pipeline for copying my RDS MySQL Database to Redshift. I need to create separate pipeline for each table and each pipeline create new EC2 instance. (Process takes time).
**Problem**
Is there any way to load whole database table into Redshift with single Data Pipeline . so i can schedule it and sync all my data daily with single pipeline.
NOTE: I have almost 250+ tables in DB that needs to be sync with redshift db (Almost daily). Or suggest any other better way for that purpose.
Asked by Muhammad Hashir Anwaar
(121 rep)
Nov 21, 2019, 05:21 AM
Last activity: Jan 6, 2020, 11:25 AM
Last activity: Jan 6, 2020, 11:25 AM