| Column Name | Column Data Type |
|---|
detail_level Input Column
The detail applied to the CIS scan. | VARCHAR |
filter_criteria Input Column
The CIS scan filter criteria. | STRUCT(
"failed_checks_filters" STRUCT(
"lower_inclusive" BIGINT,
"upper_inclusive" BIGINT
)[],
"scan_arn_filters" STRUCT(
"comparison" VARCHAR,
"value" VARCHAR
)[],
"scan_at_filters" STRUCT(
"earliest_scan_start_time" TIMESTAMP_S,
"latest_scan_start_time" TIMESTAMP_S
)[],
"scan_configuration_arn_filters" STRUCT(
"comparison" VARCHAR,
"value" VARCHAR
)[],
"scan_name_filters" STRUCT(
"comparison" VARCHAR,
"value" VARCHAR
)[],
"scan_status_filters" STRUCT(
"comparison" VARCHAR,
"value" VARCHAR
)[],
"scheduled_by_filters" STRUCT(
"comparison" VARCHAR,
"value" VARCHAR
)[],
"target_account_id_filters" STRUCT(
"comparison" VARCHAR,
"value" VARCHAR
)[],
"target_resource_id_filters" STRUCT(
"comparison" VARCHAR,
"value" VARCHAR
)[],
"target_resource_tag_filters" STRUCT(
"comparison" VARCHAR,
"key" VARCHAR,
"value" VARCHAR
)[]
) |
Show child fields- filter_criteria.failed_checks_filters[]
Show child fields- filter_criteria.failed_checks_filters[].lower_inclusive
The CIS number filter's lower inclusive. - filter_criteria.failed_checks_filters[].upper_inclusive
The CIS number filter's upper inclusive.
- filter_criteria.scan_arn_filters[]
Show child fields- filter_criteria.scan_arn_filters[].comparison
The comparison value of the CIS string filter. - filter_criteria.scan_arn_filters[].value
The value of the CIS string filter.
- filter_criteria.scan_at_filters[]
Show child fields- filter_criteria.scan_at_filters[].earliest_scan_start_time
The CIS date filter's earliest scan start time. - filter_criteria.scan_at_filters[].latest_scan_start_time
The CIS date filter's latest scan start time.
- filter_criteria.scan_configuration_arn_filters[]
Show child fields- filter_criteria.scan_configuration_arn_filters[].comparison
The comparison value of the CIS string filter. - filter_criteria.scan_configuration_arn_filters[].value
The value of the CIS string filter.
- filter_criteria.scan_name_filters[]
Show child fields- filter_criteria.scan_name_filters[].comparison
The comparison value of the CIS string filter. - filter_criteria.scan_name_filters[].value
The value of the CIS string filter.
- filter_criteria.scan_status_filters[]
Show child fields- filter_criteria.scan_status_filters[].comparison
The filter comparison value. - filter_criteria.scan_status_filters[].value
The filter value.
- filter_criteria.scheduled_by_filters[]
Show child fields- filter_criteria.scheduled_by_filters[].comparison
The comparison value of the CIS string filter. - filter_criteria.scheduled_by_filters[].value
The value of the CIS string filter.
- filter_criteria.target_account_id_filters[]
Show child fields- filter_criteria.target_account_id_filters[].comparison
The comparison value of the CIS string filter. - filter_criteria.target_account_id_filters[].value
The value of the CIS string filter.
- filter_criteria.target_resource_id_filters[]
Show child fields- filter_criteria.target_resource_id_filters[].comparison
The comparison value of the CIS string filter. - filter_criteria.target_resource_id_filters[].value
The value of the CIS string filter.
- filter_criteria.target_resource_tag_filters[]
Show child fields- filter_criteria.target_resource_tag_filters[].comparison
The tag filter comparison value. - filter_criteria.target_resource_tag_filters[].key
The tag filter key. - filter_criteria.target_resource_tag_filters[].value
The tag filter value.
|
sort_by Input Column
The CIS scans sort by order. | VARCHAR |
sort_order Input Column
The CIS scans sort order. | 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 |
failed_checks
The CIS scan's failed checks. | BIGINT |
scan_arn
The CIS scan's ARN. | VARCHAR |
scan_configuration_arn
The CIS scan's configuration ARN. | VARCHAR |
scan_date
The CIS scan's date. | TIMESTAMP_S |
scan_name
The the name of the scan configuration that's associated with this scan. | VARCHAR |
scheduled_by
The account or organization that schedules the CIS scan. | VARCHAR |
security_level
The security level for the CIS scan. Security level refers to the Benchmark levels that CIS assigns to a profile. | VARCHAR |
status
The CIS scan's status. | VARCHAR |
targets
The CIS scan's targets. | STRUCT(
"account_ids" VARCHAR[],
"target_resource_tags" MAP(VARCHAR, VARCHAR[])
) |
Show child fields- targets.account_ids[]
- targets.target_resource_tags
The CIS target resource tags.
|
total_checks
The CIS scan's total checks. | BIGINT |