Skip to content
AWS for Query.Farm

aws.organizations.describe_organization

Example SQL Queries

SELECT * FROM
aws.organizations.describe_organization;

Description

Retrieves information about the organization that the user's account belongs to.

This operation can be called from any account in the organization.

Even if a policy type is shown as available in the organization, you can disable it separately at the root level with DisablePolicyType. Use ListRoots to see the status of policy types for a specified root.

Table Definition

Column NameColumn Data Type
organization

A structure that contains information about the organization.

The AvailablePolicyTypes part of the response is deprecated, and you shouldn't use it in your apps. It doesn't include any policy type supported by Organizations other than SCPs. To determine which policy types are enabled in your organization, use the ListRoots operation.

STRUCT(
    "id" VARCHAR,
    "arn" VARCHAR,
    "feature_set" VARCHAR,
    "master_account_arn" VARCHAR,
    "master_account_id" VARCHAR,
    "master_account_email" VARCHAR,
    "available_policy_types" STRUCT(
        "type" VARCHAR,
        "status" VARCHAR
    )[]
)
Show child fields
organization.arn

The Amazon Resource Name (ARN) of an organization.

For more information about ARNs in Organizations, see ARN Formats Supported by Organizations in the Amazon Web Services Service Authorization Reference.

organization.available_policy_types[]
Show child fields
organization.available_policy_types[].status

The status of the policy type as it relates to the associated root. To attach a policy of the specified type to a root or to an OU or account in that root, it must be available in the organization and enabled for that root.

organization.available_policy_types[].type

The name of the policy type.

organization.feature_set

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. For more information, see Enabling all features in your organization in the Organizations User Guide.

organization.id

The unique identifier (ID) of an organization.

The regex pattern for an organization ID string requires "o-" followed by from 10 to 32 lowercase letters or digits.

organization.master_account_arn

The Amazon Resource Name (ARN) of the account that is designated as the management account for the organization.

For more information about ARNs in Organizations, see ARN Formats Supported by Organizations in the Amazon Web Services Service Authorization Reference.

organization.master_account_email

The email address that is associated with the Amazon Web Services account that is designated as the management account for the organization.

organization.master_account_id

The unique identifier (ID) of the management account of an organization.

The regex pattern for an account ID string requires exactly 12 digits.