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
  and account_id = split_part($1, ':', 5);