instances

Creates, updates, deletes, gets or lists an instances resource.

Overview

Name	instances
Type	Resource
Id	aws.emr.instances

Fields

The following fields are returned by SELECT queries:

list_instances

Name	Datatype	Description
ebs_volumes	array	The list of Amazon EBS volumes that are attached to this instance.
ec_2_instance_id	string	The unique identifier of the instance in Amazon EC2.
id	string	The unique identifier for the instance in Amazon EMR.
instance_fleet_id	string	The unique identifier of the instance fleet to which an Amazon EC2 instance belongs.
instance_group_id	string	The identifier of the instance group to which this instance belongs.
instance_type	string	The Amazon EC2 instance type, for example m3.xlarge. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\r\n\t]*</code>)
market	string	The instance purchasing option. Valid values are ON_DEMAND or SPOT. (ON_DEMAND, SPOT)
private_dns_name	string	The private DNS name of the instance.
private_ip_address	string	The private IP address of the instance.
public_dns_name	string	The public DNS name of the instance.
public_ip_address	string	The public IP address of the instance.
status	object	The current status of the instance.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_instances	select	region		Provides information for all active Amazon EC2 instances and Amazon EC2 instances terminated in the last 30 days, up to a maximum of 2,000. Amazon EC2 instances in any of the following states are considered active: AWAITING_FULFILLMENT, PROVISIONING, BOOTSTRAPPING, RUNNING.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

list_instances

Provides information for all active Amazon EC2 instances and Amazon EC2 instances terminated in the last 30 days, up to a maximum of 2,000. Amazon EC2 instances in any of the following states are considered active: AWAITING_FULFILLMENT, PROVISIONING, BOOTSTRAPPING, RUNNING.

SELECT
ebs_volumes,
ec_2_instance_id,
id,
instance_fleet_id,
instance_group_id,
instance_type,
market,
private_dns_name,
private_ip_address,
public_dns_name,
public_ip_address,
status
FROM aws.emr.instances
WHERE region = '{{ region }}' -- required
;