How can I migrate my Amazon Redshift data from one cluster to another?

Resolution

You can use data sharing, Amazon Redshift Spectrum, Amazon Simple Storage Service (Amazon S3), or a cluster snapshot to migrate Amazon Redshift data.

Data sharing

You can use data sharing to share live data across Amazon Redshift clusters with AWS accounts or AWS Regions.

Note: Amazon Redshift data sharing is available only on RA3 node types. For RA3 node migrations, see How do I migrate my Amazon Redshift cluster to an RA3 node type?

For AWS accounts, see Sharing data within an AWS account and Sharing data across AWS accounts.

For AWS Regions, see Sharing data across AWS Regions.

For more information, see Sharing data across clusters in Amazon Redshift.

Amazon Redshift Spectrum

You can use Amazon Redshift Spectrum to query external data. You can also use Amazon Redshift Spectrum to share data on multiple clusters. For instructions, see How do I create and query an external table in Amazon Redshift Spectrum?

Amazon S3

You can move data from Amazon Redshift to an Amazon S3 bucket. For instructions, see How do I COPY or UNLOAD data from Amazon Redshift to an Amazon S3 bucket in another account?

Or, you can use the Amazon Redshift Unload/Copy Utility to migrate data between Amazon Redshift clusters or databases to Amazon S3.

Cluster snapshot

You can copy an Amazon Redshift provisioned cluster to another AWS account by creating and sharing a manual snapshot. For instructions, see How do I copy an Amazon Redshift provisioned cluster to a different AWS account?

---

Related information

Getting started data sharing

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

Managing snapshots using the AWS Command Line Interface (AWS CLI) and Amazon Redshift API

How can I copy S3 objects from another AWS account?