Amazon Redshift
Cluster Management Guide

Managing Snapshots Using the Console

Amazon Redshift takes automatic, incremental snapshots of your data periodically and saves them to Amazon S3. Additionally, you can take manual snapshots of your data whenever you want. In this section, you can find how to manage your snapshots from the Amazon Redshift console. For more information about snapshots, see Amazon Redshift Snapshots.

All snapshot tasks in the Amazon Redshift console start from the snapshot list. You can filter the list by using a time range, the snapshot type, and the cluster associated with the snapshot. In addition, you can sort the list by date, size, and snapshot type. Depending on the snapshot type that you select, you might have different options available for working with the snapshot.

Creating a Snapshot Schedule

To precisely control when snapshots are taken, you can create a snapshot schedule and attach it to one or more clusters. You can attach a schedule when you create a cluster or by modifying the cluster. For more information, see Automated Snapshot Schedules.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To create a snapshot schedule

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, Snapshots, then choose the Snapshot schedules tab. The snapshot schedules are displayed.

  3. Choose Add schedule to display the page to add a schedule.

  4. Enter the properties of the schedule definition, then choose Add schedule.

  5. On the page that appears, you can attach clusters to your new snapshot schedule, then choose OK.

Original Console

To create a snapshot schedule

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Snapshots.

  3. Choose Snapshot Schedules.

  4. Choose Add Schedule.

  5. Under When do you want to take automated snapshots? choose Configure custom automated snapshot rules and then add one or more rules. Or choose Take a snapshot every 8 hours and specify the number of hours.

  6. Choose Select a snapshot rule to add and choose a rule template from the list. You can add multiple rules.

  7. Modify the template fields to customize your schedule.

  8. To view the schedule, choose Preview schedule for all rules.

  9. Choose Add Schedule.

Creating a Manual Snapshot

You can create a manual snapshot of a cluster from the snapshots list as follows. Or, you can take a snapshot of a cluster in the cluster configuration pane. For more information, see Creating a Snapshot of a Cluster.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To create a manual snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, Snapshots, then choose Create snapshot. The snapshot page to create a manual snapshot is displayed.

  3. Enter the properties of the snapshot definition, then choose Create snapshot. It might take some time for the snapshot to be available.

Original Console

To create a manual snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Snapshots.

  3. Choose Create Snapshot.

  4. In the Create Snapshot dialog box, do the following:

    1. In the Cluster identifier box, choose the cluster that you want to take a snapshot of.

    2. In the Snapshot identifier box, type a name for the snapshot.

    3. For Snapshot retention period, enter the number of days to retain the snapshot. To retain the snapshot indefinitely, enter -1.

  5. Choose Create.

    The snapshot might take some time to complete. The new snapshot appears in the list of snapshots with its current status. The example following shows that snapshot-example is in the process of being created.

Changing the Manual Snapshot Retention Period

You can change the retention period for a manual snapshot by modifying the snapshot settings.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To change the manual snapshot retention period

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, Snapshots, then choose the manual snapshot to change.

  3. For Actions, choose Manual snapshot settings to display the properties of the manual snapshot.

  4. Enter the revised properties of the snapshot definition, then choose Save.

Original Console

To change the manual snapshot retention period

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Snapshots.

  3. To filter the list in order to find the snapshot that you want to copy, do any or all of the following:

    • In the Time Range box, choose a time range that will narrow your search appropriately.

    • In the Type box, choose manual.

    • In the Cluster box, choose a cluster name to list snapshots for a single cluster, or choose All Clusters to list snapshots from all clusters.

    • In the Sort by field, choose how you want the list ordered.

  4. In the snapshot list, select the snapshot that you want to modify.

  5. Choose Manual Snapshot Settings.

  6. For Snapshot retention period, enter the number of days to retain the snapshot. To retain the snapshot indefinitely, enter -1.

  7. Choose Save.

Deleting Manual Snapshots

You can delete manual snapshots by selecting one or more snapshots in the snapshot list.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To delete a manual snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, Snapshots, then choose the snapshot to delete.

  3. For Actions, choose Delete snapshot to delete the snapshot.

  4. Confirm the deletion of the listed snapshots, then choose Delete.

Original Console

To delete a manual snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Snapshots.

  3. To filter the list, do any or all of the following:

    • In the Time Range box, choose a time range that will narrow your search appropriately.

    • In the Type box, choose manual.

    • In the Cluster box, choose a cluster name to list snapshots for a single cluster, or choose All Clusters to list snapshots from all clusters.

    • In the Sort by field, choose how you want the list ordered.

  4. In the snapshot list, select the rows that contain the snapshots that you want to delete.

  5. Choose Delete Manual Snapshot.

  6. In the Delete Manual Snapshot dialog box, choose Continue.

Copying an Automated Snapshot

Automated snapshots are automatically deleted when their retention period expires, when you disable automated snapshots, or when you delete a cluster. If you want to keep an automated snapshot, you can copy it to a manual snapshot.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To copy an automated snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, Snapshots, then choose the snapshot to copy.

  3. For Actions, choose Copy automated snapshot to copy the snapshot.

  4. Update the properties of the new snapshot, then choose Copy.

