Skip to content
AWS for Query.Farm

aws.gamelift.list_compute

Example SQL Queries

SELECT * FROM
aws.gamelift.list_compute
WHERE
"fleet_id" = 'VALUE';

Description

This operation has been expanded to use with the Amazon GameLift containers feature, which is currently in public preview.

Retrieves information on the compute resources in an Amazon GameLift fleet.

To request a list of computes, specify the fleet ID. Use the pagination parameters to retrieve results in a set of sequential pages.

You can filter the result set by location.

If successful, this operation returns information on all computes in the requested fleet. Depending on the fleet's compute type, the result includes the following information:

  • For EC2 fleets, this operation returns information about the EC2 instance. Compute names are instance IDs.

  • For ANYWHERE fleets, this operation returns the compute names and details provided when the compute was registered with RegisterCompute. The GameLiftServiceSdkEndpoint or GameLiftAgentEndpoint is included.

  • For CONTAINER fleets, this operation returns information about containers that are registered as computes, and the instances they're running on. Compute names are container names.

Table Definition

Column NameColumn Data Type
fleet_id Required Input Column

A unique identifier for the fleet that the compute belongs to.

VARCHAR
location Input Column

The name of the custom location you added to the fleet that this compute resource resides in.

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.

_aws_region Input Column

The AWS region to use.

VARCHAR
compute_arn

The ARN that is assigned to a compute resource and uniquely identifies it. ARNs are unique across locations. Instances in managed EC2 fleets are not assigned a Compute ARN.

VARCHAR
compute_name

A descriptive label for the compute resource. For instances in a managed EC2 fleet, the compute name is the same value as the InstanceId ID.

VARCHAR
compute_status

Current status of the compute. A compute must have an ACTIVE status to host game sessions.

VARCHAR
container_attributes

Some attributes of a container. 

STRUCT(
    "container_port_mappings" STRUCT(
        "container_port" BIGINT,
        "connection_port" BIGINT,
        "protocol" VARCHAR
    )[]
)
Show child fields
container_attributes.container_port_mappings[]
Show child fields
container_attributes.container_port_mappings[].connection_port

The port opened on the fleet instance. This is also called the "host port".

container_attributes.container_port_mappings[].container_port

The port opened on the container.

container_attributes.container_port_mappings[].protocol

The network protocol that this mapping supports.

creation_time

A time stamp indicating when this data object was created. Format is a number expressed in Unix time as milliseconds (for example "1469498468.057").

TIMESTAMP_S
dns_name

The DNS name of a compute resource. Amazon GameLift requires a DNS name or IP address for a compute.

VARCHAR
fleet_arn

The Amazon Resource Name (ARN) of the fleet that the compute belongs to.

VARCHAR
game_lift_agent_endpoint

The endpoint of the Amazon GameLift Agent. 

VARCHAR
game_lift_service_sdk_endpoint

The Amazon GameLift SDK endpoint connection for a registered compute resource in an Anywhere fleet. The game servers on the compute use this endpoint to connect to the Amazon GameLift service.

VARCHAR
instance_id

The InstanceID of the Instance hosting the compute for Container and Managed EC2 fleets. 

VARCHAR
ip_address

The IP address of a compute resource. Amazon GameLift requires a DNS name or IP address for a compute.

VARCHAR
operating_system

The type of operating system on the compute resource.

VARCHAR
type

The Amazon EC2 instance type that the fleet uses. For registered computes in an Amazon GameLift Anywhere fleet, this property is empty. 

VARCHAR