Scenario
I want to replicate one or more tables from a source database in RedShift.
Requirements
Snaps Used
For this scenario, the following Snaps are used:
- a DB Select Snap, such as MySQL Select
- a Redshift Insert/Bulk Load Snap
Configuration
Replicating a table is done using the Select and Insert/Bulk Load Snaps. The rows are sent out the main output view and then a second output view is used to pass the schema. Here are the steps to follow to build the pipeline:
...