Control: RDS DB cluster activity stream should be encrypted with KMS CMK
Description
This control checks whether Relational Database Service cluster activity stream is encrypted with KMS CMK.
Usage
Run the control in your terminal:
powerpipe control run terraform_aws_compliance.control.rds_cluster_activity_stream_encrypted_with_kms_cmk
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_aws_compliance.control.rds_cluster_activity_stream_encrypted_with_kms_cmk --share
SQL
This control uses a named query:
select address as resource, case when (attributes_std ->> 'kms_key_id') is null then 'alarm' else 'ok' end status, split_part(address, '.', 2) || case when (attributes_std ->> 'kms_key_id') is null then ' not encrypted with KMS CMK' else ' encrypted with KMS CMK' end || '.' as reason , path || ':' || start_linefrom terraform_resourcewhere type = 'aws_rds_cluster_activity_stream';