turbot/steampipe-mod-aws-compliance

Control: SQS queues should be encrypted with KMS CMK

Description

To help protect sensitive data at rest, ensure encryption is enabled for your AWS SQS queues with KMS CMK.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.sqs_queue_encrypted_with_kms_cmk

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
queue_arn as resource,
case
when kms_master_key_id is null then 'alarm'
when kms_master_key_id is not null and kms_master_key_id = 'alias/aws/sqs' then 'alarm'
else 'ok'
end as status,
case
when kms_master_key_id is null then title || ' encryption at rest disabled.'
when kms_master_key_id is not null and kms_master_key_id = 'alias/aws/sqs' then title || ' not encrypted with CMK.'
else title || ' encrypted with CMK.'
end as reason
, region, account_id
from
aws_sqs_queue;

Tags