steampipe plugin install aws

Table: aws_region - Query AWS Region using SQL

The AWS Region is a geographical area that represents a physical location around the world where AWS clusters data centers. Each AWS Region is designed to be completely isolated from the other AWS Regions, which aids in achieving the greatest possible fault tolerance and stability. This isolation ensures that user data is not replicated between AWS Regions unless explicitly done so by the user.

Table Usage Guide

The aws_region table in Steampipe provides you with information about regions within AWS. This table allows you, as a DevOps engineer, to query region-specific details, including the region name, description, and status. You can utilize this table to gather insights on regions, such as their geographical distribution, operational status, and more. The schema outlines the various attributes of the AWS region for you, including the region name, endpoint, and whether the region is opt-in status.

Examples

AWS region info

Determine the areas in which your AWS services are deployed and their opt-in statuses. This can help you manage your resources more effectively, particularly for services that require manual opt-in.

select
name,
opt_in_status
from
aws_region;
select
name,
opt_in_status
from
aws_region;

List of AWS regions which are enable

Discover the segments that are not currently active in your AWS regions. This can help you understand which regions are not utilized, potentially highlighting areas for infrastructure optimization or cost savings.

select
name,
opt_in_status
from
aws_region
where
opt_in_status = 'not-opted-in';
select
name,
opt_in_status
from
aws_region
where
opt_in_status = 'not-opted-in';

Control examples

Schema for aws_region

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
nametextThe name of the region
opt_in_statustextThe Region opt-in status. The possible values are opt-in-not-required, opted-in, and not-opted-in
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
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_region