Query: vpc_vpcs_for_elasticache_cluster_node

select
  vpc_id as vpc_vpc_id
from
  aws_vpc
where
  vpc_id in
  (
    select
      vpc_id
    from
      aws_elasticache_cluster as c,
      aws_elasticache_subnet_group as g
    where
      g.cache_subnet_group_name = c.cache_subnet_group_name
      and g.region = c.region
      and c.arn = $1
      and c.account_id = split_part($1, ':', 5)
  );