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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
name	text		The name of the region
opt_in_status	text		The Region opt-in status. The possible values are opt-in-not-required, opted-in, and not-opted-in
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text		The AWS Region in which the resource is located.
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_region