Interactive sessions API

• Session structure

• SessionCommand structure

• Statement structure

• StatementOutput structure

• StatementOutputData structure

• ConnectionsList structure

Fields

• Id – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the session.

• CreatedOn – Timestamp.

  The time and date when the session was created.

• Status – UTF-8 string (valid values: PROVISIONING | READY | FAILED | TIMEOUT | STOPPING | STOPPED).

  The session status.

• ErrorMessage – Description string, not more than 2048 bytes long, matching the URI address multi-line string pattern.

  The error message displayed during the session.

• Description – Description string, not more than 2048 bytes long, matching the URI address multi-line string pattern.

  The description of the session.

• Role – UTF-8 string, not less than 20 or more than 2048 bytes long, matching the Custom string pattern #30.

  The name or Amazon Resource Name (ARN) of the IAM role associated with the Session.

• Command – A SessionCommand object.

  The command object.See SessionCommand.

• DefaultArguments – A map array of key-value pairs, not more than 75 pairs.

  Each key is a UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  Each value is a UTF-8 string, not more than 4096 bytes long, matching the URI address multi-line string pattern.

  A map array of key-value pairs. Max is 75 pairs.

• Connections – A ConnectionsList object.

  The number of connections used for the session.

• Progress – Number (double).

  The code execution progress of the session.

• MaxCapacity – Number (double).

  The number of AWS Glue data processing units (DPUs) that can be allocated when the job runs. A DPU is a relative measure of processing power that consists of 4 vCPUs of compute capacity and 16 GB memory.

• SecurityConfiguration – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the SecurityConfiguration structure to be used with the session.

• GlueVersion – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Custom string pattern #47.

  The AWS Glue version determines the versions of Apache Spark and Python that AWS Glue supports. The GlueVersion must be greater than 2.0.

• DataAccessId – UTF-8 string, not less than 1 or more than 36 bytes long.

  The data access ID of the session.

• PartitionId – UTF-8 string, not less than 1 or more than 36 bytes long.

  The partition ID of the sesion.

• NumberOfWorkers – Number (integer).

  The number of workers of a defined WorkerType to use for the session.

• WorkerType – UTF-8 string (valid values: Standard="" | G.1X="" | G.2X="" | G.025X="" | G.4X="" | G.8X="" | Z.2X="").

  The type of predefined worker that is allocated when a session runs. Accepts a value of G.1X, G.2X, G.4X, or G.8X for Spark sessions. Accepts the value Z.2X for Ray sessions.

• CompletedOn – Timestamp.

  The date and time that this session is completed.

• ExecutionTime – Number (double).

  The total time the session ran for.

• DPUSeconds – Number (double).

  The DPUs consumed by the session (formula: ExecutionTime * MaxCapacity).

• IdleTimeout – Number (integer).

  The number of minutes when idle before the session times out.

• ProfileName – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of an AWS Glue usage profile associated with the session.

Fields

• Name – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Specifies the name of the SessionCommand. Can be 'glueetl' or 'gluestreaming'.

• PythonVersion – UTF-8 string, matching the Custom string pattern #48.

  Specifies the Python version. The Python version indicates the version supported for jobs of type Spark.

Fields

• Id – Number (integer).

  The ID of the statement.

• Code – UTF-8 string.

  The execution code of the statement.

• State – UTF-8 string (valid values: WAITING | RUNNING | AVAILABLE | CANCELLING | CANCELLED | ERROR).

  The state while request is actioned.

• Output – A StatementOutput object.

  The output in JSON.

• Progress – Number (double).

  The code execution progress.

• StartedOn – Number (long).

  The unix time and date that the job definition was started.

• CompletedOn – Number (long).

  The unix time and date that the job definition was completed.

Fields

• Data – A StatementOutputData object.

  The code execution output.

• ExecutionCount – Number (integer).

  The execution count of the output.

• Status – UTF-8 string (valid values: WAITING | RUNNING | AVAILABLE | CANCELLING | CANCELLED | ERROR).

  The status of the code execution output.

• ErrorName – UTF-8 string.

  The name of the error in the output.

• ErrorValue – UTF-8 string.

  The error value of the output.

• Traceback – An array of UTF-8 strings.

  The traceback of the output.

