turbot/aws_insights

Query: elasticache_node_groups_for_elasticache_cluster

Usage

powerpipe query aws_insights.query.elasticache_node_groups_for_elasticache_cluster

SQL

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);