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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
instance_type	text	=	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.
location	text		The 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_type	text	=	The type of location.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title 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