steampipe plugin install aws

Table: aws_ec2_instance_availability - Query AWS EC2 Instance Availability using SQL

The AWS EC2 Instance Availability is a feature that allows you to monitor the operational status of your instances in real-time. It provides information about any scheduled events for your instances and any status checks that have failed. This service is crucial for maintaining the reliability, availability, and performance of your AWS resources and applications on AWS.

Table Usage Guide

The aws_ec2_instance_availability table in Steampipe provides you with information about the availability of AWS EC2 instances in each AWS region. This table allows you, as a DevOps engineer, to query instance-specific details, including instance type, product description, and spot price history. You can utilize this table to gather insights on instance availability, such as the types of instances available in a region, the spot price history of an instance type, and more. The schema outlines the various attributes of the EC2 instance availability for you, including the instance type, product description, timestamp of the spot price history, and the spot price itself.

Examples

List of instance types available in us-east-1 region

Explore the range of instance types accessible in a specific geographic region to optimize resource allocation and cost efficiency. This is particularly useful for businesses seeking to manage their cloud-based resources more effectively.

select
instance_type,
location
from
aws_ec2_instance_availability
where
location = 'us-east-1';
select
instance_type,
location
from
aws_ec2_instance_availability
where
location = 'us-east-1';

Check if r5.12xlarge instance type available in af-south-1

Determine the availability of a specific instance type in a particular AWS region. This is useful for planning resource allocation and managing infrastructure costs.

select
instance_type,
location
from
aws_ec2_instance_availability
where
location = 'af-south'
and instance_type = 'r5.12xlarge';
select
instance_type,
location
from
aws_ec2_instance_availability
where
location = 'af-south'
and instance_type = 'r5.12xlarge';

Schema for aws_ec2_instance_availability

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
instance_typetext=The instance type. For more information, see [ Instance Types ](https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/instance-types.html) in the Amazon Elastic Compute Cloud User Guide.
locationtextThe identifier for the location. This depends on the location type. For example, if the location type is region, the location is the Region code (for example, us-east-2.)
location_typetextThe type of location.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_ec2_instance_availability