Control: AWS Redshift enhanced VPC routing should be enabled
Description
Ensure that AWS Redshift cluster has 'enhancedVpcRouting' enabled. The rule is non-compliant if 'enhancedVpcRouting' is not enabled or if the configuration.enhancedVpcRouting field is 'false'.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.redshift_cluster_enhanced_vpc_routing_enabled
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.redshift_cluster_enhanced_vpc_routing_enabled --share
SQL
This control uses a named query:
select arn as resource, case when enhanced_vpc_routing then 'ok' else 'alarm' end as status, case when enhanced_vpc_routing then title || ' enhanced VPC routing enabled.' else title || ' enhanced VPC routing disabled.' end as reason , region, account_idfrom aws_redshift_cluster;