Query: elasticache_cluster_nodes_for_elasticache_cluster

select
  c.arn as elasticache_cluster_node_arn
from
  aws_elasticache_cluster as c,
  aws_elasticache_replication_group as g
where
  c.replication_group_id = g.replication_group_id
  and g.arn = $1
  and g.account_id = split_part($1, ':', 5)
  and g.region = split_part($1, ':', 4);