Control: RDS DB instances should be configured to copy tags to snapshots

Description

This control checks whether RDS DB instances are configured to copy all tags to snapshots when the snapshots are created.

Usage

Run the control in your terminal:

powerpipe control run terraform_aws_compliance.control.rds_db_instance_copy_tags_to_snapshot_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

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

Control: RDS DB instances should be configured to copy tags to snapshots

Description

Usage

SQL

Tags