Control: Amazon DocumentDB cluster snapshots should not be public

powerpipe control run aws_compliance.control.docdb_cluster_snapshot_restrict_public_access

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

select
  arn as resource,
  case
    when (cluster_snapshot ->> 'AttributeName' = 'restore') and cluster_snapshot -> 'AttributeValues' = '["all"]' then 'alarm'
    else 'ok'
  end status,
  case
    when (cluster_snapshot ->> 'AttributeName' = 'restore') and cluster_snapshot -> 'AttributeValues' = '["all"]' then title || ' does not restrict public access.'
    else title || ' restrict public access.'
  end reason
  
  , region, account_id
from
  aws_docdb_cluster_snapshot,
  jsonb_array_elements(db_cluster_snapshot_attributes) as cluster_snapshot;