Table: aws_account

An AWS account is a container for your AWS resources. You create and manage your AWS resources in an AWS account, and the AWS account provides administrative capabilities for access and billing.

Examples

Basic AWS account info

select
  alias,
  arn,
  organization_id,
  organization_master_account_email,
  organization_master_account_id
from
  aws_account
  cross join jsonb_array_elements(account_aliases) as alias;

Organization policy of aws account

select
  organization_id,
  policy ->> 'Type' as policy_type,
  policy ->> 'Status' as policy_status
from
  aws_account
  cross join jsonb_array_elements(organization_available_policy_types) as policy;

Query examples

.inspect aws_account

AWS Account

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_aliases	jsonb	A list of aliases associated with the account, if applicable.
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.
arn	text	The Amazon Resource Name (ARN) specifying the account.
organization_arn	text	The Amazon Resource Name (ARN) of an organization.
organization_available_policy_types	jsonb	The Region opt-in status. The possible values are opt-in-not-required, opted-in, and not-opted-in
organization_feature_set	text	Specifies the functionality that currently is available to the organization. If set to "ALL", then all features are enabled and policies can be applied to accounts in the organization. If set to "CONSOLIDATED_BILLING", then only consolidated billing functionality is available.
organization_id	text	The unique identifier (ID) of an organization, if applicable.
organization_master_account_arn	text	The Amazon Resource Name (ARN) of the account that is designated as the management account for the organization
organization_master_account_email	text	The email address that is associated with the AWS account that is designated as the management account for the organization
organization_master_account_id	text	The unique identifier (ID) of the management account of an organization
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.
title	text	Title of the resource.

turbot/aws

Table: aws_account

Examples

Basic AWS account info

Organization policy of aws account

Query examples

.inspect aws_account

Steampipe

Resources

Community