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

2 minute read
0

I want to copy an Amazon Redshift provisioned cluster from one AWS account to another. How can I do that?

Short description

Before you begin, consider the following requirements:

  • New clusters will have a different Domain Name System (DNS) endpoint. This means that you must update all clients, application codes, and Amazon Kinesis Data Firehose delivery streams to refer to the new endpoint.
  • Amazon Simple Storage Service (Amazon S3) log settings aren't migrated. You must activate database audit logging on the new cluster.
  • Historic information that is stored in STL and SVL tables aren't retained in the new cluster.

Resolution

To copy an Amazon Redshift provisioned cluster to another AWS account, follow these steps:

1.    Create a manual snapshot of the cluster that you want to migrate.

2.    Share a cluster snapshot with another AWS account.

3.    In the destination AWS account, restore the cluster from a snapshot.


Related information

Amazon Redshift snapshots

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

Managing snapshots using the AWS CLI and Amazon Redshift API

DNS attributes for your VPC

AWS OFFICIAL
AWS OFFICIALUpdated 2 years ago