turbot/steampipe-mod-aws-compliance

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 login
powerpipe 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_id
from
aws_redshift_cluster;

Tags