BatchGetPreparedStatement - Amazon Athena
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

BatchGetPreparedStatement

Returns the details of a single prepared statement or a list of up to 256 prepared statements for the array of prepared statement names that you provide. Requires you to have access to the workgroup to which the prepared statements belong. If a prepared statement cannot be retrieved for the name specified, the statement is listed in UnprocessedPreparedStatementNames.

Request Syntax

{ "PreparedStatementNames": [ "string" ], "WorkGroup": "string" }

Request Parameters

For information about the parameters that are common to all actions, see Common Parameters.

The request accepts the following data in JSON format.

PreparedStatementNames

A list of prepared statement names to return.

Type: Array of strings

Length Constraints: Minimum length of 1. Maximum length of 256.

Pattern: [a-zA-Z_][a-zA-Z0-9_@:]{1,256}

Required: Yes

WorkGroup

The name of the workgroup to which the prepared statements belong.

Type: String

Pattern: [a-zA-Z0-9._-]{1,128}

Required: Yes

Response Syntax

{ "PreparedStatements": [ { "Description": "string", "LastModifiedTime": number, "QueryStatement": "string", "StatementName": "string", "WorkGroupName": "string" } ], "UnprocessedPreparedStatementNames": [ { "ErrorCode": "string", "ErrorMessage": "string", "StatementName": "string" } ] }

Response Elements

If the action is successful, the service sends back an HTTP 200 response.

The following data is returned in JSON format by the service.

PreparedStatements

The list of prepared statements returned.

Type: Array of PreparedStatement objects

UnprocessedPreparedStatementNames

A list of one or more prepared statements that were requested but could not be returned.

Type: Array of UnprocessedPreparedStatementName objects

Errors

For information about the errors that are common to all actions, see Common Errors.

InternalServerException

Indicates a platform issue, which may be due to a transient condition or outage.

HTTP Status Code: 500

InvalidRequestException

Indicates that something is wrong with the input to the request. For example, a required parameter may be missing or out of range.

HTTP Status Code: 400

See Also

For more information about using this API in one of the language-specific Amazon SDKs, see the following: