turbot/aws_insights

Query: dax_cluster_node_details

Usage

powerpipe query aws_insights.query.dax_cluster_node_details

Steampipe Tables

SQL

select
n ->> 'NodeId' as "Node ID",
n ->> 'NodeStatus' as "Node Status",
n ->> 'NodeCreateTime' as "Node Create Time",
n ->> 'AvailabilityZone' as "Availability Zone",
n ->> 'ParameterGroupStatus' as "Parameter Group Status"
from
aws_dax_cluster,
jsonb_array_elements(nodes) as n
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: