Skip to content

aws.batch.describe_job_queues

Example SQL Queries

SELECT * FROM
aws.batch.describe_job_queues;

Description

Describes one or more of your job queues.

Table Definition

Column NameColumn Data Type
job_queues Input Column

A list of up to 100 queue names or full queue Amazon Resource Name (ARN) entries.

VARCHAR[]
Show child fields
job_queues[]
_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
compute_environment_order

The compute environments that are attached to the job queue and the order that job placement is preferred. Compute environments are selected for job placement in ascending order.

STRUCT(
"order" BIGINT,
"compute_environment" VARCHAR
)[]
Show child fields
compute_environment_order[]
Show child fields
compute_environment_order[].compute_environment

The Amazon Resource Name (ARN) of the compute environment.

compute_environment_order[].order

The order of the compute environment. Compute environments are tried in ascending order. For example, if two compute environments are associated with a job queue, the compute environment with a lower order integer value is tried for job placement first.

job_queue_arn

The Amazon Resource Name (ARN) of the job queue.

VARCHAR
job_queue_name

The job queue name.

VARCHAR
job_state_time_limit_actions

The set of actions that Batch perform on jobs that remain at the head of the job queue in the specified state longer than specified times. Batch will perform each action after maxTimeSeconds has passed.

STRUCT(
"reason" VARCHAR,
"state" VARCHAR,
"max_time_seconds" BIGINT,
"action" VARCHAR
)[]
Show child fields
job_state_time_limit_actions[]
Show child fields
job_state_time_limit_actions[].action

The action to take when a job is at the head of the job queue in the specified state for the specified period of time. The only supported value is CANCEL, which will cancel the job.

job_state_time_limit_actions[].max_time_seconds

The approximate amount of time, in seconds, that must pass with the job in the specified state before the action is taken. The minimum value is 600 (10 minutes) and the maximum value is 86,400 (24 hours).

job_state_time_limit_actions[].reason

The reason to log for the action being taken.

job_state_time_limit_actions[].state

The state of the job needed to trigger the action. The only supported value is RUNNABLE.

priority

The priority of the job queue. Job queues with a higher priority (or a higher integer value for the priority parameter) are evaluated first when associated with the same compute environment. Priority is determined in descending order. For example, a job queue with a priority value of 10 is given scheduling preference over a job queue with a priority value of 1. All of the compute environments must be either Amazon EC2 (EC2 or SPOT) or Fargate (FARGATE or FARGATE_SPOT). Amazon EC2 and Fargate compute environments can't be mixed.

BIGINT
scheduling_policy_arn

The Amazon Resource Name (ARN) of the scheduling policy. The format is aws:Partition:batch:Region:Account:scheduling-policy/Name . For example, aws:aws:batch:us-west-2:123456789012:scheduling-policy/MySchedulingPolicy.

VARCHAR
state

Describes the ability of the queue to accept new jobs. If the job queue state is ENABLED, it can accept jobs. If the job queue state is DISABLED, new jobs can't be added to the queue, but jobs already in the queue can finish.

VARCHAR
status

The status of the job queue (for example, CREATING or VALID).

VARCHAR
status_reason

A short, human-readable string to provide additional details for the current status of the job queue.

VARCHAR
tags

The tags that are applied to the job queue. For more information, see Tagging your Batch resources in Batch User Guide.

MAP(VARCHAR, VARCHAR)