Skip to content

aws.deadline.get_sessions_statistics_aggregation

Example SQL Queries

SELECT * FROM
aws.deadline.get_sessions_statistics_aggregation
WHERE
"farm_id" = 'VALUE'
AND "aggregation_id" = 'VALUE';

Description

Gets a set of statistics for queues or farms. Before you can call the GetSessionStatisticsAggregation operation, you must first call the StartSessionsStatisticsAggregation operation. Statistics are available for 1 hour after you call the StartSessionsStatisticsAggregation operation.

Table Definition

Column NameColumn Data Type
aggregation_id Required Input Column

The identifier returned by the StartSessionsStatisticsAggregation operation that identifies the aggregated statistics.

VARCHAR
farm_id Required Input Column

The identifier of the farm to include in the statistics. This should be the same as the farm ID used in the call to the StartSessionsStatisticsAggregation operation.

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.

statistics

The statistics for the specified fleets or queues.

STRUCT(
"queue_id" VARCHAR,
"fleet_id" VARCHAR,
"job_id" VARCHAR,
"job_name" VARCHAR,
"user_id" VARCHAR,
"usage_type" VARCHAR,
"license_product" VARCHAR,
"instance_type" VARCHAR,
"count" BIGINT,
"cost_in_usd" STRUCT(
"min" DOUBLE,
"max" DOUBLE,
"avg" DOUBLE,
"sum" DOUBLE
),
"runtime_in_seconds" STRUCT(
"min" DOUBLE,
"max" DOUBLE,
"avg" DOUBLE,
"sum" DOUBLE
),
"aggregation_start_time" TIMESTAMP_S,
"aggregation_end_time" TIMESTAMP_S
)[]
Show child fields
statistics[]
Show child fields
statistics[].aggregation_end_time

The end time for the aggregation.

statistics[].aggregation_start_time

The start time for the aggregation.

statistics[].cost_in_usd

How the statistics should appear in USD. Options include: minimum, maximum, average or sum.

Show child fields
statistics[].cost_in_usd.avg

The average of the usage statistics.

statistics[].cost_in_usd.max

The maximum among the usage statistics.

statistics[].cost_in_usd.min

The minimum of the usage statistics.

statistics[].cost_in_usd.sum

The sum of the usage statistics.

statistics[].count

The number of instances in a list of statistics.

statistics[].fleet_id

The fleet ID.

statistics[].instance_type

The type of instance.

statistics[].job_id

The job ID.

statistics[].job_name

The job name.

statistics[].license_product

The licensed product.

statistics[].queue_id

The queue ID.

statistics[].runtime_in_seconds

The total aggregated runtime.

Show child fields
statistics[].runtime_in_seconds.avg

The average of the usage statistics.

statistics[].runtime_in_seconds.max

The maximum among the usage statistics.

statistics[].runtime_in_seconds.min

The minimum of the usage statistics.

statistics[].runtime_in_seconds.sum

The sum of the usage statistics.

statistics[].usage_type

The type of usage for the statistics.

statistics[].user_id

The user ID.

status

The status of the aggregated results. An aggregation may fail or time out if the results are too large. If this happens, you can call the StartSessionsStatisticsAggregation operation after you reduce the aggregation time frame, reduce the number of queues or fleets in the aggregation, or increase the period length.

If you call the StartSessionsStatisticsAggregation operation when the status is IN_PROGRESS, you will receive a ThrottlingException.

VARCHAR
status_message

A message that describes the status.

VARCHAR