| Column Name | Column Data Type |
|---|
path_prefix Input Column
The path prefix for filtering the results. For example, the prefix /application_abc/component_xyz/ gets all instance profiles whose path starts with /application_abc/component_xyz/. This parameter is optional. If it is not included, it defaults to a slash (/), listing all instance profiles. This parameter allows (through its regex pattern) a string of characters consisting of either a forward slash (/) by itself or a string that must begin and end with forward slashes. In addition, it can contain any ASCII character from the ! (\u0021) through the DEL character (\u007F), including most punctuation characters, digits, and upper and lowercased letters. | VARCHAR |
_aws_profile Input Column
The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role. | STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
) |
Show child fields- _aws_profile.account_id
The AWS account id - _aws_profile.assumed_role_arn
The ARN of the assumed role - _aws_profile.name
The unique name of the profile. - _aws_profile.organization
Information about this profile's membership in the AWS organization. Show child fields- _aws_profile.organization.account_name
The name of account speciifed by the organization - _aws_profile.organization.id
The organization id - _aws_profile.organization.master_account
Show child fields- _aws_profile.organization.master_account.email
The organization master account email address - _aws_profile.organization.master_account.id
The organization master account id
- _aws_profile.organization.parents[]
Show child fields- _aws_profile.organization.parents[].id
The id of the parent - _aws_profile.organization.parents[].name
The name of the parent - _aws_profile.organization.parents[].tags[]
Show child fields- _aws_profile.organization.parents[].tags[].key
- _aws_profile.organization.parents[].tags[].value
- _aws_profile.organization.parents[].type
The type of parent can be an organization unit or a root
- _aws_profile.organization.tags[]
Show child fields- _aws_profile.organization.tags[].key
- _aws_profile.organization.tags[].value
- _aws_profile.type
The type of profile, either 'credentials' or 'assumed_role' - _aws_profile.via_profile_name
This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
|
arn
The Amazon Resource Name (ARN) specifying the instance profile. For more information about ARNs and how to use them in policies, see IAM identifiers in the IAM User Guide. | VARCHAR |
create_date
The date when the instance profile was created. | TIMESTAMP_S |
instance_profile_id
The stable and unique string identifying the instance profile. For more information about IDs, see IAM identifiers in the IAM User Guide. | VARCHAR |
instance_profile_name
The name identifying the instance profile. | VARCHAR |
path
The path to the instance profile. For more information about paths, see IAM identifiers in the IAM User Guide. | VARCHAR |
roles
The role associated with the instance profile. | STRUCT(
"path" VARCHAR,
"role_name" VARCHAR,
"role_id" VARCHAR,
"arn" VARCHAR,
"create_date" TIMESTAMP_S,
"assume_role_policy_document" VARCHAR,
"description" VARCHAR,
"max_session_duration" BIGINT,
"permissions_boundary" STRUCT(
"permissions_boundary_type" VARCHAR,
"permissions_boundary_arn" VARCHAR
),
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"role_last_used" STRUCT(
"last_used_date" TIMESTAMP_S,
"region" VARCHAR
)
)[] |
Show child fields- roles[]
Show child fields- roles[].arn
The Amazon Resource Name (ARN) specifying the role. For more information about ARNs and how to use them in policies, see IAM identifiers in the IAM User Guide guide. - roles[].assume_role_policy_document
The policy that grants an entity permission to assume the role. - roles[].create_date
The date and time, in ISO 8601 date-time format, when the role was created. - roles[].description
A description of the role that you provide. - roles[].max_session_duration
The maximum session duration (in seconds) for the specified role. Anyone who uses the CLI, or API to assume the role can specify the duration using the optional DurationSeconds API parameter or duration-seconds CLI parameter. - roles[].path
The path to the role. For more information about paths, see IAM identifiers in the IAM User Guide. - roles[].permissions_boundary
The ARN of the policy used to set the permissions boundary for the role. For more information about permissions boundaries, see Permissions boundaries for IAM identities in the IAM User Guide. Show child fields- roles[].permissions_boundary.permissions_boundary_arn
The ARN of the policy used to set the permissions boundary for the user or role. - roles[].permissions_boundary.permissions_boundary_type
The permissions boundary usage type that indicates what type of IAM resource is used as the permissions boundary for an entity. This data type can only have a value of Policy.
- roles[].role_id
The stable and unique string identifying the role. For more information about IDs, see IAM identifiers in the IAM User Guide. - roles[].role_last_used
Contains information about the last time that an IAM role was used. This includes the date and time and the Region in which the role was last used. Activity is only reported for the trailing 400 days. This period can be shorter if your Region began supporting these features within the last year. The role might have been used more than 400 days ago. For more information, see Regions where data is tracked in the IAM user Guide. Show child fields- roles[].role_last_used.last_used_date
The date and time, in ISO 8601 date-time format that the role was last used. This field is null if the role has not been used within the IAM tracking period. For more information about the tracking period, see Regions where data is tracked in the IAM User Guide. - roles[].role_last_used.region
The name of the Amazon Web Services Region in which the role was last used.
- roles[].role_name
The friendly name that identifies the role. - roles[].tags[]
Show child fields- roles[].tags[].key
The key name that can be used to look up or retrieve the associated value. For example, Department or Cost Center are common choices. - roles[].tags[].value
The value associated with this tag. For example, tags with a key name of Department could have values such as Human Resources, Accounting, and Support. Tags with a key name of Cost Center might have values that consist of the number associated with the different cost centers in your company. Typically, many resources have tags with the same key name but with different values. Amazon Web Services always interprets the tag Value as a single string. If you need to store an array, you can store comma-separated values in the string. However, you must interpret the value in your code.
|
tags
A list of tags that are attached to the instance profile. For more information about tagging, see Tagging IAM resources in the IAM User Guide. | STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[] |
Show child fields- tags[]
Show child fields- tags[].key
The key name that can be used to look up or retrieve the associated value. For example, Department or Cost Center are common choices. - tags[].value
The value associated with this tag. For example, tags with a key name of Department could have values such as Human Resources, Accounting, and Support. Tags with a key name of Cost Center might have values that consist of the number associated with the different cost centers in your company. Typically, many resources have tags with the same key name but with different values. Amazon Web Services always interprets the tag Value as a single string. If you need to store an array, you can store comma-separated values in the string. However, you must interpret the value in your code.
|