Fields

• TextPlain – UTF-8 string.

  The code execution output in text format.

Fields

• Connections – An array of UTF-8 strings.

  A list of connections used by the job.

• CreateSession action (Python: create_session)

• StopSession action (Python: stop_session)

• DeleteSession action (Python: delete_session)

• GetSession action (Python: get_session)

• ListSessions action (Python: list_sessions)

• RunStatement action (Python: run_statement)

• CancelStatement action (Python: cancel_statement)

• GetStatement action (Python: get_statement)

• ListStatements action (Python: list_statements)

Request

Request to create a new session.

• Id – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the session request.

• Description – Description string, not more than 2048 bytes long, matching the URI address multi-line string pattern.

  The description of the session.

• Role – Required: UTF-8 string, not less than 20 or more than 2048 bytes long, matching the Custom string pattern #30.

  The IAM Role ARN

• Command – Required: A SessionCommand object.

  The SessionCommand that runs the job.

• Timeout – Number (integer), at least 1.

  The number of minutes before session times out. Default for Spark ETL jobs is 48 hours (2880 minutes), the maximum session lifetime for this job type. Consult the documentation for other job types.

• IdleTimeout – Number (integer), at least 1.

  The number of minutes when idle before session times out. Default for Spark ETL jobs is value of Timeout. Consult the documentation for other job types.

• DefaultArguments – A map array of key-value pairs, not more than 75 pairs.

  Each key is a UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  Each value is a UTF-8 string, not more than 4096 bytes long, matching the URI address multi-line string pattern.

  A map array of key-value pairs. Max is 75 pairs.

• Connections – A ConnectionsList object.

  The number of connections to use for the session.

• MaxCapacity – Number (double).

  The number of AWS Glue data processing units (DPUs) that can be allocated when the job runs. A DPU is a relative measure of processing power that consists of 4 vCPUs of compute capacity and 16 GB memory.

• NumberOfWorkers – Number (integer).

  The number of workers of a defined WorkerType to use for the session.

• WorkerType – UTF-8 string (valid values: Standard="" | G.1X="" | G.2X="" | G.025X="" | G.4X="" | G.8X="" | Z.2X="").

  The type of predefined worker that is allocated when a job runs. Accepts a value of G.1X, G.2X, G.4X, or G.8X for Spark jobs. Accepts the value Z.2X for Ray notebooks.

  • For the G.1X worker type, each worker maps to 1 DPU (4 vCPUs, 16 GB of memory) with 94GB disk, and provides 1 executor per worker. We recommend this worker type for workloads such as data transforms, joins, and queries, to offers a scalable and cost effective way to run most jobs.

  • For the G.2X worker type, each worker maps to 2 DPU (8 vCPUs, 32 GB of memory) with 138GB disk, and provides 1 executor per worker. We recommend this worker type for workloads such as data transforms, joins, and queries, to offers a scalable and cost effective way to run most jobs.

  • For the G.4X worker type, each worker maps to 4 DPU (16 vCPUs, 64 GB of memory) with 256GB disk, and provides 1 executor per worker. We recommend this worker type for jobs whose workloads contain your most demanding transforms, aggregations, joins, and queries. This worker type is available only for AWS Glue version 3.0 or later Spark ETL jobs in the following AWS Regions: US East (Ohio), US East (N. Virginia), US West (Oregon), Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Tokyo), Canada (Central), Europe (Frankfurt), Europe (Ireland), and Europe (Stockholm).

  • For the G.8X worker type, each worker maps to 8 DPU (32 vCPUs, 128 GB of memory) with 512GB disk, and provides 1 executor per worker. We recommend this worker type for jobs whose workloads contain your most demanding transforms, aggregations, joins, and queries. This worker type is available only for AWS Glue version 3.0 or later Spark ETL jobs, in the same AWS Regions as supported for the G.4X worker type.

  • For the Z.2X worker type, each worker maps to 2 M-DPU (8vCPUs, 64 GB of memory) with 128 GB disk, and provides up to 8 Ray workers based on the autoscaler.

• SecurityConfiguration – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the SecurityConfiguration structure to be used with the session

