Query: elasticache_subnet_groups_for_elasticache_cluster_node

select
  g.arn as elasticache_subnet_group_arn
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);