Control: Redshift clusters should not be using EC2 classic mode
Description
Ensure EC2-Classic mode is not used for the deployment of redshift clusters
Usage
Run the control in your terminal:
powerpipe control run terraform_aws_compliance.control.redshift_cluster_deployed_in_ec2_classic_mode
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_aws_compliance.control.redshift_cluster_deployed_in_ec2_classic_mode --share
SQL
This control uses a named query:
select address as resource, case when (attributes_std -> 'cluster_subnet_group_name') is not null then 'ok' else 'alarm' end status, split_part(address, '.', 2) || case when (attributes_std -> 'cluster_subnet_group_name') is not null then ' deployed inside VPC' else ' not deployed inside VPC' end || '.' as reason , path || ':' || start_linefrom terraform_resourcewhere type = 'aws_redshift_cluster';