Control: DynamoDB table point-in-time recovery should be enabled

Description

Enable this rule to check that information has been backed up. It also maintains the backups by ensuring that point-in-time recovery is enabled in Amazon DynamoDB.

Usage

Run the control in your terminal:

powerpipe control run terraform_aws_compliance.control.dynamodb_table_point_in_time_recovery_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

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

Control: DynamoDB table point-in-time recovery should be enabled

Description

Usage

SQL

Tags