turbot/steampipe-mod-aws-compliance

Control: RDS DB instance encryption at rest should be enabled

Description

To help protect data at rest, ensure that encryption is enabled for your AWS Relational Database Service (AWS RDS) instances.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.rds_db_instance_encryption_at_rest_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
arn as resource,
case
when storage_encrypted then 'ok'
else 'alarm'
end as status,
case
when storage_encrypted then title || ' encrypted at rest.'
else title || ' not encrypted at rest.'
end as reason
, region, account_id
from
aws_rds_db_instance;

Tags