Control: DMS replication instances should not be publicly accessible
Description
Manage access to the AWS Cloud by ensuring DMS replication instances cannot be publicly accessed.
Usage
Run the control in your terminal:
powerpipe control run terraform_aws_compliance.control.dms_replication_instance_not_publicly_accessible
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_aws_compliance.control.dms_replication_instance_not_publicly_accessible --share
SQL
This control uses a named query:
select address as resource, case when (attributes_std -> 'publicly_accessible') is null then 'ok' when (attributes_std -> 'publicly_accessible')::bool then 'alarm' else 'ok' end status, split_part(address, '.', 2) || case when (attributes_std -> 'publicly_accessible') is null then ' not publicly accessible' when (attributes_std -> 'publicly_accessible')::bool then ' publicly accessible' else ' not publicly accessible' end || '.' reason , path || ':' || start_linefrom terraform_resourcewhere type = 'aws_dms_replication_instance';