turbot/aws_insights

Query: elasticache_parameter_groups_for_elasticache_cluster_node

Usage

powerpipe query aws_insights.query.elasticache_parameter_groups_for_elasticache_cluster_node

SQL

select
g.arn as elasticache_parameter_group_arn
from
aws_elasticache_cluster as c,
aws_elasticache_parameter_group as g
where
c.cache_parameter_group ->> 'CacheParameterGroupName' = g.cache_parameter_group_name
and c.region = g.region
and c.account_id = g.account_id
and c.arn = $1;