turbot/steampipe-mod-aws-compliance

Control: RDS clusters should have deletion protection enabled

Description

This control checks whether RDS clusters have deletion protection enabled. This control is intended for RDS DB instances. However, it can also generate findings for Aurora DB instances, Neptune DB instances, and AWS DocumentDB clusters. If these findings are not useful,then you can suppress them.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.rds_db_cluster_deletion_protection_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
db_cluster_identifier as resource,
case
when deletion_protection then 'ok'
else 'alarm'
end as status,
case
when deletion_protection then title || ' deletion protection enabled.'
else title || ' deletion protection not enabled.'
end as reason
, region, account_id
from
aws_rds_db_cluster;

Tags