Control: Neptune snapshot should be encrypted with KMS CMK
Description
This control checks whether Neptune snapshots are encrypted with KMS CMK.
Usage
Run the control in your terminal:
powerpipe control run terraform_aws_compliance.control.neptune_snapshot_encrypted_with_kms_cmk
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_aws_compliance.control.neptune_snapshot_encrypted_with_kms_cmk --share
SQL
This control uses a named query:
select address as resource, case when (attributes_std -> 'kms_key_id') is null then 'alarm' else 'ok' end as status, split_part(address, '.', 2) || case when (attributes_std -> 'kms_key_id') is null then ' not encrypted with KMS CMK' else ' encrypted with KMS CMK' end || '.' as reason , path || ':' || start_linefrom terraform_resourcewhere type = 'aws_neptune_cluster_snapshot';