turbot/steampipe-mod-aws-compliance

Control: DynamoDB table should have encryption enabled

Description

Ensure that encryption is enabled for your AWS DynamoDB tables. Because sensitive data can exist at rest in these tables, enable encryption at rest to help protect that data.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.dynamodb_table_encryption_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
arn as resource,
case
when sse_description is not null and sse_description ->> 'SSEType' = 'KMS' then 'ok'
when sse_description is null then 'ok'
else 'alarm'
end as status,
case
when sse_description is not null and sse_description ->> 'SSEType' = 'KMS'
then title || ' encrypted with AWS KMS.'
when sse_description is null then title || ' encrypted with DynamoDB managed CMK.'
else title || ' not encrypted with CMK.'
end as reason
, region, account_id
from
aws_dynamodb_table;

Tags