Original Console

To copy an automated snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Snapshots.

  3. To filter the list, do any or all of the following:

    • In the Time Range box, choose a time range that will narrow your search appropriately.

    • In the Type box, choose automated.

    • In the Cluster box, choose a cluster name to list snapshots for a single cluster, or choose All Clusters to list snapshots from all clusters.

    • In the Sort by field, choose how you want the list ordered.

  4. In the snapshot list, select the snapshot that you want to copy.

  5. Choose Copy Automated Snapshot.

  6. In the Snapshot Identifier box of the Copy Automated Snapshot dialog box, enter a name for the snapshot copy.

  7. For Snapshot retention period, enter the number of days to retain the snapshot. To retain the snapshot indefinitely, enter -1.

  8. Choose Continue.

Restoring a Cluster from a Snapshot

When you restore a cluster from a snapshot, Amazon Redshift creates a new cluster with all the snapshot data on the new cluster.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To restore a cluster from a snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, Snapshots, then choose the snapshot to restore.

  3. Choose Restore from snapshot to view the Cluster configuration and Cluster details values of the new cluster to be created using the snapshot information.

  4. Update the properties of the new cluster, then choose Restore cluster from snapshot.

Original Console

Note

You can use these steps to change a cluster platform from EC2-Classic to EC2-VPC and vice versa.

To restore a cluster from a snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Snapshots.

  3. To filter the list, do any or all of the following:

    • In the Time Range box, choose a time range that will narrow your search appropriately.

    • In the Type box, choose manual or automated.

    • In the Cluster box, choose a cluster name to list snapshots for a single cluster, or choose All Clusters to list snapshots from all clusters.

    • In the Sort by field, choose how you want the list ordered.

  4. In the snapshot list, choose the row that contains the snapshot that you want to use.

  5. Choose Restore From Snapshot.

  6. In the Restore Cluster from Snapshot dialog box, do the following:

    1. In the Cluster Identifier box, type a cluster identifier for the restored cluster.

      Cluster identifiers must meet the following conditions:

      • They must contain from 1 to 255 alphanumeric characters or hyphens.

      • Alphabetic characters must be lowercase.

      • The first character must be a letter.

      • They cannot end with a hyphen or contain two consecutive hyphens.

      • They must be unique for all clusters within an AWS account.

    2. In the Port box, accept the port from the snapshot or change the value as appropriate.

    3. Select Allow Version Upgrade as appropriate.

    4. In Cluster Subnet Group, select the subnet group into which you want to restore the cluster.

      This option only appears if you restore the cluster into the EC2-VPC platform.

    5. For Publicly Accessible, select Yes if you want the cluster to have a public IP address that can be accessed over a public connection to the Internet. Select No if you want the cluster to have a private IP address that can only be accessed from within the VPC. If your AWS account allows you to create EC2-Classic clusters, the default is No. Otherwise, the default is Yes.

      This option only appears if you restore the cluster into the EC2-VPC platform.

    6. In Choose a Public IP Address, select Yes if you want to select an elastic IP (EIP) address that you already have configured. Otherwise, select No to have Amazon Redshift create an EIP for your instance.

      This option only appears if you restore the cluster into the EC2-VPC platform.

    7. In Elastic IP, select an EIP to use to connect to the cluster from outside of the VPC.

      This option only appears if you restore the cluster into the EC2-VPC platform and you select Yes in Choose a Public IP Address.

    8. In the Availability Zone box, accept the Availability Zone from the snapshot or change the value as appropriate.

    9. In Cluster Parameter Group, select a parameter group to associate with the cluster.

    10. In Cluster Security Groups or VPC Security Groups, select a security group to associate with the cluster. The types of security group that appear here depend on whether you're restoring the cluster into the EC2-VPC or EC2-Classic platform.

      The option to select a cluster security group or a VPC security group depends on whether you restore the cluster into the EC2-VPC platform or the EC2-Classic platform.

    11. In Maintenance track, the value of the maintenance track is displayed. In Change maintenance track to, optionally choose to restore the cluster using one of the maintenance tracks listed.

    The following is an example of restoring a snapshot into a cluster that uses the EC2-VPC platform.

    The following is an example of restoring a snapshot into a cluster that uses the EC2-Classic platform.

  7. Choose Restore.

Sharing a Cluster Snapshot

You can authorize other users to access a manual snapshot you own, and you can later revoke that access when it is no longer required.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To share a snapshot with another account

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, Snapshots, then choose the manual snapshot to share.

  3. For Actions, choose Manual snapshot settings to display the properties of the manual snapshot.

  4. Enter the account or accounts to share with in the Manage access section, then choose Save.

Original Console

