How can I reduce the frequency of automated snapshots in Amazon Redshift?

3 minute read
1

I want to reduce the frequency of my automated snapshots in Amazon Redshift.

Resolution

You can schedule Amazon Redshift cluster snapshots to reduce the frequency of automated snapshots. To control the time and frequency of automated snapshots, create a snapshot schedule.

When you create a cluster in Amazon Redshift, automated snapshots are activated by default. When automated snapshots are activated for a cluster, Amazon Redshift periodically takes snapshots of that cluster. By default, Amazon Redshift takes a snapshot about every eight hours or following every 5 GB per node of data changes, or whichever comes first.

Note: If a cluster doesn't have an attached snapshot schedule, then the cluster uses the default automated snapshot schedule.

Use the console to schedule automated snapshots

To schedule automated snapshots for a particular time interval, complete the following steps:

  1. Open the Amazon Redshift console.
  2. In the navigation pane, choose Clusters, and then choose Snapshots. All snapshots are visible under the Snapshots tab.
  3. To create a snapshot schedule, choose the Snapshot schedules tab.
  4. Choose Add snapshot schedule.
  5. Enter a Schedule name and Description - optional of your snapshot schedule.
  6. To create schedules for an automated snapshot, choose Configure automated snapshot rules. Then, to create a rule, use the Editor or Cron syntax.
    Note: For more information on how to use cron syntax to schedule your snapshot, see Snapshot schedule format.
  7. Use the Editor to define the snapshot creation as recurring or at a particular time:
    To create a recurring snapshot, for Create snapshot, choose Recurring, and for Every X hours, choose the hours of recurrence. Then, for On days, choose the frequency of snapshots.
    To schedule snapshots at a particular time of the day or week, for Create snapshot, choose Recurring, and for Time (UTC), enter a UTC time. Then, for On days, choose the frequency of snapshots. To create multiple snapshot creations, choose Add another rule or Add rule from template.
    Note: Snapshot frequencies less than one hour or greater than 24 hours aren't supported.
  8. Choose Add snapshot schedule.
  9. Attach clusters to your new snapshot schedule, then choose OK.
    Note: You can also attach a schedule to multiple clusters.

To use the AWS Command Line Interface (AWS CLI) to schedule automated snapshots, see create-snapshot-schedule.

Note: If you receive errors when you run AWS CLI commands, then see Troubleshoot AWS CLI errors. Also, make sure that you're using the most recent AWS CLI version.

Use the console to delete scheduled snapshots

Note: Before you delete the snapshot schedule, you must detach the Amazon Redshift clusters associated with the snapshot schedule.

To detach clusters and delete a snapshot schedule, complete the following steps:

  1. Open the Amazon Redshift console.
  2. In the navigation pane, choose Clusters, and then choose Snapshots.
  3. To view scheduled snapshots, choose the Snapshot schedule tab.
  4. Select the snapshot schedule that you want to delete.
  5. In the column Attached clusters, choose the column value. You are prompted to detach the cluster.
  6. Select the clusters associated with the snapshot, and then choose Remove. After the snapshot is removed, choose OK.
  7. For Actions, choose Delete schedule. Confirm the deletion of the snapshots, and then choose OK.

To use the AWS CLI to delete a snapshot, see delete-snapshot-schedule.

Related information

Managing snapshots using the console

Amazon Redshift snapshots and backups

AWS OFFICIAL
AWS OFFICIALUpdated 2 months ago
2 Comments

To precisely control when snapshots are taken, you can create a snapshot schedule and attach it to one or more clusters. When you modify a snapshot schedule, the schedule is modified for all associated clusters. If a cluster doesn't have a snapshot schedule attached, the cluster uses the default automated snapshot schedule.

A snapshot schedule is a set of schedule rules. You can define a simple schedule rule based on a specified interval, such as every 8 hours or every 12 hours. You can also add rules to take snapshots on certain days of the week, at specific times, or during specific periods. Rules can also be defined using Unix-like cron expressions.

https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-snapshots.html

replied 5 months ago

Thank you for your comment. We'll review and update the Knowledge Center article as needed.

profile pictureAWS
MODERATOR
replied 5 months ago