Description:
This policy ensures that all Amazon Redshift clusters have automated snapshots enabled. This is important because it helps to protect your data from loss in the event of a disaster.

Rationale:
Redshift automated snapshots are stored in Amazon S3, so they are highly durable and available. In the event of a disaster, you can restore your Redshift clusters from your snapshots.

Impact:
If you do not enable automated snapshots for your Redshift clusters, you could lose your data in the event of a disaster. This could have a significant impact on your business, as you may have to recreate your data from scratch.

Default Value:
AWS will initially recommend that you enable automated snapshots for your Redshift clusters.

Pre-Requisite:

  • You must have access to the AWS Management Console or the AWS CLI.
  • You must know the region where the Redshift clusters are located.


Remediation Steps:

  1. Identify all of the Redshift clusters that do not have automated snapshots enabled.
  2. Enable automated snapshots for the Redshift clusters.

Test Plan:

  1. Verify that the automated snapshots for the Redshift clusters have been enabled.
  2. Check the status of the snapshots to ensure that they are healthy.


Implementation Plan:

  • Use the AWS Management Console to enable automated snapshots for Redshift clusters.
  • Use the AWS CLI to enable automated snapshots for Redshift clusters.


AWS CLI Process:

aws redshift describe-clusters --cluster-names <cluster-name> aws redshift modify-cluster --cluster-name <cluster-name> --automated-snapshot-retention-period <retention-period>


Using AWS GUI:

  1. Go to the AWS Management Console.
  2. Click on the "Redshift" tab.
  3. Select the Redshift clusters that do not have automated snapshots enabled.
  4. Click on the "Actions" menu and select "Modify Cluster".
  5. In the "Automated Snapshot Retention Period" field, enter the desired retention period.
  6. Click on the "Modify" button.


Backout Plan:

  1. Identify the Redshift clusters that you enabled automated snapshots for.
  2. Disable automated snapshots for the Redshift clusters.


Note:

  • The default retention period for automated snapshots is 1 day.
  • You can modify the retention period for automated snapshots at any time.


Reference:

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