Query: emr_cluster_instance

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