Query: vpc_subnets_for_elasticache_cluster_node

select
  subnet ->> 'SubnetIdentifier' as vpc_subnet_id
from
  aws_elasticache_cluster as c,
  aws_elasticache_subnet_group as g,
  jsonb_array_elements(subnets) as subnet
where
  g.cache_subnet_group_name = c.cache_subnet_group_name
  and g.region = c.region
  and c.arn = $1