Skip to content
AWS for Query.Farm

aws.deadline.get_fleet

Example SQL Queries

SELECT * FROM
aws.deadline.get_fleet
WHERE
"farm_id" = 'VALUE'
AND "fleet_id" = 'VALUE';

Description

Get a fleet.

Table Definition

Column NameColumn Data Type
farm_id Required Input Column

The farm ID of the farm in the fleet.

VARCHAR
fleet_id Required Input Column

The fleet ID.

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.

auto_scaling_status

The Auto Scaling status of the fleet. Either GROWING, STEADY, or SHRINKING.

VARCHAR
capabilities

Outlines what the fleet is capable of for minimums, maximums, and naming, in addition to attribute names and values.

STRUCT(
    "amounts" STRUCT(
        "name" VARCHAR,
        "min" DOUBLE,
        "max" DOUBLE
    )[],
    "attributes" STRUCT(
        "name" VARCHAR,
        "values" VARCHAR[]
    )[]
)
Show child fields
capabilities.amounts[]
Show child fields
capabilities.amounts[].max

The maximum amount of the fleet worker capability.

capabilities.amounts[].min

The minimum amount of fleet worker capability.

capabilities.amounts[].name

The name of the fleet capability.

capabilities.attributes[]
Show child fields
capabilities.attributes[].name

The name of the fleet attribute capability for the worker.

capabilities.attributes[].values[]
configuration

The configuration setting for the fleet.

STRUCT(
    "customer_managed" STRUCT(
        "mode" VARCHAR,
        "worker_capabilities" STRUCT(
            "v_cpu_count" STRUCT(
                "min" BIGINT,
                "max" BIGINT
            ),
            "memory_mi_b" STRUCT(
                "min" BIGINT,
                "max" BIGINT
            ),
            "accelerator_types" VARCHAR[],
            "accelerator_count" STRUCT(
                "min" BIGINT,
                "max" BIGINT
            ),
            "accelerator_total_memory_mi_b" STRUCT(
                "min" BIGINT,
                "max" BIGINT
            ),
            "os_family" VARCHAR,
            "cpu_architecture_type" VARCHAR,
            "custom_amounts" STRUCT(
                "name" VARCHAR,
                "min" DOUBLE,
                "max" DOUBLE
            )[],
            "custom_attributes" STRUCT(
                "name" VARCHAR,
                "values" VARCHAR[]
            )[]
        ),
        "storage_profile_id" VARCHAR
    ),
    "service_managed_ec2" STRUCT(
        "instance_capabilities" STRUCT(
            "v_cpu_count" STRUCT(
                "min" BIGINT,
                "max" BIGINT
            ),
            "memory_mi_b" STRUCT(
                "min" BIGINT,
                "max" BIGINT
            ),
            "os_family" VARCHAR,
            "cpu_architecture_type" VARCHAR,
            "root_ebs_volume" STRUCT(
                "size_gi_b" BIGINT,
                "iops" BIGINT,
                "throughput_mi_b" BIGINT
            ),
            "allowed_instance_types" VARCHAR[],
            "excluded_instance_types" VARCHAR[],
            "custom_amounts" STRUCT(
                "name" VARCHAR,
                "min" DOUBLE,
                "max" DOUBLE
            )[],
            "custom_attributes" STRUCT(
                "name" VARCHAR,
                "values" VARCHAR[]
            )[]
        ),
        "instance_market_options" STRUCT(
            "type" VARCHAR
        )
    )
)
Show child fields
configuration.customer_managed

The customer managed fleets within a fleet configuration.

Show child fields
configuration.customer_managed.mode

The Auto Scaling mode for the customer managed fleet configuration.

configuration.customer_managed.storage_profile_id

The storage profile ID.

configuration.customer_managed.worker_capabilities

The worker capabilities for a customer managed fleet configuration.

Show child fields
configuration.customer_managed.worker_capabilities.accelerator_count

The range of the accelerator.

Show child fields
configuration.customer_managed.worker_capabilities.accelerator_count.max

The maximum GPU for the accelerator.

configuration.customer_managed.worker_capabilities.accelerator_count.min

The minimum GPU for the accelerator.

configuration.customer_managed.worker_capabilities.accelerator_total_memory_mi_b

The total memory (MiB) for the customer managed worker capabilities.

Show child fields
configuration.customer_managed.worker_capabilities.accelerator_total_memory_mi_b.max

The maximum amount of memory to use for the accelerator, measured in MiB.

configuration.customer_managed.worker_capabilities.accelerator_total_memory_mi_b.min

The minimum amount of memory to use for the accelerator, measured in MiB.

configuration.customer_managed.worker_capabilities.accelerator_types[]
configuration.customer_managed.worker_capabilities.cpu_architecture_type

The CPU architecture type for the customer managed worker capabilities.

configuration.customer_managed.worker_capabilities.custom_amounts[]
Show child fields
configuration.customer_managed.worker_capabilities.custom_amounts[].max

