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:
- Open the Amazon Redshift console.
- In the navigation pane, choose Clusters, and then choose Snapshots. All snapshots are visible under the Snapshots tab.
- To create a snapshot schedule, choose the Snapshot schedules tab.
- Choose Add snapshot schedule.
- Enter a Schedule name and Description - optional of your snapshot schedule.
- 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.
- 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.
- Choose Add snapshot schedule.
- 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:
- Open the Amazon Redshift console.
- In the navigation pane, choose Clusters, and then choose Snapshots.
- To view scheduled snapshots, choose the Snapshot schedule tab.
- Select the snapshot schedule that you want to delete.
- In the column Attached clusters, choose the column value. You are prompted to detach the cluster.
- Select the clusters associated with the snapshot, and then choose Remove. After the snapshot is removed, choose OK.
- 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