Replication Considerations for Amazon Redshift Targets
Review the following replication considerations for Amazon Redshift targets:
Data Replication connects to and writes source data to the Amazon Simple Storage Service (Amazon S3). Amazon S3 is a storage service that can copy data from a source and simultaneously move the data to Amazon Redshift clusters. After the source data is in Amazon S3 storage, Data Replication issues a copy command that copies the data to an Amazon Redshift target table.
Data Replication does not delete the temporary files that contain the source data from the Amazon S3 bucket if InitialSync or the Applier ends with an error. You can delete these files manually, or use Amazon S3 Object Lifecycle Management to automatically delete the temporary files from the bucket when the lifetime of the temporary files expires.
Data Replication cannot replicate data from source columns that have binary datatypes to Amazon Redshift targets.
Data Replication does not support replication from a single source to multiple Amazon Redshift targets. You cannot define multiple Amazon Redshift targets in a configuration. In the Data Replication Console, the
Routing
tab is unavailable when the target type is Amazon Redshift.