turbot/steampipe-mod-aws-insights

Dashboard: AWS DynamoDB Table Encryption Report

This report answers the following questions:

  • Are my tables encrypted at rest?
  • What type of encryption is used?
  • What KMS keys are used for encryption?
This dashboard contains 4 cards and 1 table.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-aws-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select AWS DynamoDB Table Encryption Report dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run aws_insights.dashboard.dynamodb_table_encryption_report --share

Queries

This dashboard uses the the following queries:
select
count(*) as value,
'Encrypted with AWS Managed Key' as label
from
aws_dynamodb_table as t,
aws_kms_key as k
where
k.arn = t.sse_description ->> 'KMSMasterKeyArn'
and sse_description is not null
and sse_description ->> 'SSEType' = 'KMS'
and k.key_manager = 'AWS';

Tags