turbot/aws_insights

Query: account_table

Usage

powerpipe query aws_insights.query.account_table

Steampipe Tables

SQL

select
account_id as "Account ID",
account_aliases ->> 0 as "Alias",
organization_id as "Organization ID",
organization_master_account_email as "Organization Master Account Email",
organization_master_account_id as "Organization Master Account ID",
arn as "ARN"
from
aws_account;

Dashboards

The query is used in the dashboards: