Query: opensearch_domain_security_groups

select
  GroupID AS "Group ID"
from (
  select jsonb_array_elements_text(vpc_options -> 'SecurityGroupIds') AS GroupID
  from aws_opensearch_domain
  where arn = $1
  and account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4)
) AS subquery;