| Column Name | Column Data Type |
|---|
filters Input Column
A set of filters by which to return Jobs. | STRUCT(
"from_date" VARCHAR,
"job_i_ds" VARCHAR[],
"to_date" VARCHAR
) |
Show child fields- filters.from_date
The start date in a date range query. - filters.job_i_ds[]
- filters.to_date
The end date in a date range query.
|
_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 |
arn
The ARN of a Job. | VARCHAR |
creation_date_time
The date and time of when the Job was created. | VARCHAR |
end_date_time
The date and time of when the Job ended. | VARCHAR |
initiated_by
A string representing who initiated the Job. | VARCHAR |
job_id
The ID of the Job. | VARCHAR |
participating_resources
A list of resources that the Job is acting upon. | STRUCT(
"launch_status" VARCHAR,
"participating_resource_id" STRUCT(
"source_network_id" VARCHAR
)
)[] |
Show child fields- participating_resources[]
Show child fields- participating_resources[].launch_status
The launch status of a participating resource. - participating_resources[].participating_resource_id
The ID of a participating resource. Show child fields- participating_resources[].participating_resource_id.source_network_id
Source Network ID.
|
participating_servers
A list of servers that the Job is acting upon. | STRUCT(
"launch_actions_status" STRUCT(
"runs" STRUCT(
"action" STRUCT(
"action_code" VARCHAR,
"action_id" VARCHAR,
"action_version" VARCHAR,
"active" BOOLEAN,
"category" VARCHAR,
"description" VARCHAR,
"name" VARCHAR,
"optional" BOOLEAN,
"order" BIGINT,
"parameters" MAP(VARCHAR, STRUCT(
"type" VARCHAR,
"value" VARCHAR
)),
"type" VARCHAR
),
"failure_reason" VARCHAR,
"run_id" VARCHAR,
"status" VARCHAR
)[],
"ssm_agent_discovery_datetime" VARCHAR
),
"launch_status" VARCHAR,
"recovery_instance_id" VARCHAR,
"source_server_id" VARCHAR
)[] |
Show child fields- participating_servers[]
Show child fields- participating_servers[].launch_actions_status
The post-launch action runs of a participating server. Show child fields- participating_servers[].launch_actions_status.runs[]
Show child fields- participating_servers[].launch_actions_status.runs[].action
Action. Show child fields- participating_servers[].launch_actions_status.runs[].action.action_code
Launch action code. - participating_servers[].launch_actions_status.runs[].action.action_id
Launch action Id. - participating_servers[].launch_actions_status.runs[].action.action_version
Launch action version. - participating_servers[].launch_actions_status.runs[].action.active
Whether the launch action is active. - participating_servers[].launch_actions_status.runs[].action.category
Launch action category. - participating_servers[].launch_actions_status.runs[].action.description
Launch action description. - participating_servers[].launch_actions_status.runs[].action.name
Launch action name. - participating_servers[].launch_actions_status.runs[].action.optional
Whether the launch will not be marked as failed if this action fails. - participating_servers[].launch_actions_status.runs[].action.order
Launch action order. - participating_servers[].launch_actions_status.runs[].action.parameters
Launch action parameters. - participating_servers[].launch_actions_status.runs[].action.type
Launch action type.
- participating_servers[].launch_actions_status.runs[].failure_reason
Failure reason. - participating_servers[].launch_actions_status.runs[].run_id
Run Id. - participating_servers[].launch_actions_status.runs[].status
Run status.
- participating_servers[].launch_actions_status.ssm_agent_discovery_datetime
Time where the AWS Systems Manager was detected as running on the launched instance.
- participating_servers[].launch_status
The launch status of a participating server. - participating_servers[].recovery_instance_id
The Recovery Instance ID of a participating server. - participating_servers[].source_server_id
The Source Server ID of a participating server.
|
status
The status of the Job. | VARCHAR |
tags
A list of tags associated with the Job. | MAP(VARCHAR, VARCHAR) |
type
The type of the Job. | VARCHAR |