Query: emr_cluster_ec2_instance_attributes

select
  ec2_instance_attributes ->> 'Ec2KeyName' as "EC2 Key Name",
  ec2_instance_attributes ->> 'Ec2SubnetId' as "EC2 Subnet Id",
  ec2_instance_attributes ->> 'IamInstanceProfile' as "IAM Instance Profile",
  ec2_instance_attributes ->> 'Ec2AvailabilityZone' as "EC2 Availability Zone",
  ec2_instance_attributes ->> 'ServiceAccessSecurityGroup' as "Service Access Security Group",
  ec2_instance_attributes ->> 'EmrManagedSlaveSecurityGroup' as "EMR Managed Slave Security Group",
  ec2_instance_attributes ->> 'EmrManagedMasterSecurityGroup' as "EMR Managed Master Security Group"
from
  aws_emr_cluster
where
  cluster_arn = $1
  and account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4);