Query: vpc_vpcs_for_dax_cluster

with cluster_subnet_group as (
  select
    subnet_group
  from
    aws_dax_cluster
  where
    arn = $1
    and account_id = split_part($1, ':', 5)
    and region = split_part($1, ':', 4)
)
select
  g.vpc_id as vpc_id
from
  aws_dax_subnet_group g
join
  cluster_subnet_group csg on g.subnet_group_name = csg.subnet_group
where
  g.account_id = split_part($1, ':', 5)
  and g.region = split_part($1, ':', 4);