Control: An RDS event notifications subscription should be configured for critical cluster events
Description
This control checks whether an AWS RDS event subscription exists that has notifications enabled for the following source type, event category key-value pairs.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.rds_db_cluster_events_subscription
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.rds_db_cluster_events_subscription --share
SQL
This control uses a named query:
select arn as resource, case when source_type <> 'db-cluster' then 'skip' when source_type = 'db-cluster' and enabled and event_categories_list @> '["failure", "maintenance"]' then 'ok' else 'alarm' end as status, case when source_type <> 'db-cluster' then cust_subscription_id || ' event subscription of ' || source_type || ' type.' when source_type = 'db-cluster' and enabled and event_categories_list @> '["failure", "maintenance"]' then cust_subscription_id || ' event subscription enabled for critical db cluster events.' else cust_subscription_id || ' event subscription missing critical db cluster events.' end as reason , region, account_idfrom aws_rds_db_event_subscription;