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 loginpowerpipe 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_idfrom aws_dynamodb_table;