The maximum amount of the fleet worker capability.

configuration.customer_managed.worker_capabilities.custom_amounts[].min

The minimum amount of fleet worker capability.

configuration.customer_managed.worker_capabilities.custom_amounts[].name

The name of the fleet capability.

configuration.customer_managed.worker_capabilities.custom_attributes[]
Show child fields
configuration.customer_managed.worker_capabilities.custom_attributes[].name

The name of the fleet attribute capability for the worker.

configuration.customer_managed.worker_capabilities.custom_attributes[].values[]
configuration.customer_managed.worker_capabilities.memory_mi_b

The memory (MiB).

Show child fields
configuration.customer_managed.worker_capabilities.memory_mi_b.max

The maximum amount of memory (in MiB).

configuration.customer_managed.worker_capabilities.memory_mi_b.min

The minimum amount of memory (in MiB).

configuration.customer_managed.worker_capabilities.os_family

The operating system (OS) family.

configuration.customer_managed.worker_capabilities.v_cpu_count

The vCPU count for the customer manged worker capabilities.

Show child fields
configuration.customer_managed.worker_capabilities.v_cpu_count.max

The maximum amount of vCPU.

configuration.customer_managed.worker_capabilities.v_cpu_count.min

The minimum amount of vCPU.

configuration.service_managed_ec2

The service managed Amazon EC2 instances for a fleet configuration.

Show child fields
configuration.service_managed_ec2.instance_capabilities

The Amazon EC2 instance capabilities.

Show child fields
configuration.service_managed_ec2.instance_capabilities.allowed_instance_types[]
configuration.service_managed_ec2.instance_capabilities.cpu_architecture_type

The CPU architecture type.

configuration.service_managed_ec2.instance_capabilities.custom_amounts[]
Show child fields
configuration.service_managed_ec2.instance_capabilities.custom_amounts[].max

The maximum amount of the fleet worker capability.

configuration.service_managed_ec2.instance_capabilities.custom_amounts[].min

The minimum amount of fleet worker capability.

configuration.service_managed_ec2.instance_capabilities.custom_amounts[].name

The name of the fleet capability.

configuration.service_managed_ec2.instance_capabilities.custom_attributes[]
Show child fields
configuration.service_managed_ec2.instance_capabilities.custom_attributes[].name

The name of the fleet attribute capability for the worker.

configuration.service_managed_ec2.instance_capabilities.custom_attributes[].values[]
configuration.service_managed_ec2.instance_capabilities.excluded_instance_types[]
configuration.service_managed_ec2.instance_capabilities.memory_mi_b

The memory, as MiB, for the Amazon EC2 instance type.

Show child fields
configuration.service_managed_ec2.instance_capabilities.memory_mi_b.max

The maximum amount of memory (in MiB).

configuration.service_managed_ec2.instance_capabilities.memory_mi_b.min

The minimum amount of memory (in MiB).

configuration.service_managed_ec2.instance_capabilities.os_family

The operating system (OS) family.

configuration.service_managed_ec2.instance_capabilities.root_ebs_volume

The root EBS volume.

Show child fields
configuration.service_managed_ec2.instance_capabilities.root_ebs_volume.iops

The IOPS per volume.

configuration.service_managed_ec2.instance_capabilities.root_ebs_volume.size_gi_b

The EBS volume size in GiB.

configuration.service_managed_ec2.instance_capabilities.root_ebs_volume.throughput_mi_b

The throughput per volume in MiB.

configuration.service_managed_ec2.instance_capabilities.v_cpu_count

The amount of vCPU to require for instances in this fleet.

Show child fields
configuration.service_managed_ec2.instance_capabilities.v_cpu_count.max

The maximum amount of vCPU.

configuration.service_managed_ec2.instance_capabilities.v_cpu_count.min

The minimum amount of vCPU.

configuration.service_managed_ec2.instance_market_options

The Amazon EC2 market type.

Show child fields
configuration.service_managed_ec2.instance_market_options.type

The Amazon EC2 instance type.

created_at

The date and time the resource was created.

TIMESTAMP_S
created_by

The user or system that created this resource.

VARCHAR
description

The description of the fleet.

This field can store any content. Escape or encode this content before displaying it on a webpage or any other system that might interpret the content of this field.

VARCHAR
display_name

The display name of the fleet.

This field can store any content. Escape or encode this content before displaying it on a webpage or any other system that might interpret the content of this field.

VARCHAR
max_worker_count

The maximum number of workers specified in the fleet.

BIGINT
min_worker_count

The minimum number of workers specified in the fleet.

BIGINT
role_arn

The IAM role ARN.

VARCHAR
status

The Auto Scaling status of the fleet.

VARCHAR
target_worker_count

The number of target workers in the fleet.

BIGINT
updated_at

The date and time the resource was updated.

TIMESTAMP_S
updated_by

The user or system that updated this resource.

VARCHAR
worker_count

The number of workers in the fleet.

BIGINT