Query: AWS Redshift clusters should have automatic snapshots enabled

Description

This control checks whether AWS Redshift clusters have automated snapshots enabled. It also checks whether the snapshot retention period is greater than or equal to seven.

Query

Tables used in this query:

• aws_redshift_cluster

Controls using this query:

• 3 Amazon Redshift clusters should have automatic snapshots enabled
• 4 Amazon Redshift clusters should have audit logging enabled
• AWS Redshift clusters should have automatic snapshots enabled

SQL