DBI_RS_Parallel_Copy

Overview

This process provides for replicating data between tables and clusters using the Redshift high performance parallel unload the copy commands.  The data is always stored on AWS S3, and can be used to maintain data backups on AWS S3 likewise.

  • Utilizes the Redshift Copy and Unload command
  • Leverages native parallel processing for fast execution
  • Can be executed with a batch of tables, or via command line option
  • Can configure for copy only, or unload only.
  • Can replicate table data between clusters, or to a different schema on the same cluster
  • Can be used for the deep copy of tables where vacuuming is not an option, or expensive to execute
  • Can be used to redefine the column compression for a table

Log Example

Advertisements