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:
Open the Amazon Backup console at https://console.amazonaws.cn/backup
. Using the navigation pane, choose Protected resources.
Toggle Amazon Redshift to On.
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:
Open the Amazon Backup console at https://console.amazonaws.cn/backup
. Choose Backup vaults. Then, click on the backup vault name that contains your Amazon Redshift clusters.
The backup vault will display a summary and a list of backups. You can click on the link in the column Recovery point ID.
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.