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';

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