Query: elasticache_node_groups_for_elasticache_cluster

select
  (rg.title || '-' || (ng ->> 'NodeGroupId')) as elasticache_node_group_id
from
  aws_elasticache_replication_group rg,
  jsonb_array_elements(node_groups) ng
where
  rg.arn = $1;