| Column Name | Column Data Type |
|---|
assessment_id Required Input Column
The unique identifier for the assessment. | VARCHAR |
control_set_id Required Input Column
The unique identifier for the control set. | VARCHAR |
evidence_folder_id Required Input Column
The unique identifier for the folder that the evidence is stored in. | VARCHAR |
evidence_id Required Input Column
The unique identifier for the evidence. | 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 |
evidence
The evidence that the GetEvidence API returned. | STRUCT(
"data_source" VARCHAR,
"evidence_aws_account_id" VARCHAR,
"time" TIMESTAMP_S,
"event_source" VARCHAR,
"event_name" VARCHAR,
"evidence_by_type" VARCHAR,
"resources_included" STRUCT(
"arn" VARCHAR,
"value" VARCHAR,
"compliance_check" VARCHAR
)[],
"attributes" MAP(VARCHAR, VARCHAR),
"iam_id" VARCHAR,
"compliance_check" VARCHAR,
"aws_organization" VARCHAR,
"aws_account_id" VARCHAR,
"evidence_folder_id" VARCHAR,
"id" VARCHAR,
"assessment_report_selection" VARCHAR
) |
Show child fields- evidence.assessment_report_selection
Specifies whether the evidence is included in the assessment report. - evidence.attributes
The names and values that are used by the evidence event. This includes an attribute name (such as allowUsersToChangePassword) and value (such as true or false). - evidence.aws_account_id
The identifier for the Amazon Web Services account. - evidence.aws_organization
The Amazon Web Services account that the evidence is collected from, and its organization path. - evidence.compliance_check
The evaluation status for automated evidence that falls under the compliance check category. -
Audit Manager classes evidence as non-compliant if Security Hub reports a Fail result, or if Config reports a Non-compliant result. -
Audit Manager classes evidence as compliant if Security Hub reports a Pass result, or if Config reports a Compliant result. -
If a compliance check isn't available or applicable, then no compliance evaluation can be made for that evidence. This is the case if the evidence uses Config or Security Hub as the underlying data source type, but those services aren't enabled. This is also the case if the evidence uses an underlying data source type that doesn't support compliance checks (such as manual evidence, Amazon Web Services API calls, or CloudTrail). - evidence.data_source
The data source where the evidence was collected from. - evidence.event_name
The name of the evidence event. - evidence.event_source
The Amazon Web Service that the evidence is collected from. - evidence.evidence_aws_account_id
The identifier for the Amazon Web Services account. - evidence.evidence_by_type
The type of automated evidence. - evidence.evidence_folder_id
The identifier for the folder that the evidence is stored in. - evidence.iam_id
The unique identifier for the user or role that's associated with the evidence. - evidence.id
The identifier for the evidence. - evidence.resources_included[]
Show child fields- evidence.resources_included[].arn
The Amazon Resource Name (ARN) for the resource. - evidence.resources_included[].compliance_check
The evaluation status for a resource that was assessed when collecting compliance check evidence. -
Audit Manager classes the resource as non-compliant if Security Hub reports a Fail result, or if Config reports a Non-compliant result. -
Audit Manager classes the resource as compliant if Security Hub reports a Pass result, or if Config reports a Compliant result. -
If a compliance check isn't available or applicable, then no compliance evaluation can be made for that resource. This is the case if a resource assessment uses Config or Security Hub as the underlying data source type, but those services aren't enabled. This is also the case if the resource assessment uses an underlying data source type that doesn't support compliance checks (such as manual evidence, Amazon Web Services API calls, or CloudTrail). - evidence.resources_included[].value
The value of the resource.
- evidence.time
The timestamp that represents when the evidence was collected.
|