Skip to content
AWS for Query.Farm

aws.deadline.list_fleets

Example SQL Queries

SELECT * FROM
aws.deadline.list_fleets
WHERE
"farm_id" = 'VALUE';

Description

Lists fleets.

Table Definition

Column NameColumn Data Type
farm_id Required Input Column

The farm ID.

VARCHAR
display_name Input Column

The display name of the fleet summary to update.

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
principal_id Input Column

The principal ID of the members to include in the fleet.

VARCHAR
status Input Column

The status of the fleet.

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 a fleet.

VARCHAR
configuration

The configuration details 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
fleet_id

The fleet ID.

VARCHAR
max_worker_count

The maximum number of workers specified in the fleet.

BIGINT
min_worker_count

The minimum number of workers in the fleet.

BIGINT
target_worker_count

The target number of workers in a 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 summary.

BIGINT