statements

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

Overview

Name	statements
Type	Resource
Id	aws.glue.statements

Fields

The following fields are returned by SELECT queries:

get_statement

Name	Datatype	Description
code	string	The execution code of the statement.
completed_on	integer (int64)	The unix time and date that the job definition was completed.
id	integer	The ID of the statement.
output	object	The output in JSON.
progress	number (double)	The code execution progress.
started_on	integer (int64)	The unix time and date that the job definition was started.
state	string	The state while request is actioned. (WAITING, RUNNING, AVAILABLE, CANCELLING, CANCELLED, ERROR)

list_statements

Name	Datatype	Description
next_token	string	A continuation token, if not all statements have yet been returned.
statements	array	Returns the list of statements.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_statement	select	region		Retrieves the statement.
list_statements	select	region		Lists statements for the session.

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_statement

Retrieves the statement.

SELECT
code,
completed_on,
id,
output,
progress,
started_on,
state
FROM aws.glue.statements
WHERE region = '{{ region }}' -- required
;

list_statements

Lists statements for the session.

SELECT
next_token,
statements
FROM aws.glue.statements
WHERE region = '{{ region }}' -- required
;