| Column Name | Column Data Type |
|---|
max_results Input Column
Represents the maximum number of results on a page or for an API request call. | BIGINT |
next_token Input Column
The pagination token that's used to fetch the next set of results. | VARCHAR |
status Input Column
The current status of the assessment. | 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.
|
_aws_region Input Column
The AWS region to use. | VARCHAR |
assessment_metadata
The metadata that the ListAssessments API returns for each assessment. | STRUCT(
"name" VARCHAR,
"id" VARCHAR,
"compliance_type" VARCHAR,
"status" VARCHAR,
"roles" STRUCT(
"role_type" VARCHAR,
"role_arn" VARCHAR
)[],
"delegations" STRUCT(
"id" VARCHAR,
"assessment_name" VARCHAR,
"assessment_id" VARCHAR,
"status" VARCHAR,
"role_arn" VARCHAR,
"role_type" VARCHAR,
"creation_time" TIMESTAMP_S,
"last_updated" TIMESTAMP_S,
"control_set_id" VARCHAR,
"comment" VARCHAR,
"created_by" VARCHAR
)[],
"creation_time" TIMESTAMP_S,
"last_updated" TIMESTAMP_S
)[] |
Show child fields- assessment_metadata[]
Show child fields- assessment_metadata[].compliance_type
The name of the compliance standard that's related to the assessment, such as PCI-DSS. - assessment_metadata[].creation_time
Specifies when the assessment was created. - assessment_metadata[].delegations[]
Show child fields- assessment_metadata[].delegations[].assessment_id
The identifier for the assessment that's associated with the delegation. - assessment_metadata[].delegations[].assessment_name
The name of the assessment that's associated with the delegation. - assessment_metadata[].delegations[].comment
The comment that's related to the delegation. - assessment_metadata[].delegations[].control_set_id
The identifier for the control set that's associated with the delegation. - assessment_metadata[].delegations[].created_by
The user or role that created the delegation. - assessment_metadata[].delegations[].creation_time
Specifies when the delegation was created. - assessment_metadata[].delegations[].id
The unique identifier for the delegation. - assessment_metadata[].delegations[].last_updated
Specifies when the delegation was last updated. - assessment_metadata[].delegations[].role_arn
The Amazon Resource Name (ARN) of the IAM role. - assessment_metadata[].delegations[].role_type
The type of customer persona. In CreateAssessment, roleType can only be PROCESS_OWNER. In UpdateSettings, roleType can only be PROCESS_OWNER. In BatchCreateDelegationByAssessment, roleType can only be RESOURCE_OWNER. - assessment_metadata[].delegations[].status
The status of the delegation.
- assessment_metadata[].id
The unique identifier for the assessment. - assessment_metadata[].last_updated
The time of the most recent update. - assessment_metadata[].name
The name of the assessment. - assessment_metadata[].roles[]
Show child fields- assessment_metadata[].roles[].role_arn
The Amazon Resource Name (ARN) of the IAM role. - assessment_metadata[].roles[].role_type
The type of customer persona. In CreateAssessment, roleType can only be PROCESS_OWNER. In UpdateSettings, roleType can only be PROCESS_OWNER. In BatchCreateDelegationByAssessment, roleType can only be RESOURCE_OWNER.
- assessment_metadata[].status
The current status of the assessment.
|