Control: Redshift cluster audit logging and encryption should be enabled

Description

To protect data at rest, ensure that encryption is enabled for your Amazon Redshift clusters. You must also ensure that required configurations are deployed on Amazon Redshift clusters. The audit logging should be enabled to provide information about connections and user activities in the database.

Usage

Run the control in your terminal:

powerpipe control run terraform_aws_compliance.control.redshift_cluster_encryption_logging_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

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

Control: Redshift cluster audit logging and encryption should be enabled

Description

Usage

SQL

Tags