How do I copy an Amazon Redshift cluster to a different AWS account?

Last updated: 2019-11-18

I want to copy an Amazon Redshift cluster from one AWS account to another.

Resolution

Before you begin, consider the following:

  • The new cluster will have a different DNS endpoint. This means that you must update all clients, application codes, and Amazon Kinesis data delivery streams to refer to the new endpoint.
  • Amazon Simple Storage Service (Amazon S3) log settings are not migrated. You must enable database audit logging on the new cluster.
  • Historic information that is stored in STL and SVL tables is not migrated to or retained in the new cluster.

To copy an Amazon Redshift cluster to another AWS account:

  1. Create a manual snapshot of the cluster you want to migrate.
  2. Share the cluster snapshot with another AWS account.
  3. Before you copy a snapshot to another Region, enable cross-Region snapshots.
  4. In the destination AWS account, restore the shared cluster snapshot.