turbot/aws_insights

Query: emr_cluster_instance

Usage

powerpipe query aws_insights.query.emr_cluster_instance

SQL

select
i.id as "ID",
i.ec2_instance_id as "EC2 Instance ID",
i.state as "State",
i.instance_fleet_id as "Instance Fleet ID",
i.instance_group_id as "Instance Group ID",
ec2i.arn as "ARN"
from
aws_emr_instance as i,
aws_emr_cluster as c,
aws_ec2_instance as ec2i
where
i.cluster_id = c.id
and i.ec2_instance_id = ec2i.instance_id
and cluster_arn = $1
and c.account_id = split_part($1, ':', 5)
and c.region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: