Table: aws_iam_accounts

This table shows data for IAM Accounts.

The primary key for this table is account_id.

Columns

NameType
_cq_source_nameutf8
_cq_sync_timetimestamp[us, tz=UTC]
_cq_iduuid
_cq_parent_iduuid
account_id (PK)utf8
usersint64
users_quotaint64
groupsint64
groups_quotaint64
server_certificatesint64
server_certificates_quotaint64
user_policy_size_quotaint64
group_policy_size_quotaint64
groups_per_user_quotaint64
signing_certificates_per_user_quotaint64
access_keys_per_user_quotaint64
mfa_devicesint64
mfa_devices_in_useint64
account_mfa_enabledbool
account_access_keys_presentbool
account_signing_certificates_presentbool
attached_policies_per_group_quotaint64
attached_policies_per_role_quotaint64
attached_policies_per_user_quotaint64
policiesint64
policies_quotaint64
policy_size_quotaint64
policy_versions_in_useint64
policy_versions_in_use_quotaint64
versions_per_policy_quotaint64
global_endpoint_token_versionint64
aliaseslist<item: utf8, nullable>