calculation_executions

Creates, updates, deletes, gets or lists a calculation_executions resource.

Overview

Name	calculation_executions
Type	Resource
Id	aws.athena.calculation_executions

Fields

The following fields are returned by SELECT queries:

get_calculation_execution

Name	Datatype	Description
calculation_execution_id	string	The calculation execution UUID.
description	string	The description of the calculation execution.
result	object	Contains result information. This field is populated only if the calculation is completed.
session_id	string	The session ID that the calculation ran in.
statistics	object	Contains information about the data processing unit (DPU) execution time and progress. This field is populated only when statistics are available.
status	object	Contains information about the status of the calculation.
working_directory	string	The Amazon S3 location in which calculation results are stored. (pattern: <code>^(https|s3|S3):​//([^/]+)/?(.*)$</code>)

list_calculation_executions

Name	Datatype	Description
calculations	array	A list of CalculationSummary objects.
next_token	string	A token generated by the Athena service that specifies where to continue pagination if a previous request was truncated. To obtain the next set of pages, pass in the NextToken from the response object of the previous page call.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_calculation_execution	select	region		Describes a previously submitted calculation execution.
list_calculation_executions	select	region		Lists the calculations that have been submitted to a session in descending order. Newer calculations are listed first; older calculations are listed later.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

get_calculation_execution

Describes a previously submitted calculation execution.

SELECT
calculation_execution_id,
description,
result,
session_id,
statistics,
status,
working_directory
FROM aws.athena.calculation_executions
WHERE region = '{{ region }}' -- required
;

list_calculation_executions

Lists the calculations that have been submitted to a session in descending order. Newer calculations are listed first; older calculations are listed later.

SELECT
calculations,
next_token
FROM aws.athena.calculation_executions
WHERE region = '{{ region }}' -- required
;