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

Short description

Prerequisites:

• New clusters must have a different DNS endpoint. Update all clients, application codes, and Amazon Data Firehose delivery streams to refer to the new endpoint.
• Don't migrate Amazon Simple Storage Service (Amazon S3) log settings. You must activate database audit logging on the new cluster.

Note: Amazon Redshift doesn't retain historic data in the new cluster that you store in STL and SVL tables.

Resolution

To copy an Amazon Redshift provisioned cluster to another account, complete the following steps:

1. Create a manual snapshot of the cluster that you want to migrate.
2. Share the cluster snapshot with the other account.
3. In the destination account, restore the cluster from the snapshot.

Related information

Amazon Redshift snapshots and backups

How do I move my Amazon Redshift provisioned cluster from one VPC to another VPC?

DNS attributes for your VPC