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 Amazon DocumentDB clusters. If these findings are not useful,then you can suppress them.

Usage

Run the control in your terminal:

powerpipe control run terraform_aws_compliance.control.rds_db_cluster_deletion_protection_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
  address as resource,
  case
    when (attributes_std -> 'deletion_protection') is null then 'alarm'
    when (attributes_std -> 'deletion_protection')::boolean then 'ok'
    else 'alarm'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std -> 'deletion_protection') is null then ' ''deletion_protection'' disabled'
    when (attributes_std -> 'deletion_protection')::boolean then ' ''deletion_protection'' enabled'
    else ' ''deletion_protection'' disabled'
  end || '.' as reason
  
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'aws_rds_cluster';

Control: RDS clusters should have deletion protection enabled

Description

Usage

SQL

Tags