steampipe plugin install awssteampipe plugin install aws

Table: aws_emr_instance_group

An AWS EMR instance group is a group of instances that have common purpose. With the instance groups configuration, each node type (master, core, or task) consists of the same instance type and the same purchasing option for instances.

Examples

Basic info

select
  id,
  arn,
  cluster_id,
  instance_group_type,
  state
from
  aws_emr_instance_group;

Get the master instance type used for a cluster

select
  ig.id as instance_group_id,
  ig.cluster_id,
  c.name as cluster_name,
  ig.instance_type
from
  aws_emr_instance_group as ig,
  aws_emr_cluster as c
where
  ig.cluster_id = c.id
  and ig.instance_group_type = 'MASTER';

Get the count of running instances (core and master) per cluster

select
  cluster_id,
  sum(running_instance_count) as running_instance_count
from
  aws_emr_instance_group
where
  state = 'RUNNING'
group by
  cluster_id;

Control examples

emr_cluster_instance_prev_gen

.inspect aws_emr_instance_group

AWS EMR Instance Group

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Amazon Resource Name (ARN) specifying the instance group.
autoscaling_policy	jsonb	An automatic scaling policy for a core instance group or task instance group in an Amazon EMR cluster.
bid_price	text	The maximum price you are willing to pay for Spot Instances. If specified, indicates that the instance group uses Spot Instances.
cluster_id	text	The unique identifier for the cluster.
configurations	jsonb	A list of configurations supplied for an EMR cluster instance group. Only availbale for Amazon EMR releases 4.x or later.
configurations_version	bigint	The version number of the requested configuration specification for this instance group.
ebs_block_devices	jsonb	The EBS block devices that are mapped to this instance group.
ebs_optimized	boolean	Indicates whether the instance group is EBS-optimized, or not. An Amazon EBS-optimized instance uses an optimized configuration stack and provides additional, dedicated capacity for Amazon EBS I/O.
id	text	The identifier of the instance group.
instance_group_type	text	The type of the instance group. Valid values are MASTER, CORE or TASK.
instance_type	text	The EC2 instance type for all instances in the instance group.
last_successfully_applied_configurations	jsonb	A list of configurations that were successfully applied for an instance group last time.
last_successfully_applied_configurations_version	bigint	The version number of a configuration specification that was successfully applied for an instance group last time.
market	text	The marketplace to provision instances for this group. Valid values are ON_DEMAND or SPOT.
name	text	The name of the instance group.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
requested_instance_count	bigint	The target number of instances for the instance group.
running_instance_count	bigint	The number of instances currently running in this instance group.
shrink_policy	jsonb	Policy for customizing shrink operations.
state	text	The current state of the instance group.
state_change_reason	jsonb	The status change reason details for the instance group.
status_timeline	jsonb	The timeline of the instance group status over time.
title	text	Title of the resource.

turbot/aws