AWS Organizations

Connect AWS Organizations to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Sync your AWS organization structure into the PostHog Data warehouse, so cost and usage data can be read by account name, organizational unit, and tag.

Create an IAM user or role with the organizations:DescribeOrganization, organizations:ListAccounts, organizations:ListRoots, organizations:ListOrganizationalUnitsForParent, organizations:ListPolicies and organizations:ListTagsForResource permissions, then paste its access key ID and secret access key. Add a session token too if you are using temporary credentials.

Use a key from the management account or from a member account that is a delegated administrator. Keys from other member accounts can only read the organization table.

AWS Organizations is a global service, so there is nothing to pick a region for. This source syncs the accounts, organizational units, and policies in the standard AWS partition.

Configuration

Option	Description
AWS access key ID Type: text Required: True
AWS secret access key Type: password Required: True
AWS session token Type: password Required: False	Only for temporary credentials. Session tokens expire after a few hours, so scheduled syncs will fail once the token expires. Use a permanent access key (starts with AKIA) for recurring imports.

Linking AWS Organizations to PostHog

1. Go to the Data pipeline page in PostHog
2. Click New source and select AWS Organizations
3. Fill in the required configuration fields
4. Click Next, select the tables you want to sync, and then press Import

Supported tables

Table	Description	Sync method	Incremental field	Primary key
accounts	Every AWS account in the organization, with its name, email, state, and the time it joined.	Full refresh	—	—
organization	The organization itself: its ID, feature set, and management account. One row per sync.	Full refresh	—	—
organizational_units	Organizational units in the account hierarchy, each with the parent it sits under.	Full refresh	—	—
policies	Policies in the organization, one row per policy, across every policy type the organization supports.	Full refresh	—	—
resource_tags	Tags attached to accounts, roots, organizational units, and policies. One row per tag.	Full refresh	—	—
roots	Roots of the organization, with the policy types enabled on each.	Full refresh	—	—