Query: iam_group_direct_attached_policy_count_for_group

select
  case
    when attached_policy_arns is null then 0
    else jsonb_array_length(attached_policy_arns)
  end as value,
  'Attached Policies' as label,
  case
    when (attached_policy_arns is null)
    or (jsonb_array_length(attached_policy_arns) = 0) then 'alert'
    else 'ok'
  end as type
from
  aws_iam_group
where
  arn = $1