To share a cluster snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Snapshots.

  3. If you need to filter the list in order to find the snapshot that you want to share, do any or all of the following:

    • In the Time Range box, choose a time range that will narrow your search appropriately.

    • In the Cluster box, choose the cluster whose snapshot you want to share.

  4. In the snapshot list, choose the row that contains the snapshot that you want to use.

  5. Choose Manage Access.

  6. In the Manage Snapshot Access dialog box, you can either authorize a user to access the snapshot or revoke a previously authorized access.

    • To authorize a user to access the snapshot, type that user's 12-digit AWS account ID in the box (omit the dashes), and then choose Add Account.

    • To revoke the authorization for a user, choose X beside that user's AWS account ID.

  7. Choose Save to save your changes, or Cancel to roll back the changes.

Configuring Cross-Region Snapshot Copy for a Non-Encrypted Cluster

You can configure Amazon Redshift to copy snapshots for a cluster to another AWS Region. To configure cross-region snapshot copy, you need to enable this copy feature for each cluster and configure where to copy snapshots and how long to keep copied automated snapshots in the destination AWS Region. When cross-region copy is enabled for a cluster, all new manual and automated snapshots are copied to the specified AWS Region. Copied snapshot names are prefixed with copy:.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To configure a cross-region snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, then choose the cluster that you want to move snapshots for.

  3. For Actions, choose Configure cross-region snapshot to display the configuration page.

  4. Enter the properties of the new configuration, then Save.

Original Console

To configure cross-region snapshot copy for a non-encrypted cluster

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Clusters.

  3. Choose Backup, and then choose Configure Cross-Region Snapshots.

  4. In the Configure Cross-Region Snapshots dialog box, for Copy Snapshots choose Yes.

  5. In Destination Region, choose the AWS Region to which to copy snapshots.

  6. In Retention Period (days), choose the number of days for which you want automated snapshots to be retained in the destination AWS Region before they are deleted.

  7. Choose Save.

Configure Cross-Region Snapshot Copy for an AWS KMS–Encrypted Cluster

When you launch an Amazon Redshift cluster, you can choose to encrypt it with a master key from the AWS Key Management Service (AWS KMS). AWS KMS keys are specific to an AWS Region. If you want to enable cross-region snapshot copy for an AWS KMS–encrypted cluster, you must configure a snapshot copy grant for a master key in the destination AWS Region. By doing this, you enable Amazon Redshift to perform encryption operations in the destination AWS Region.

The following procedure describes the process of enabling cross-region snapshot copy for an AWS KMS-encrypted cluster. For more information about encryption in Amazon Redshift and snapshot copy grants, see Copying AWS KMS-Encrypted Snapshots to Another AWS Region.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To configure a cross-region snapshot for an AWS KMS–encrypted cluster

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, then choose the cluster that you want to move snapshots for.

  3. For Actions, choose Configure cross-region snapshot to display the configuration page.

  4. Enter the properties of the new configuration, then Save.

Original Console

To configure cross-region snapshot copy for an AWS KMS-encrypted cluster

  1. Open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Clusters.

  3. In the cluster list, choose a cluster name to open the Configuration view for the cluster.

  4. Choose Backup, and then choose Configure Cross-Region Snapshots.

  5. In the Configure Cross-Region Snapshots dialog box, for Copy Snapshots choose Yes.

  6. In Destination Region, choose the AWS Region to which to copy snapshots.

  7. In Retention Period (days), choose the number of days for which you want automated snapshots to be retained in the destination AWS Region before they are deleted.

  8. For Existing Snapshot Copy Grant, do one of the following:

    1. Choose No to create a new snapshot copy grant. For KMS Key, choose the AWS KMS key for which to create the grant, and then type a name in Snapshot Copy Grant Name.

    2. Choose Yes to choose an existing snapshot copy grant from the destination AWS Region. Then choose a grant from Snapshot Copy Grant.

  9. Choose Save.

Modifying the Retention Period for Cross-Region Snapshot Copy

After you configure cross-region snapshot copy, you might want to change the settings. You can easily change the retention period by selecting a new number of days and saving the changes.

Warning

You can't modify the destination AWS Region after cross-region snapshot copy is configured.

If you want to copy snapshots to a different AWS Region, first disable cross-region snapshot copy. Then re-enable it with a new destination AWS Region and retention period. Any copied automated snapshots are deleted after you disable cross-region snapshot copy. Thus, you should determine if there are any that you want to keep and copy them to manual snapshots before disabling cross-region snapshot copy.

Note

A new console is available for Amazon Redshift. Choose either the New Console or the Original Console instructions based on the console that you are using. The New Console instructions are open by default.

New Console

To modify a cross-region snapshot

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, then choose the cluster that you want to modify snapshots for.

  3. Choose Backup tab, then choose Edit to edit the properties of the backup.

  4. Enter the properties of the cluster, then choose Modify cluster.

Original Console

To modify the retention period for snapshots copied to a destination cluster

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Clusters.

  3. Choose Backup, and then choose Configure Cross Region Snapshots.

  4. In the Retention Period box, select the new number of days that you want automated snapshots to be retained in the destination AWS Region.

    If you select a smaller number of days to retain snapshots in the destination AWS Region, any automated snapshots that were taken before the new retention period are deleted. If you select a larger number of days to retain snapshots in the destination AWS Region, the retention period for existing automated snapshots is extended. It lengthens by the difference between the old value and the new value.

  5. Choose Save Configuration.