@ThreadSafe @Generated(value="com.amazonaws:aws-java-sdk-code-generator") public class AmazonAthenaClient extends AmazonWebServiceClient implements AmazonAthena
Amazon Athena is an interactive query service that lets you use standard SQL to analyze data directly in Amazon S3. You can point Athena at your data in Amazon S3 and run ad-hoc queries and get results in seconds. Athena is serverless, so there is no infrastructure to set up or manage. You pay only for the queries you run. Athena scales automatically—executing queries in parallel—so results are fast, even with large datasets and complex queries. For more information, see What is Amazon Athena in the Amazon Athena User Guide.
If you connect to Athena using the JDBC driver, use version 1.1.0 of the driver or later with the Amazon Athena API. Earlier version drivers do not support the API. For more information and to download the driver, see Accessing Amazon Athena with JDBC.
LOGGING_AWS_REQUEST_METRIC
ENDPOINT_PREFIX
Modifier and Type | Method and Description |
---|---|
BatchGetNamedQueryResult |
batchGetNamedQuery(BatchGetNamedQueryRequest request)
Returns the details of a single named query or a list of up to 50 queries, which you provide as an array of query
ID strings.
|
BatchGetPreparedStatementResult |
batchGetPreparedStatement(BatchGetPreparedStatementRequest request)
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.
|
BatchGetQueryExecutionResult |
batchGetQueryExecution(BatchGetQueryExecutionRequest request)
Returns the details of a single query execution or a list of up to 50 query executions, which you provide as an
array of query execution ID strings.
|
static AmazonAthenaClientBuilder |
builder() |
CancelCapacityReservationResult |
cancelCapacityReservation(CancelCapacityReservationRequest request)
Cancels the capacity reservation with the specified name.
|
CreateCapacityReservationResult |
createCapacityReservation(CreateCapacityReservationRequest request)
Creates a capacity reservation with the specified name and number of requested data processing units.
|
CreateDataCatalogResult |
createDataCatalog(CreateDataCatalogRequest request)
Creates (registers) a data catalog with the specified name and properties.
|
CreateNamedQueryResult |
createNamedQuery(CreateNamedQueryRequest request)
Creates a named query in the specified workgroup.
|
CreateNotebookResult |
createNotebook(CreateNotebookRequest request)
Creates an empty
ipynb file in the specified Apache Spark enabled workgroup. |
CreatePreparedStatementResult |
createPreparedStatement(CreatePreparedStatementRequest request)
Creates a prepared statement for use with SQL queries in Athena.
|
CreatePresignedNotebookUrlResult |
createPresignedNotebookUrl(CreatePresignedNotebookUrlRequest request)
Gets an authentication token and the URL at which the notebook can be accessed.
|
CreateWorkGroupResult |
createWorkGroup(CreateWorkGroupRequest request)
Creates a workgroup with the specified name.
|
DeleteCapacityReservationResult |
deleteCapacityReservation(DeleteCapacityReservationRequest request)
Deletes a cancelled capacity reservation.
|
DeleteDataCatalogResult |
deleteDataCatalog(DeleteDataCatalogRequest request)
Deletes a data catalog.
|
DeleteNamedQueryResult |
deleteNamedQuery(DeleteNamedQueryRequest request)
Deletes the named query if you have access to the workgroup in which the query was saved.
|
DeleteNotebookResult |
deleteNotebook(DeleteNotebookRequest request)
Deletes the specified notebook.
|
DeletePreparedStatementResult |
deletePreparedStatement(DeletePreparedStatementRequest request)
Deletes the prepared statement with the specified name from the specified workgroup.
|
DeleteWorkGroupResult |
deleteWorkGroup(DeleteWorkGroupRequest request)
Deletes the workgroup with the specified name.
|
ExportNotebookResult |
exportNotebook(ExportNotebookRequest request)
Exports the specified notebook and its metadata.
|
ResponseMetadata |
getCachedResponseMetadata(AmazonWebServiceRequest request)
Returns additional metadata for a previously executed successful, request, typically used for debugging issues
where a service isn't acting as expected.
|
GetCalculationExecutionResult |
getCalculationExecution(GetCalculationExecutionRequest request)
Describes a previously submitted calculation execution.
|
GetCalculationExecutionCodeResult |
getCalculationExecutionCode(GetCalculationExecutionCodeRequest request)
Retrieves the unencrypted code that was executed for the calculation.
|
GetCalculationExecutionStatusResult |
getCalculationExecutionStatus(GetCalculationExecutionStatusRequest request)
Gets the status of a current calculation.
|
GetCapacityAssignmentConfigurationResult |
getCapacityAssignmentConfiguration(GetCapacityAssignmentConfigurationRequest request)
Gets the capacity assignment configuration for a capacity reservation, if one exists.
|
GetCapacityReservationResult |
getCapacityReservation(GetCapacityReservationRequest request)
Returns information about the capacity reservation with the specified name.
|
GetDatabaseResult |
getDatabase(GetDatabaseRequest request)
Returns a database object for the specified database and data catalog.
|
GetDataCatalogResult |
getDataCatalog(GetDataCatalogRequest request)
Returns the specified data catalog.
|
GetNamedQueryResult |
getNamedQuery(GetNamedQueryRequest request)
Returns information about a single query.
|
GetNotebookMetadataResult |
getNotebookMetadata(GetNotebookMetadataRequest request)
Retrieves notebook metadata for the specified notebook ID.
|
GetPreparedStatementResult |
getPreparedStatement(GetPreparedStatementRequest request)
Retrieves the prepared statement with the specified name from the specified workgroup.
|
GetQueryExecutionResult |
getQueryExecution(GetQueryExecutionRequest request)
Returns information about a single execution of a query if you have access to the workgroup in which the query
ran.
|
GetQueryResultsResult |
getQueryResults(GetQueryResultsRequest request)
Streams the results of a single query execution specified by
QueryExecutionId from the Athena query
results location in Amazon S3. |
GetQueryRuntimeStatisticsResult |
getQueryRuntimeStatistics(GetQueryRuntimeStatisticsRequest request)
Returns query execution runtime statistics related to a single execution of a query if you have access to the
workgroup in which the query ran.
|
GetSessionResult |
getSession(GetSessionRequest request)
Gets the full details of a previously created session, including the session status and configuration.
|
GetSessionStatusResult |
getSessionStatus(GetSessionStatusRequest request)
Gets the current status of a session.
|
GetTableMetadataResult |
getTableMetadata(GetTableMetadataRequest request)
Returns table metadata for the specified catalog, database, and table.
|
GetWorkGroupResult |
getWorkGroup(GetWorkGroupRequest request)
Returns information about the workgroup with the specified name.
|
ImportNotebookResult |
importNotebook(ImportNotebookRequest request)
Imports a single
ipynb file to a Spark enabled workgroup. |
ListApplicationDPUSizesResult |
listApplicationDPUSizes(ListApplicationDPUSizesRequest request)
Returns the supported DPU sizes for the supported application runtimes (for example,
Athena notebook version 1 ). |
ListCalculationExecutionsResult |
listCalculationExecutions(ListCalculationExecutionsRequest request)
Lists the calculations that have been submitted to a session in descending order.
|
ListCapacityReservationsResult |
listCapacityReservations(ListCapacityReservationsRequest request)
Lists the capacity reservations for the current account.
|
ListDatabasesResult |
listDatabases(ListDatabasesRequest request)
Lists the databases in the specified data catalog.
|
ListDataCatalogsResult |
listDataCatalogs(ListDataCatalogsRequest request)
Lists the data catalogs in the current Amazon Web Services account.
|
ListEngineVersionsResult |
listEngineVersions(ListEngineVersionsRequest request)
Returns a list of engine versions that are available to choose from, including the Auto option.
|
ListExecutorsResult |
listExecutors(ListExecutorsRequest request)
Lists, in descending order, the executors that joined a session.
|
ListNamedQueriesResult |
listNamedQueries(ListNamedQueriesRequest request)
Provides a list of available query IDs only for queries saved in the specified workgroup.
|
ListNotebookMetadataResult |
listNotebookMetadata(ListNotebookMetadataRequest request)
Displays the notebook files for the specified workgroup in paginated format.
|
ListNotebookSessionsResult |
listNotebookSessions(ListNotebookSessionsRequest request)
Lists, in descending order, the sessions that have been created in a notebook that are in an active state like
CREATING , CREATED , IDLE or BUSY . |
ListPreparedStatementsResult |
listPreparedStatements(ListPreparedStatementsRequest request)
Lists the prepared statements in the specified workgroup.
|
ListQueryExecutionsResult |
listQueryExecutions(ListQueryExecutionsRequest request)
Provides a list of available query execution IDs for the queries in the specified workgroup.
|
ListSessionsResult |
listSessions(ListSessionsRequest request)
Lists the sessions in a workgroup that are in an active state like
CREATING , CREATED ,
IDLE , or BUSY . |
ListTableMetadataResult |
listTableMetadata(ListTableMetadataRequest request)
Lists the metadata for the tables in the specified data catalog database.
|
ListTagsForResourceResult |
listTagsForResource(ListTagsForResourceRequest request)
Lists the tags associated with an Athena resource.
|
ListWorkGroupsResult |
listWorkGroups(ListWorkGroupsRequest request)
Lists available workgroups for the account.
|
PutCapacityAssignmentConfigurationResult |
putCapacityAssignmentConfiguration(PutCapacityAssignmentConfigurationRequest request)
Puts a new capacity assignment configuration for a specified capacity reservation.
|
void |
shutdown()
Shuts down this client object, releasing any resources that might be held
open.
|
StartCalculationExecutionResult |
startCalculationExecution(StartCalculationExecutionRequest request)
Submits calculations for execution within a session.
|
StartQueryExecutionResult |
startQueryExecution(StartQueryExecutionRequest request)
Runs the SQL query statements contained in the
Query . |
StartSessionResult |
startSession(StartSessionRequest request)
Creates a session for running calculations within a workgroup.
|
StopCalculationExecutionResult |
stopCalculationExecution(StopCalculationExecutionRequest request)
Requests the cancellation of a calculation.
|
StopQueryExecutionResult |
stopQueryExecution(StopQueryExecutionRequest request)
Stops a query execution.
|
TagResourceResult |
tagResource(TagResourceRequest request)
Adds one or more tags to an Athena resource.
|
TerminateSessionResult |
terminateSession(TerminateSessionRequest request)
Terminates an active session.
|
UntagResourceResult |
untagResource(UntagResourceRequest request)
Removes one or more tags from an Athena resource.
|
UpdateCapacityReservationResult |
updateCapacityReservation(UpdateCapacityReservationRequest request)
Updates the number of requested data processing units for the capacity reservation with the specified name.
|
UpdateDataCatalogResult |
updateDataCatalog(UpdateDataCatalogRequest request)
Updates the data catalog that has the specified name.
|
UpdateNamedQueryResult |
updateNamedQuery(UpdateNamedQueryRequest request)
Updates a NamedQuery object.
|
UpdateNotebookResult |
updateNotebook(UpdateNotebookRequest request)
Updates the contents of a Spark notebook.
|
UpdateNotebookMetadataResult |
updateNotebookMetadata(UpdateNotebookMetadataRequest request)
Updates the metadata for a notebook.
|
UpdatePreparedStatementResult |
updatePreparedStatement(UpdatePreparedStatementRequest request)
Updates a prepared statement.
|
UpdateWorkGroupResult |
updateWorkGroup(UpdateWorkGroupRequest request)
Updates the workgroup with the specified name.
|
addRequestHandler, addRequestHandler, configureRegion, getClientConfiguration, getEndpointPrefix, getMonitoringListeners, getRequestMetricsCollector, getServiceName, getSignerByURI, getSignerOverride, getSignerRegionOverride, getTimeOffset, makeImmutable, removeRequestHandler, removeRequestHandler, setEndpoint, setEndpoint, setRegion, setServiceNameIntern, setSignerRegionOverride, setTimeOffset, withEndpoint, withRegion, withRegion, withTimeOffset
public static AmazonAthenaClientBuilder builder()
public BatchGetNamedQueryResult batchGetNamedQuery(BatchGetNamedQueryRequest request)
Returns the details of a single named query or a list of up to 50 queries, which you provide as an array of query ID strings. Requires you to have access to the workgroup in which the queries were saved. Use ListNamedQueriesInput to get the list of named query IDs in the specified workgroup. If information could not be retrieved for a submitted query ID, information about the query ID submitted is listed under UnprocessedNamedQueryId. Named queries differ from executed queries. Use BatchGetQueryExecutionInput to get details about each unique query execution, and ListQueryExecutionsInput to get a list of query execution IDs.
batchGetNamedQuery
in interface AmazonAthena
batchGetNamedQueryRequest
- Contains an array of named query IDs.InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public BatchGetPreparedStatementResult batchGetPreparedStatement(BatchGetPreparedStatementRequest request)
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
.
batchGetPreparedStatement
in interface AmazonAthena
batchGetPreparedStatementRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public BatchGetQueryExecutionResult batchGetQueryExecution(BatchGetQueryExecutionRequest request)
Returns the details of a single query execution or a list of up to 50 query executions, which you provide as an array of query execution ID strings. Requires you to have access to the workgroup in which the queries ran. To get a list of query execution IDs, use ListQueryExecutionsInput$WorkGroup. Query executions differ from named (saved) queries. Use BatchGetNamedQueryInput to get details about named queries.
batchGetQueryExecution
in interface AmazonAthena
batchGetQueryExecutionRequest
- Contains an array of query execution IDs.InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public CancelCapacityReservationResult cancelCapacityReservation(CancelCapacityReservationRequest request)
Cancels the capacity reservation with the specified name. Cancelled reservations remain in your account and will be deleted 45 days after cancellation. During the 45 days, you cannot re-purpose or reuse a reservation that has been cancelled, but you can refer to its tags and view it for historical reference.
cancelCapacityReservation
in interface AmazonAthena
cancelCapacityReservationRequest
- InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.public CreateCapacityReservationResult createCapacityReservation(CreateCapacityReservationRequest request)
Creates a capacity reservation with the specified name and number of requested data processing units.
createCapacityReservation
in interface AmazonAthena
createCapacityReservationRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public CreateDataCatalogResult createDataCatalog(CreateDataCatalogRequest request)
Creates (registers) a data catalog with the specified name and properties. Catalogs created are visible to all users of the same Amazon Web Services account.
createDataCatalog
in interface AmazonAthena
createDataCatalogRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public CreateNamedQueryResult createNamedQuery(CreateNamedQueryRequest request)
Creates a named query in the specified workgroup. Requires that you have access to the workgroup.
createNamedQuery
in interface AmazonAthena
createNamedQueryRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public CreateNotebookResult createNotebook(CreateNotebookRequest request)
Creates an empty ipynb
file in the specified Apache Spark enabled workgroup. Throws an error if a
file in the workgroup with the same name already exists.
createNotebook
in interface AmazonAthena
createNotebookRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public CreatePreparedStatementResult createPreparedStatement(CreatePreparedStatementRequest request)
Creates a prepared statement for use with SQL queries in Athena.
createPreparedStatement
in interface AmazonAthena
createPreparedStatementRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public CreatePresignedNotebookUrlResult createPresignedNotebookUrl(CreatePresignedNotebookUrlRequest request)
Gets an authentication token and the URL at which the notebook can be accessed. During programmatic access,
CreatePresignedNotebookUrl
must be called every 10 minutes to refresh the authentication token. For
information about granting programmatic access, see Grant
programmatic access.
createPresignedNotebookUrl
in interface AmazonAthena
createPresignedNotebookUrlRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public CreateWorkGroupResult createWorkGroup(CreateWorkGroupRequest request)
Creates a workgroup with the specified name. A workgroup can be an Apache Spark enabled workgroup or an Athena SQL workgroup.
createWorkGroup
in interface AmazonAthena
createWorkGroupRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public DeleteCapacityReservationResult deleteCapacityReservation(DeleteCapacityReservationRequest request)
Deletes a cancelled capacity reservation. A reservation must be cancelled before it can be deleted. A deleted
reservation is immediately removed from your account and can no longer be referenced, including by its ARN. A
deleted reservation cannot be called by GetCapacityReservation
, and deleted reservations do not
appear in the output of ListCapacityReservations
.
deleteCapacityReservation
in interface AmazonAthena
deleteCapacityReservationRequest
- InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.public DeleteDataCatalogResult deleteDataCatalog(DeleteDataCatalogRequest request)
Deletes a data catalog.
deleteDataCatalog
in interface AmazonAthena
deleteDataCatalogRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public DeleteNamedQueryResult deleteNamedQuery(DeleteNamedQueryRequest request)
Deletes the named query if you have access to the workgroup in which the query was saved.
deleteNamedQuery
in interface AmazonAthena
deleteNamedQueryRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public DeleteNotebookResult deleteNotebook(DeleteNotebookRequest request)
Deletes the specified notebook.
deleteNotebook
in interface AmazonAthena
deleteNotebookRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public DeletePreparedStatementResult deletePreparedStatement(DeletePreparedStatementRequest request)
Deletes the prepared statement with the specified name from the specified workgroup.
deletePreparedStatement
in interface AmazonAthena
deletePreparedStatementRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public DeleteWorkGroupResult deleteWorkGroup(DeleteWorkGroupRequest request)
Deletes the workgroup with the specified name. The primary workgroup cannot be deleted.
deleteWorkGroup
in interface AmazonAthena
deleteWorkGroupRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public ExportNotebookResult exportNotebook(ExportNotebookRequest request)
Exports the specified notebook and its metadata.
exportNotebook
in interface AmazonAthena
exportNotebookRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public GetCalculationExecutionResult getCalculationExecution(GetCalculationExecutionRequest request)
Describes a previously submitted calculation execution.
getCalculationExecution
in interface AmazonAthena
getCalculationExecutionRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public GetCalculationExecutionCodeResult getCalculationExecutionCode(GetCalculationExecutionCodeRequest request)
Retrieves the unencrypted code that was executed for the calculation.
getCalculationExecutionCode
in interface AmazonAthena
getCalculationExecutionCodeRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public GetCalculationExecutionStatusResult getCalculationExecutionStatus(GetCalculationExecutionStatusRequest request)
Gets the status of a current calculation.
getCalculationExecutionStatus
in interface AmazonAthena
getCalculationExecutionStatusRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public GetCapacityAssignmentConfigurationResult getCapacityAssignmentConfiguration(GetCapacityAssignmentConfigurationRequest request)
Gets the capacity assignment configuration for a capacity reservation, if one exists.
getCapacityAssignmentConfiguration
in interface AmazonAthena
getCapacityAssignmentConfigurationRequest
- InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.public GetCapacityReservationResult getCapacityReservation(GetCapacityReservationRequest request)
Returns information about the capacity reservation with the specified name.
getCapacityReservation
in interface AmazonAthena
getCapacityReservationRequest
- InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.public GetDataCatalogResult getDataCatalog(GetDataCatalogRequest request)
Returns the specified data catalog.
getDataCatalog
in interface AmazonAthena
getDataCatalogRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public GetDatabaseResult getDatabase(GetDatabaseRequest request)
Returns a database object for the specified database and data catalog.
getDatabase
in interface AmazonAthena
getDatabaseRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.MetadataException
- An exception that Athena received when it called a custom metastore. Occurs if the error is not caused by
user input (InvalidRequestException
) or from the Athena platform (
InternalServerException
). For example, if a user-created Lambda function is missing
permissions, the Lambda 4XX
exception is returned in a MetadataException
.public GetNamedQueryResult getNamedQuery(GetNamedQueryRequest request)
Returns information about a single query. Requires that you have access to the workgroup in which the query was saved.
getNamedQuery
in interface AmazonAthena
getNamedQueryRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public GetNotebookMetadataResult getNotebookMetadata(GetNotebookMetadataRequest request)
Retrieves notebook metadata for the specified notebook ID.
getNotebookMetadata
in interface AmazonAthena
getNotebookMetadataRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public GetPreparedStatementResult getPreparedStatement(GetPreparedStatementRequest request)
Retrieves the prepared statement with the specified name from the specified workgroup.
getPreparedStatement
in interface AmazonAthena
getPreparedStatementRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public GetQueryExecutionResult getQueryExecution(GetQueryExecutionRequest request)
Returns information about a single execution of a query if you have access to the workgroup in which the query ran. Each time a query executes, information about the query execution is saved with a unique ID.
getQueryExecution
in interface AmazonAthena
getQueryExecutionRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public GetQueryResultsResult getQueryResults(GetQueryResultsRequest request)
Streams the results of a single query execution specified by QueryExecutionId
from the Athena query
results location in Amazon S3. For more information, see Working with query results, recent queries, and
output files in the Amazon Athena User Guide. This request does not execute the query but returns
results. Use StartQueryExecution to run a query.
To stream query results successfully, the IAM principal with permission to call GetQueryResults
also
must have permissions to the Amazon S3 GetObject
action for the Athena query results location.
IAM principals with permission to the Amazon S3 GetObject
action for the query results location are
able to retrieve query results from Amazon S3 even if permission to the GetQueryResults
action is
denied. To restrict user or role access, ensure that Amazon S3 permissions to the Athena query location are
denied.
getQueryResults
in interface AmazonAthena
getQueryResultsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public GetQueryRuntimeStatisticsResult getQueryRuntimeStatistics(GetQueryRuntimeStatisticsRequest request)
Returns query execution runtime statistics related to a single execution of a query if you have access to the
workgroup in which the query ran. Statistics from the Timeline
section of the response object are
available as soon as QueryExecutionStatus$State is in a SUCCEEDED or FAILED state. The remaining
non-timeline statistics in the response (like stage-level input and output row count and data size) are updated
asynchronously and may not be available immediately after a query completes. The non-timeline statistics are also
not included when a query has row-level filters defined in Lake Formation.
getQueryRuntimeStatistics
in interface AmazonAthena
getQueryRuntimeStatisticsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public GetSessionResult getSession(GetSessionRequest request)
Gets the full details of a previously created session, including the session status and configuration.
getSession
in interface AmazonAthena
getSessionRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public GetSessionStatusResult getSessionStatus(GetSessionStatusRequest request)
Gets the current status of a session.
getSessionStatus
in interface AmazonAthena
getSessionStatusRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public GetTableMetadataResult getTableMetadata(GetTableMetadataRequest request)
Returns table metadata for the specified catalog, database, and table.
getTableMetadata
in interface AmazonAthena
getTableMetadataRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.MetadataException
- An exception that Athena received when it called a custom metastore. Occurs if the error is not caused by
user input (InvalidRequestException
) or from the Athena platform (
InternalServerException
). For example, if a user-created Lambda function is missing
permissions, the Lambda 4XX
exception is returned in a MetadataException
.public GetWorkGroupResult getWorkGroup(GetWorkGroupRequest request)
Returns information about the workgroup with the specified name.
getWorkGroup
in interface AmazonAthena
getWorkGroupRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public ImportNotebookResult importNotebook(ImportNotebookRequest request)
Imports a single ipynb
file to a Spark enabled workgroup. To import the notebook, the request must
specify a value for either Payload
or NoteBookS3LocationUri
. If neither is specified or
both are specified, an InvalidRequestException
occurs. The maximum file size that can be imported is
10 megabytes. If an ipynb
file with the same name already exists in the workgroup, throws an error.
importNotebook
in interface AmazonAthena
importNotebookRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public ListApplicationDPUSizesResult listApplicationDPUSizes(ListApplicationDPUSizesRequest request)
Returns the supported DPU sizes for the supported application runtimes (for example,
Athena notebook version 1
).
listApplicationDPUSizes
in interface AmazonAthena
listApplicationDPUSizesRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public ListCalculationExecutionsResult listCalculationExecutions(ListCalculationExecutionsRequest request)
Lists the calculations that have been submitted to a session in descending order. Newer calculations are listed first; older calculations are listed later.
listCalculationExecutions
in interface AmazonAthena
listCalculationExecutionsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public ListCapacityReservationsResult listCapacityReservations(ListCapacityReservationsRequest request)
Lists the capacity reservations for the current account.
listCapacityReservations
in interface AmazonAthena
listCapacityReservationsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public ListDataCatalogsResult listDataCatalogs(ListDataCatalogsRequest request)
Lists the data catalogs in the current Amazon Web Services account.
In the Athena console, data catalogs are listed as "data sources" on the Data sources page under the Data source name column.
listDataCatalogs
in interface AmazonAthena
listDataCatalogsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public ListDatabasesResult listDatabases(ListDatabasesRequest request)
Lists the databases in the specified data catalog.
listDatabases
in interface AmazonAthena
listDatabasesRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.MetadataException
- An exception that Athena received when it called a custom metastore. Occurs if the error is not caused by
user input (InvalidRequestException
) or from the Athena platform (
InternalServerException
). For example, if a user-created Lambda function is missing
permissions, the Lambda 4XX
exception is returned in a MetadataException
.public ListEngineVersionsResult listEngineVersions(ListEngineVersionsRequest request)
Returns a list of engine versions that are available to choose from, including the Auto option.
listEngineVersions
in interface AmazonAthena
listEngineVersionsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public ListExecutorsResult listExecutors(ListExecutorsRequest request)
Lists, in descending order, the executors that joined a session. Newer executors are listed first; older executors are listed later. The result can be optionally filtered by state.
listExecutors
in interface AmazonAthena
listExecutorsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public ListNamedQueriesResult listNamedQueries(ListNamedQueriesRequest request)
Provides a list of available query IDs only for queries saved in the specified workgroup. Requires that you have access to the specified workgroup. If a workgroup is not specified, lists the saved queries for the primary workgroup.
listNamedQueries
in interface AmazonAthena
listNamedQueriesRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public ListNotebookMetadataResult listNotebookMetadata(ListNotebookMetadataRequest request)
Displays the notebook files for the specified workgroup in paginated format.
listNotebookMetadata
in interface AmazonAthena
listNotebookMetadataRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public ListNotebookSessionsResult listNotebookSessions(ListNotebookSessionsRequest request)
Lists, in descending order, the sessions that have been created in a notebook that are in an active state like
CREATING
, CREATED
, IDLE
or BUSY
. Newer sessions are listed
first; older sessions are listed later.
listNotebookSessions
in interface AmazonAthena
listNotebookSessionsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public ListPreparedStatementsResult listPreparedStatements(ListPreparedStatementsRequest request)
Lists the prepared statements in the specified workgroup.
listPreparedStatements
in interface AmazonAthena
listPreparedStatementsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public ListQueryExecutionsResult listQueryExecutions(ListQueryExecutionsRequest request)
Provides a list of available query execution IDs for the queries in the specified workgroup. Athena keeps a query history for 45 days. If a workgroup is not specified, returns a list of query execution IDs for the primary workgroup. Requires you to have access to the workgroup in which the queries ran.
listQueryExecutions
in interface AmazonAthena
listQueryExecutionsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public ListSessionsResult listSessions(ListSessionsRequest request)
Lists the sessions in a workgroup that are in an active state like CREATING
, CREATED
,
IDLE
, or BUSY
. Newer sessions are listed first; older sessions are listed later.
listSessions
in interface AmazonAthena
listSessionsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public ListTableMetadataResult listTableMetadata(ListTableMetadataRequest request)
Lists the metadata for the tables in the specified data catalog database.
listTableMetadata
in interface AmazonAthena
listTableMetadataRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.MetadataException
- An exception that Athena received when it called a custom metastore. Occurs if the error is not caused by
user input (InvalidRequestException
) or from the Athena platform (
InternalServerException
). For example, if a user-created Lambda function is missing
permissions, the Lambda 4XX
exception is returned in a MetadataException
.public ListTagsForResourceResult listTagsForResource(ListTagsForResourceRequest request)
Lists the tags associated with an Athena resource.
listTagsForResource
in interface AmazonAthena
listTagsForResourceRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public ListWorkGroupsResult listWorkGroups(ListWorkGroupsRequest request)
Lists available workgroups for the account.
listWorkGroups
in interface AmazonAthena
listWorkGroupsRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public PutCapacityAssignmentConfigurationResult putCapacityAssignmentConfiguration(PutCapacityAssignmentConfigurationRequest request)
Puts a new capacity assignment configuration for a specified capacity reservation. If a capacity assignment configuration already exists for the capacity reservation, replaces the existing capacity assignment configuration.
putCapacityAssignmentConfiguration
in interface AmazonAthena
putCapacityAssignmentConfigurationRequest
- InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.public StartCalculationExecutionResult startCalculationExecution(StartCalculationExecutionRequest request)
Submits calculations for execution within a session. You can supply the code to run as an inline code block within the request.
The request syntax requires the StartCalculationExecutionRequest$CodeBlock parameter or the CalculationConfiguration$CodeBlock parameter, but not both. Because CalculationConfiguration$CodeBlock is deprecated, use the StartCalculationExecutionRequest$CodeBlock parameter instead.
startCalculationExecution
in interface AmazonAthena
startCalculationExecutionRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public StartQueryExecutionResult startQueryExecution(StartQueryExecutionRequest request)
Runs the SQL query statements contained in the Query
. Requires you to have access to the workgroup
in which the query ran. Running queries against an external catalog requires GetDataCatalog permission to
the catalog. For code samples using the Amazon Web Services SDK for Java, see Examples and Code Samples in the
Amazon Athena User Guide.
startQueryExecution
in interface AmazonAthena
startQueryExecutionRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public StartSessionResult startSession(StartSessionRequest request)
Creates a session for running calculations within a workgroup. The session is ready when it reaches an
IDLE
state.
startSession
in interface AmazonAthena
startSessionRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.SessionAlreadyExistsException
- The specified session already exists.TooManyRequestsException
- Indicates that the request was throttled.public StopCalculationExecutionResult stopCalculationExecution(StopCalculationExecutionRequest request)
Requests the cancellation of a calculation. A StopCalculationExecution
call on a calculation that is
already in a terminal state (for example, STOPPED
, FAILED
, or COMPLETED
)
succeeds but has no effect.
Cancelling a calculation is done on a best effort basis. If a calculation cannot be cancelled, you can be charged for its completion. If you are concerned about being charged for a calculation that cannot be cancelled, consider terminating the session in which the calculation is running.
stopCalculationExecution
in interface AmazonAthena
stopCalculationExecutionRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public StopQueryExecutionResult stopQueryExecution(StopQueryExecutionRequest request)
Stops a query execution. Requires you to have access to the workgroup in which the query ran.
stopQueryExecution
in interface AmazonAthena
stopQueryExecutionRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public TagResourceResult tagResource(TagResourceRequest request)
Adds one or more tags to an Athena resource. A tag is a label that you assign to a resource. Each tag consists of a key and an optional value, both of which you define. For example, you can use tags to categorize Athena workgroups, data catalogs, or capacity reservations by purpose, owner, or environment. Use a consistent set of tag keys to make it easier to search and filter the resources in your account. For best practices, see Tagging Best Practices. Tag keys can be from 1 to 128 UTF-8 Unicode characters, and tag values can be from 0 to 256 UTF-8 Unicode characters. Tags can use letters and numbers representable in UTF-8, and the following characters: + - = . _ : / @. Tag keys and values are case-sensitive. Tag keys must be unique per resource. If you specify more than one tag, separate them by commas.
tagResource
in interface AmazonAthena
tagResourceRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public TerminateSessionResult terminateSession(TerminateSessionRequest request)
Terminates an active session. A TerminateSession
call on a session that is already inactive (for
example, in a FAILED
, TERMINATED
or TERMINATING
state) succeeds but has no
effect. Calculations running in the session when TerminateSession
is called are forcefully stopped,
but may display as FAILED
instead of STOPPED
.
terminateSession
in interface AmazonAthena
terminateSessionRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public UntagResourceResult untagResource(UntagResourceRequest request)
Removes one or more tags from an Athena resource.
untagResource
in interface AmazonAthena
untagResourceRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public UpdateCapacityReservationResult updateCapacityReservation(UpdateCapacityReservationRequest request)
Updates the number of requested data processing units for the capacity reservation with the specified name.
updateCapacityReservation
in interface AmazonAthena
updateCapacityReservationRequest
- InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.public UpdateDataCatalogResult updateDataCatalog(UpdateDataCatalogRequest request)
Updates the data catalog that has the specified name.
updateDataCatalog
in interface AmazonAthena
updateDataCatalogRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public UpdateNamedQueryResult updateNamedQuery(UpdateNamedQueryRequest request)
Updates a NamedQuery object. The database or workgroup cannot be updated.
updateNamedQuery
in interface AmazonAthena
updateNamedQueryRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public UpdateNotebookResult updateNotebook(UpdateNotebookRequest request)
Updates the contents of a Spark notebook.
updateNotebook
in interface AmazonAthena
updateNotebookRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public UpdateNotebookMetadataResult updateNotebookMetadata(UpdateNotebookMetadataRequest request)
Updates the metadata for a notebook.
updateNotebookMetadata
in interface AmazonAthena
updateNotebookMetadataRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.TooManyRequestsException
- Indicates that the request was throttled.public UpdatePreparedStatementResult updatePreparedStatement(UpdatePreparedStatementRequest request)
Updates a prepared statement.
updatePreparedStatement
in interface AmazonAthena
updatePreparedStatementRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.ResourceNotFoundException
- A resource, such as a workgroup, was not found.public UpdateWorkGroupResult updateWorkGroup(UpdateWorkGroupRequest request)
Updates the workgroup with the specified name. The workgroup's name cannot be changed. Only
ConfigurationUpdates
can be specified.
updateWorkGroup
in interface AmazonAthena
updateWorkGroupRequest
- InternalServerException
- Indicates a platform issue, which may be due to a transient condition or outage.InvalidRequestException
- Indicates that something is wrong with the input to the request. For example, a required parameter may be
missing or out of range.public ResponseMetadata getCachedResponseMetadata(AmazonWebServiceRequest request)
Response metadata is only cached for a limited period of time, so if you need to access this extra diagnostic information for an executed request, you should use this method to retrieve it as soon as possible after executing the request.
getCachedResponseMetadata
in interface AmazonAthena
request
- The originally executed requestpublic void shutdown()
AmazonWebServiceClient
shutdown
in interface AmazonAthena
shutdown
in class AmazonWebServiceClient