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
  and rg.account_id = split_part($1, ':', 5)
  and rg.region = split_part($1, ':', 4);