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