Amazon Redshift backups - Amazon Backup
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Amazon Redshift backups

Amazon Redshift is a fully managed, scalable cloud data warehouse that accelerates your time to insights with fast, easy, and secure analytics. You can use Amazon Backup to protect your data warehouses with immutable backups, separate access policies, and centralized organizational governance of backup and restore jobs.

An Amazon Redshift data warehouse is a collection of computing resources called nodes, which are organized into a group called a cluster. Amazon Backup can backup these clusters.

For information on Amazon Redshift , see the Amazon Redshift Getting Started Guide, the Amazon Redshift Database Developer Guide, and the Amazon Redshift Cluster Management Guide.

Back up Amazon Redshift provisioned clusters

You can protect your Amazon Redshift clusters using the Amazon Backup console or programmatically using API or CLI. These clusters can be backed up on a regular schedule as part of a backup plan, or they can be backed up as needed via on-demand backup.

You can restore a single table (also known as item-level restore) or an entire cluster. Note that tables cannot be backed up by themselves; tables are backed up as part of a cluster when the cluster is backed up.

Using Amazon Backup allows you to view your resources in a centralized way; however, if Amazon Redshift is the only resource you use, you can continue to use the automated snapshot scheduler in Amazon Redshift. Note that you cannot continue to manage manual snapshot settings using Amazon Redshift if you choose to manage these via Amazon Backup.

You can backup Amazon Redshift clusters either through the Amazon Backup console or using the Amazon CLI.

There are two ways to use the Amazon Backup console to backup a Amazon Redshift cluster: on demand or as part of a backup plan.

Create on-demand Amazon Redshift backups

See Creating an on-demand backup type page for more information.

To create a manual snapshot, leave the continuous backup checkbox unchecked when you create a backup plan that includes Amazon Redshift resources.

Create scheduled Amazon Redshift backups in a backup plan

Your scheduled backups can include Amazon Redshift clusters if they are a protected resource. To opt into protecting Amazon Redshift tables:

  1. Open the Amazon Backup console at https://console.amazonaws.cn/backup.

  2. Using the navigation pane, choose Protected resources.

  3. Toggle Amazon Redshift to On.

  4. See Assigning resources to the console to include Amazon Redshift clusters in an existing or new plan.

Under Manage Backup plans, you can choose to create a backup plan and include Amazon Redshift clusters, or you can update an existing one to include Amazon Redshift clusters. When adding the resource type Amazon Redshift, you can choose to add All Amazon Redshift clusters, or check the boxes next to the clusters you

Back up programmatically

You can also define your backup plan in a JSON document and provide it using the Amazon Backup console or Amazon CLI. See Creating backup plans using a JSON document and the Amazon Backup CLI for information on how to create a backup plan programatically.

You can do the following operations using API:

  • Start a backup job

  • Describe a backup job

  • Get recovery point metadata

  • List recovery points by resources

  • List tags for the recovery point

View Amazon Redshift cluster backups

To view and modify your Amazon Redshift table backups within the console:

  1. Open the Amazon Backup console at https://console.amazonaws.cn/backup.

  2. Choose Backup vaults. Then, click on the backup vault name that contains your Amazon Redshift clusters.

  3. The backup vault will display a summary and a list of backups. You can click on the link in the column Recovery point ID.

  4. To delete one or more recovery points, check the box(es) you wish to delete. Under the button Actions, you can select Delete.

Restore a Amazon Redshift cluster

See how to Restore a Amazon Redshift cluster for more information.