Query: vpc_subnet_ids_for_opensearch

select
  jsonb_array_elements_text(vpc_options -> 'SubnetIds') AS subnet_id
from
  aws_opensearch_domain
where
  arn = $1
  and account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4);