Control: Amazon Redshift Serverless workgroups should use enhanced VPC routing

Description

This control checks whether enhanced VPC routing is enabled for an Amazon Redshift Serverless workgroup. The control fails if enhanced VPC routing is disabled for the workgroup.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.redshiftserverless_workgroup_enhanced_vpc_routing_enabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.redshiftserverless_workgroup_enhanced_vpc_routing_enabled --share

SQL

This control uses a named query:

select
  workgroup_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_id
from
  aws_redshiftserverless_workgroup;

Control: Amazon Redshift Serverless workgroups should use enhanced VPC routing

Description

Usage

SQL

Tags