Control: AWS Redshift should have automatic upgrades to major versions enabled
Description
This control checks whether automatic major version upgrades are enabled for the AWS Redshift cluster.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.redshift_cluster_automatic_upgrade_major_versions_enabled
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.redshift_cluster_automatic_upgrade_major_versions_enabled --share
SQL
This control uses a named query:
select arn as resource, case when allow_version_upgrade then 'ok' else 'alarm' end as status, case when allow_version_upgrade then title || ' automatic upgrades to major versions enabled.' else title || ' automatic upgrades to major versions disabled.' end as reason , region, account_idfrom aws_redshift_cluster;