| Column Name | Column Data Type |
|---|
task_id Required Input Column
The ID of the audit whose information you want to get. | 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 |
audit_details
Detailed information about each check performed during this audit. | MAP(VARCHAR, STRUCT(
"check_run_status" VARCHAR,
"check_compliant" BOOLEAN,
"total_resources_count" BIGINT,
"non_compliant_resources_count" BIGINT,
"suppressed_non_compliant_resources_count" BIGINT,
"error_code" VARCHAR,
"message" VARCHAR
)) |
scheduled_audit_name
The name of the scheduled audit (only if the audit was a scheduled audit). | VARCHAR |
task_start_time
The time the audit started. | TIMESTAMP_S |
task_statistics
Statistical information about the audit. | STRUCT(
"total_checks" BIGINT,
"in_progress_checks" BIGINT,
"waiting_for_data_collection_checks" BIGINT,
"compliant_checks" BIGINT,
"non_compliant_checks" BIGINT,
"failed_checks" BIGINT,
"canceled_checks" BIGINT
) |
Show child fields- task_statistics.canceled_checks
The number of checks that did not run because the audit was canceled. - task_statistics.compliant_checks
The number of checks that found compliant resources. - task_statistics.failed_checks
The number of checks. - task_statistics.in_progress_checks
The number of checks in progress. - task_statistics.non_compliant_checks
The number of checks that found noncompliant resources. - task_statistics.total_checks
The number of checks in this audit. - task_statistics.waiting_for_data_collection_checks
The number of checks waiting for data collection.
|
task_status
The status of the audit: one of "IN_PROGRESS", "COMPLETED", "FAILED", or "CANCELED". | VARCHAR |
task_type
The type of audit: "ON_DEMAND_AUDIT_TASK" or "SCHEDULED_AUDIT_TASK". | VARCHAR |