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 AWS DynamoDB.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.dynamodb_table_point_in_time_recovery_enabled
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.dynamodb_table_point_in_time_recovery_enabled --share
SQL
This control uses a named query:
select arn as resource, case when lower( point_in_time_recovery_description ->> 'PointInTimeRecoveryStatus' ) = 'disabled' then 'alarm' else 'ok' end as status, case when lower( point_in_time_recovery_description ->> 'PointInTimeRecoveryStatus' ) = 'disabled' then title || ' point-in-time recovery not enabled.' else title || ' point-in-time recovery enabled.' end as reason , region, account_idfrom aws_dynamodb_table;