| Column Name | Column Data Type |
|---|
farm_id Required Input Column
The farm ID to use for the step search. | VARCHAR |
item_offset Required Input Column
Defines how far into the scrollable list to start the return of results. | BIGINT |
queue_ids Required Input Column
The queue IDs in the step search. | VARCHAR[] |
Show child fields- queue_ids[]
|
filter_expressions Input Column
The filter expression, AND or OR, to use when searching among a group of search strings in a resource. You can use two groupings per search each within parenthesis (). | STRUCT(
"filters" STRUCT(
"date_time_filter" STRUCT(
"name" VARCHAR,
"operator" VARCHAR,
"date_time" TIMESTAMP_S
),
"parameter_filter" STRUCT(
"name" VARCHAR,
"operator" VARCHAR,
"value" VARCHAR
),
"search_term_filter" STRUCT(
"search_term" VARCHAR
),
"string_filter" STRUCT(
"name" VARCHAR,
"operator" VARCHAR,
"value" VARCHAR
)
)[],
"operator" VARCHAR
) |
Show child fields- filter_expressions.filters[]
Show child fields- filter_expressions.filters[].date_time_filter
Filters based on date and time. Show child fields- filter_expressions.filters[].date_time_filter.date_time
The date and time. - filter_expressions.filters[].date_time_filter.name
The name of the date-time field to filter on. - filter_expressions.filters[].date_time_filter.operator
The type of comparison to use to filter the results.
- filter_expressions.filters[].parameter_filter
Filters by parameter. Show child fields- filter_expressions.filters[].parameter_filter.name
The name of the parameter to filter on. - filter_expressions.filters[].parameter_filter.operator
The type of comparison to use to filter results. - filter_expressions.filters[].parameter_filter.value
The parameter's value.
- filter_expressions.filters[].search_term_filter
Filters by a specified search term. Show child fields- filter_expressions.filters[].search_term_filter.search_term
The term to search for.
- filter_expressions.filters[].string_filter
Filters by a string. Show child fields- filter_expressions.filters[].string_filter.name
The field name to search. - filter_expressions.filters[].string_filter.operator
The type of comparison to use for this search. - filter_expressions.filters[].string_filter.value
The string to search for.
- filter_expressions.operator
The operators to include in the search.
|
job_id Input Column
The job ID to use in the step search. | VARCHAR |
page_size Input Column
Specifies the number of items per page for the resource. | BIGINT |
sort_expressions Input Column
The search terms for a resource. | STRUCT(
"user_jobs_first" STRUCT(
"user_identity_id" VARCHAR
),
"field_sort" STRUCT(
"sort_order" VARCHAR,
"name" VARCHAR
),
"parameter_sort" STRUCT(
"sort_order" VARCHAR,
"name" VARCHAR
)
)[] |
Show child fields- sort_expressions[]
Show child fields- sort_expressions[].field_sort
Options for sorting by a field. Show child fields- sort_expressions[].field_sort.name
The name of the field. - sort_expressions[].field_sort.sort_order
The sort order for the field.
- sort_expressions[].parameter_sort
Options for sorting by a parameter. Show child fields- sort_expressions[].parameter_sort.name
The parameter name to sort by. - sort_expressions[].parameter_sort.sort_order
The sort order for the parameter.
- sort_expressions[].user_jobs_first
Options for sorting a particular user's jobs first. Show child fields- sort_expressions[].user_jobs_first.user_identity_id
The user's ID.
|
_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.
|
next_item_offset
The next incremental starting point after the defined itemOffset. | BIGINT |
steps
The steps in the search. | STRUCT(
"step_id" VARCHAR,
"job_id" VARCHAR,
"queue_id" VARCHAR,
"name" VARCHAR,
"lifecycle_status" VARCHAR,
"lifecycle_status_message" VARCHAR,
"task_run_status" VARCHAR,
"target_task_run_status" VARCHAR,
"task_run_status_counts" MAP(VARCHAR, BIGINT),
"created_at" TIMESTAMP_S,
"started_at" TIMESTAMP_S,
"ended_at" TIMESTAMP_S,
"parameter_space" STRUCT(
"parameters" STRUCT(
"name" VARCHAR,
"type" VARCHAR
)[],
"combination" VARCHAR
)
)[] |
Show child fields- steps[]
Show child fields- steps[].created_at
The date and time the resource was created. - steps[].ended_at
The date and time the resource ended running. - steps[].job_id
The job ID. - steps[].lifecycle_status
The life cycle status. - steps[].lifecycle_status_message
The life cycle status message. - steps[].name
The step name. - steps[].parameter_space
The parameters and combination expressions for the search. Show child fields- steps[].parameter_space.combination
The combination expression to use in the search. - steps[].parameter_space.parameters[]
Show child fields- steps[].parameter_space.parameters[].name
The name of the parameter. - steps[].parameter_space.parameters[].type
The data type of the parameter.
- steps[].queue_id
The queue ID. - steps[].started_at
The date and time the resource started running. - steps[].step_id
The step ID. - steps[].target_task_run_status
The task status to start with on the job. - steps[].task_run_status
The task run status for the job. -
PENDING–pending and waiting for resources. -
READY–ready to be processed. -
ASSIGNED–assigned and will run next on a worker. -
SCHEDULED–scheduled to be run on a worker. -
INTERRUPTING–being interrupted. -
RUNNING–running on a worker. -
SUSPENDED–the task is suspended. -
CANCELED–the task has been canceled. -
FAILED–the task has failed. -
SUCCEEDED–the task has succeeded. - steps[].task_run_status_counts
The number of tasks running on the job.
|
total_results
The total number of results in the search. | BIGINT |