How can I reduce the frequency of automated snapshots in Amazon Redshift?
I want to reduce the frequency of my automated snapshots in Amazon Redshift. How can I do this?
"I want to reduce the frequency of my automated snapshots in Amazon Redshift. How can I do this?ResolutionAmazon Redshift cluster snapshots can be scheduled to reduce the frequency of automated snapshots. You can create a snapshot schedule to control the time and frequency of when automated snapshots are taken.Automated snapshots are activated by default when you create a cluster in Amazon Redshift. 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.Schedule automated snapshots using the consoleTo schedule automated snapshots for a particular time interval, follow these steps:Open the Amazon Redshift console.In the navigation pane, choose Clusters, and then choose Snapshots. All snapshots will be visible under the Snapshots tab.Choose the Snapshot schedules tab to create a snapshot schedule.Choose Add snapshot schedule.Enter a Schedule name and Description - optional of your snapshot schedule.Choose Configure automated snapshot rules to create schedules for an automated snapshot. To create a rule, use the Editor or Cron syntax.Note: For more information on scheduling your snapshot using cron syntax, see Snapshot schedule format.Using the Editor, 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 then for Time (UTC), enter a time in UTC. Then, for On days, choose the frequency of snapshots. You can create multiple snapshot creations by choosing Add another rule or Add rule from template.Note: Snapshot frequencies less than one hour or greater than 24 hours aren't supported.When you have completed the schedule, 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 schedule automated snapshots using the AWS CLI, see create-snapshot-schedule.Delete scheduled snapshots using the consoleNote: Before deleting the snapshot schedule, you must detach the Amazon Redshift clusters associated with the snapshot schedule.To detach clusters and delete a snapshot schedule, do the following:Open the Amazon Redshift console.In the navigation pane, choose Clusters, and then choose Snapshots.Choose the Snapshot schedule tab to view scheduled snapshots.Select the snapshot schedule that you want to delete.In the column Attached clusters, choose the column value and you will be prompted to detach the cluster.Select the clusters associated with the snapshot, and then choose Remove. When the snapshot is removed, choose OK.For Actions, choose Delete schedule. Confirm the deletion of the snapshots, and then choose OK.To delete a snapshot using the AWS CLI, see delete-snapshot-schedule.Related informationManaging snapshots using the consoleAmazon Redshift snapshotsFollow"