Skip to content
AWS for Query.Farm

aws.athena.get_calculation_execution

Example SQL Queries

SELECT * FROM
aws.athena.get_calculation_execution
WHERE
"calculation_execution_id" = 'VALUE';

Description

Describes a previously submitted calculation execution.

Table Definition

Column NameColumn Data Type
calculation_execution_id Required Input Column

The calculation execution UUID.

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
description

The description of the calculation execution.

VARCHAR
result

Contains result information. This field is populated only if the calculation is completed.

STRUCT(
    "std_out_s3_uri" VARCHAR,
    "std_error_s3_uri" VARCHAR,
    "result_s3_uri" VARCHAR,
    "result_type" VARCHAR
)
Show child fields
result.result_s3_uri

The Amazon S3 location of the folder for the calculation results.

result.result_type

The data format of the calculation result.

result.std_error_s3_uri

The Amazon S3 location of the stderr error messages file for the calculation.

result.std_out_s3_uri

The Amazon S3 location of the stdout file for the calculation.

session_id

The session ID that the calculation ran in.

VARCHAR
statistics

Contains information about the data processing unit (DPU) execution time and progress. This field is populated only when statistics are available.

STRUCT(
    "dpu_execution_in_millis" BIGINT,
    "progress" VARCHAR
)
Show child fields
statistics.dpu_execution_in_millis

The data processing unit execution time in milliseconds for the calculation.

statistics.progress

The progress of the calculation.

status

Contains information about the status of the calculation.

STRUCT(
    "submission_date_time" TIMESTAMP_S,
    "completion_date_time" TIMESTAMP_S,
    "state" VARCHAR,
    "state_change_reason" VARCHAR
)
Show child fields
status.completion_date_time

The date and time the calculation completed processing.

status.state

The state of the calculation execution. A description of each state follows.

CREATING - The calculation is in the process of being created.

CREATED - The calculation has been created and is ready to run.

QUEUED - The calculation has been queued for processing.

RUNNING - The calculation is running.

CANCELING - A request to cancel the calculation has been received and the system is working to stop it.

CANCELED - The calculation is no longer running as the result of a cancel request.

COMPLETED - The calculation has completed without error.

FAILED - The calculation failed and is no longer running.

status.state_change_reason

The reason for the calculation state change (for example, the calculation was canceled because the session was terminated).

status.submission_date_time

The date and time the calculation was submitted for processing.

working_directory

The Amazon S3 location in which calculation results are stored.

VARCHAR