turbot/aws_insights

Query: vpc_subnets_for_dax_cluster

Usage

powerpipe query aws_insights.query.vpc_subnets_for_dax_cluster

SQL

select
s ->> 'SubnetIdentifier' as subnet_id
from
aws_dax_cluster as c,
aws_dax_subnet_group as g,
jsonb_array_elements(subnets) as s
where
g.subnet_group_name = c.subnet_group
and c.arn = $1;