| Column Name | Column Data Type |
|---|
aggregators Input Column
Optional aggregators that return counts of OpsData based on one or more expressions. | STRUCT(
"aggregator_type" VARCHAR,
"type_name" VARCHAR,
"attribute_name" VARCHAR,
"values" MAP(VARCHAR, VARCHAR),
"filters" STRUCT(
"key" VARCHAR,
"values" VARCHAR[],
"type" VARCHAR
)[]
)[] |
Show child fields- aggregators[]
Show child fields- aggregators[].aggregator_type
Either a Range or Count aggregator for limiting an OpsData summary. - aggregators[].attribute_name
The name of an OpsData attribute on which to limit the count of OpsData. - aggregators[].filters[]
Show child fields- aggregators[].filters[].key
The name of the filter. - aggregators[].filters[].type
The type of filter. - aggregators[].filters[].values[]
- aggregators[].type_name
The data type name to use for viewing counts of OpsData. - aggregators[].values
The aggregator value.
|
filters Input Column
Optional filters used to scope down the returned OpsData. | STRUCT(
"key" VARCHAR,
"values" VARCHAR[],
"type" VARCHAR
)[] |
Show child fields- filters[]
Show child fields- filters[].key
The name of the filter. - filters[].type
The type of filter. - filters[].values[]
|
result_attributes Input Column
The OpsData data type to return. | STRUCT(
"type_name" VARCHAR
)[] |
Show child fields- result_attributes[]
Show child fields- result_attributes[].type_name
Name of the data type. Valid value: AWS:OpsItem, AWS:EC2InstanceInformation, AWS:OpsItemTrendline, or AWS:ComplianceSummary.
|
sync_name Input Column
Specify the name of a resource data sync 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 |
data
The data returned by the query. | MAP(VARCHAR, STRUCT(
"capture_time" VARCHAR,
"content" MAP(VARCHAR, VARCHAR)[]
)) |
id
The query ID. | VARCHAR |