Query: opensearch_domain_subnet

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