• GlueVersion – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Custom string pattern #47.

  The AWS Glue version determines the versions of Apache Spark and Python that AWS Glue supports. The GlueVersion must be greater than 2.0.

• DataAccessId – UTF-8 string, not less than 1 or more than 36 bytes long.

  The data access ID of the session.

• PartitionId – UTF-8 string, not less than 1 or more than 36 bytes long.

  The partition ID of the session.

• Tags – A map array of key-value pairs, not more than 50 pairs.

  Each key is a UTF-8 string, not less than 1 or more than 128 bytes long.

  Each value is a UTF-8 string, not more than 256 bytes long.

  The map of key value pairs (tags) belonging to the session.

• RequestOrigin – UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  The origin of the request.

• ProfileName – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of an AWS Glue usage profile associated with the session.

Response

• Session – A Session object.

  Returns the session object in the response.

Errors

• AccessDeniedException

• IdempotentParameterMismatchException

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

• ValidationException

• AlreadyExistsException

• ResourceNumberLimitExceededException

Request

• Id – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the session to be stopped.

• RequestOrigin – UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  The origin of the request.

Response

• Id – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Returns the Id of the stopped session.

Errors

• AccessDeniedException

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

• IllegalSessionStateException

• ConcurrentModificationException

Request

• Id – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the session to be deleted.

• RequestOrigin – UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  The name of the origin of the delete session request.

Response

• Id – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Returns the ID of the deleted session.

Errors

• AccessDeniedException

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

• IllegalSessionStateException

• ConcurrentModificationException

Request

• Id – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the session.

• RequestOrigin – UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  The origin of the request.

Response

• Session – A Session object.

  The session object is returned in the response.

Errors

• AccessDeniedException

• EntityNotFoundException

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

Request

• NextToken – UTF-8 string, not more than 400000 bytes long.

  The token for the next set of results, or null if there are no more result.

• MaxResults – Number (integer), not less than 1 or more than 1000.

  The maximum number of results.

• Tags – A map array of key-value pairs, not more than 50 pairs.

  Each key is a UTF-8 string, not less than 1 or more than 128 bytes long.

  Each value is a UTF-8 string, not more than 256 bytes long.

  Tags belonging to the session.

• RequestOrigin – UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  The origin of the request.

Response

• Ids – An array of UTF-8 strings.

  Returns the ID of the session.

• Sessions – An array of Session objects.

  Returns the session object.

• NextToken – UTF-8 string, not more than 400000 bytes long.

  The token for the next set of results, or null if there are no more result.

Errors

• AccessDeniedException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

Request

• SessionId – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The Session Id of the statement to be run.

• Code – Required: UTF-8 string, not more than 68000 bytes long.

  The statement code to be run.

• RequestOrigin – UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  The origin of the request.

Response

• Id – Number (integer).

  Returns the Id of the statement that was run.

Errors

• EntityNotFoundException

• AccessDeniedException

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

• ValidationException

• ResourceNumberLimitExceededException

• IllegalSessionStateException

Request

• SessionId – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The Session ID of the statement to be cancelled.

• Id – Required: Number (integer).

  The ID of the statement to be cancelled.

• RequestOrigin – UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  The origin of the request to cancel the statement.

Response

• No Response parameters.

Errors

• AccessDeniedException

• EntityNotFoundException

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

• IllegalSessionStateException

Request

• SessionId – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The Session ID of the statement.

• Id – Required: Number (integer).

  The Id of the statement.

• RequestOrigin – UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  The origin of the request.

Response

• Statement – A Statement object.

  Returns the statement.

Errors

• AccessDeniedException

• EntityNotFoundException

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

• IllegalSessionStateException

Request

• SessionId – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The Session ID of the statements.

• RequestOrigin – UTF-8 string, not less than 1 or more than 128 bytes long, matching the Custom string pattern #31.

  The origin of the request to list statements.

• NextToken – UTF-8 string, not more than 400000 bytes long.

  A continuation token, if this is a continuation call.

Response

• Statements – An array of Statement objects.

  Returns the list of statements.

• NextToken – UTF-8 string, not more than 400000 bytes long.

  A continuation token, if not all statements have yet been returned.

Errors

• AccessDeniedException

• EntityNotFoundException

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

• IllegalSessionStateException