Control: RDS snapshots should prohibit public access

powerpipe control run aws_compliance.control.rds_db_snapshot_prohibit_public_access

powerpipe login
powerpipe control run aws_compliance.control.rds_db_snapshot_prohibit_public_access --share

(
select
  arn as resource,
  case
    when cluster_snapshot -> 'AttributeValues' = '["all"]' then 'alarm'
    else 'ok'
  end status,
  case
    when cluster_snapshot -> 'AttributeValues' = '["all"]' then title || ' publicly restorable.'
    else title || ' not publicly restorable.'
  end reason
  
  , region, account_id
from
  aws_rds_db_cluster_snapshot,
  jsonb_array_elements(db_cluster_snapshot_attributes) as cluster_snapshot
)
union
(
select
  arn as resource,
  case
    when database_snapshot -> 'AttributeValues' = '["all"]' then 'alarm'
    else 'ok'
  end status,
  case
    when database_snapshot -> 'AttributeValues' = '["all"]' then title || ' publicly restorable.'
    else title || ' not publicly restorable.'
  end reason
  
  , region, account_id
from
  aws_rds_db_snapshot,
  jsonb_array_elements(db_snapshot_attributes) as database_snapshot
);