AmazonAthenaClient Class | AWS SDK for .NET V3

Implementation for accessing Athena

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.

Inheritance Hierarchy

System.Object
Amazon.Runtime.AmazonServiceClient
Amazon.Athena.AmazonAthenaClient

Namespace: Amazon.Athena
Assembly: AWSSDK.Athena.dll
Version: 3.x.y.z

Syntax

public class AmazonAthenaClient : AmazonServiceClient
         IAmazonAthena, IAmazonService, IDisposable

The AmazonAthenaClient type exposes the following members

Constructors

	Name	Description
	AmazonAthenaClient()	Constructs AmazonAthenaClient with the credentials loaded from the application's default configuration, and if unsuccessful from the Instance Profile service on an EC2 instance. Example App.config with credentials set. <?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key="AWSProfileName" value="AWS Default"/> </appSettings> </configuration>
	AmazonAthenaClient(RegionEndpoint)	Constructs AmazonAthenaClient with the credentials loaded from the application's default configuration, and if unsuccessful from the Instance Profile service on an EC2 instance. Example App.config with credentials set. <?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key="AWSProfileName" value="AWS Default"/> </appSettings> </configuration>
	AmazonAthenaClient(AmazonAthenaConfig)	Constructs AmazonAthenaClient with the credentials loaded from the application's default configuration, and if unsuccessful from the Instance Profile service on an EC2 instance. Example App.config with credentials set. <?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key="AWSProfileName" value="AWS Default"/> </appSettings> </configuration>
	AmazonAthenaClient(AWSCredentials)	Constructs AmazonAthenaClient with AWS Credentials
	AmazonAthenaClient(AWSCredentials, RegionEndpoint)	Constructs AmazonAthenaClient with AWS Credentials
	AmazonAthenaClient(AWSCredentials, AmazonAthenaConfig)	Constructs AmazonAthenaClient with AWS Credentials and an AmazonAthenaClient Configuration object.
	AmazonAthenaClient(string, string)	Constructs AmazonAthenaClient with AWS Access Key ID and AWS Secret Key
	AmazonAthenaClient(string, string, RegionEndpoint)	Constructs AmazonAthenaClient with AWS Access Key ID and AWS Secret Key
	AmazonAthenaClient(string, string, AmazonAthenaConfig)	Constructs AmazonAthenaClient with AWS Access Key ID, AWS Secret Key and an AmazonAthenaClient Configuration object.
	AmazonAthenaClient(string, string, string)	Constructs AmazonAthenaClient with AWS Access Key ID and AWS Secret Key
	AmazonAthenaClient(string, string, string, RegionEndpoint)	Constructs AmazonAthenaClient with AWS Access Key ID and AWS Secret Key
	AmazonAthenaClient(string, string, string, AmazonAthenaConfig)	Constructs AmazonAthenaClient with AWS Access Key ID, AWS Secret Key and an AmazonAthenaClient Configuration object.

Properties

	Name	Type	Description
	Config	Amazon.Runtime.IClientConfig	Inherited from Amazon.Runtime.AmazonServiceClient.
	Paginators	Amazon.Athena.Model.IAthenaPaginatorFactory	Paginators for the service

Methods

Note:

Asynchronous operations (methods ending with Async) in the table below are for .NET 4.5 or higher. For .NET 3.5 the SDK follows the standard naming convention of BeginMethodName and EndMethodName to indicate asynchronous operations - these method pairs are not shown in the table below.

	Name	Description
	BatchGetNamedQuery(BatchGetNamedQueryRequest)	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.
	BatchGetNamedQueryAsync(BatchGetNamedQueryRequest, CancellationToken)	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.
	BatchGetPreparedStatement(BatchGetPreparedStatementRequest)	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`.
	BatchGetPreparedStatementAsync(BatchGetPreparedStatementRequest, CancellationToken)	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`.
	BatchGetQueryExecution(BatchGetQueryExecutionRequest)	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.
	BatchGetQueryExecutionAsync(BatchGetQueryExecutionRequest, CancellationToken)	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.
	CancelCapacityReservation(CancelCapacityReservationRequest)	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.
	CancelCapacityReservationAsync(CancelCapacityReservationRequest, CancellationToken)	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.
	CreateCapacityReservation(CreateCapacityReservationRequest)	Creates a capacity reservation with the specified name and number of requested data processing units.
	CreateCapacityReservationAsync(CreateCapacityReservationRequest, CancellationToken)	Creates a capacity reservation with the specified name and number of requested data processing units.
	CreateDataCatalog(CreateDataCatalogRequest)	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. For a `FEDERATED` catalog, this API operation creates the following resources. CFN Stack Name with a maximum length of 128 characters and prefix `athenafederatedcatalog-CATALOG_NAME_SANITIZED` with length 23 characters. Lambda Function Name with a maximum length of 64 characters and prefix `athenafederatedcatalog_CATALOG_NAME_SANITIZED` with length 23 characters. Glue Connection Name with a maximum length of 255 characters and a prefix `athenafederatedcatalog_CATALOG_NAME_SANITIZED` with length 23 characters.
	CreateDataCatalogAsync(CreateDataCatalogRequest, CancellationToken)	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. For a `FEDERATED` catalog, this API operation creates the following resources. CFN Stack Name with a maximum length of 128 characters and prefix `athenafederatedcatalog-CATALOG_NAME_SANITIZED` with length 23 characters. Lambda Function Name with a maximum length of 64 characters and prefix `athenafederatedcatalog_CATALOG_NAME_SANITIZED` with length 23 characters. Glue Connection Name with a maximum length of 255 characters and a prefix `athenafederatedcatalog_CATALOG_NAME_SANITIZED` with length 23 characters.
	CreateNamedQuery(CreateNamedQueryRequest)	Creates a named query in the specified workgroup. Requires that you have access to the workgroup.
	CreateNamedQueryAsync(CreateNamedQueryRequest, CancellationToken)	Creates a named query in the specified workgroup. Requires that you have access to the workgroup.
	CreateNotebook(CreateNotebookRequest)	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.
	CreateNotebookAsync(CreateNotebookRequest, CancellationToken)	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.
	CreatePreparedStatement(CreatePreparedStatementRequest)	Creates a prepared statement for use with SQL queries in Athena.
	CreatePreparedStatementAsync(CreatePreparedStatementRequest, CancellationToken)	Creates a prepared statement for use with SQL queries in Athena.
	CreatePresignedNotebookUrl(CreatePresignedNotebookUrlRequest)	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.
	CreatePresignedNotebookUrlAsync(CreatePresignedNotebookUrlRequest, CancellationToken)	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.
	CreateWorkGroup(CreateWorkGroupRequest)	Creates a workgroup with the specified name. A workgroup can be an Apache Spark enabled workgroup or an Athena SQL workgroup.
	CreateWorkGroupAsync(CreateWorkGroupRequest, CancellationToken)	Creates a workgroup with the specified name. A workgroup can be an Apache Spark enabled workgroup or an Athena SQL workgroup.
	DeleteCapacityReservation(DeleteCapacityReservationRequest)	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`.
	DeleteCapacityReservationAsync(DeleteCapacityReservationRequest, CancellationToken)	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`.
	DeleteDataCatalog(DeleteDataCatalogRequest)	Deletes a data catalog.
	DeleteDataCatalogAsync(DeleteDataCatalogRequest, CancellationToken)	Deletes a data catalog.
	DeleteNamedQuery(DeleteNamedQueryRequest)	Deletes the named query if you have access to the workgroup in which the query was saved.
	DeleteNamedQueryAsync(DeleteNamedQueryRequest, CancellationToken)	Deletes the named query if you have access to the workgroup in which the query was saved.
	DeleteNotebook(DeleteNotebookRequest)	Deletes the specified notebook.
	DeleteNotebookAsync(DeleteNotebookRequest, CancellationToken)	Deletes the specified notebook.
	DeletePreparedStatement(DeletePreparedStatementRequest)	Deletes the prepared statement with the specified name from the specified workgroup.
	DeletePreparedStatementAsync(DeletePreparedStatementRequest, CancellationToken)	Deletes the prepared statement with the specified name from the specified workgroup.
	DeleteWorkGroup(DeleteWorkGroupRequest)	Deletes the workgroup with the specified name. The primary workgroup cannot be deleted.
	DeleteWorkGroupAsync(DeleteWorkGroupRequest, CancellationToken)	Deletes the workgroup with the specified name. The primary workgroup cannot be deleted.
	DetermineServiceOperationEndpoint(AmazonWebServiceRequest)	Returns the endpoint that will be used for a particular request.
	Dispose()	Inherited from Amazon.Runtime.AmazonServiceClient.
	ExportNotebook(ExportNotebookRequest)	Exports the specified notebook and its metadata.
	ExportNotebookAsync(ExportNotebookRequest, CancellationToken)	Exports the specified notebook and its metadata.
	GetCalculationExecution(GetCalculationExecutionRequest)	Describes a previously submitted calculation execution.
	GetCalculationExecutionAsync(GetCalculationExecutionRequest, CancellationToken)	Describes a previously submitted calculation execution.
	GetCalculationExecutionCode(GetCalculationExecutionCodeRequest)	Retrieves the unencrypted code that was executed for the calculation.
	GetCalculationExecutionCodeAsync(GetCalculationExecutionCodeRequest, CancellationToken)	Retrieves the unencrypted code that was executed for the calculation.
	GetCalculationExecutionStatus(GetCalculationExecutionStatusRequest)	Gets the status of a current calculation.
	GetCalculationExecutionStatusAsync(GetCalculationExecutionStatusRequest, CancellationToken)	Gets the status of a current calculation.
	GetCapacityAssignmentConfiguration(GetCapacityAssignmentConfigurationRequest)	Gets the capacity assignment configuration for a capacity reservation, if one exists.
	GetCapacityAssignmentConfigurationAsync(GetCapacityAssignmentConfigurationRequest, CancellationToken)	Gets the capacity assignment configuration for a capacity reservation, if one exists.
	GetCapacityReservation(GetCapacityReservationRequest)	Returns information about the capacity reservation with the specified name.
	GetCapacityReservationAsync(GetCapacityReservationRequest, CancellationToken)	Returns information about the capacity reservation with the specified name.
	GetDatabase(GetDatabaseRequest)	Returns a database object for the specified database and data catalog.
	GetDatabaseAsync(GetDatabaseRequest, CancellationToken)	Returns a database object for the specified database and data catalog.
	GetDataCatalog(GetDataCatalogRequest)	Returns the specified data catalog.
	GetDataCatalogAsync(GetDataCatalogRequest, CancellationToken)	Returns the specified data catalog.
	GetNamedQuery(GetNamedQueryRequest)	Returns information about a single query. Requires that you have access to the workgroup in which the query was saved.
	GetNamedQueryAsync(GetNamedQueryRequest, CancellationToken)	Returns information about a single query. Requires that you have access to the workgroup in which the query was saved.
	GetNotebookMetadata(GetNotebookMetadataRequest)	Retrieves notebook metadata for the specified notebook ID.
	GetNotebookMetadataAsync(GetNotebookMetadataRequest, CancellationToken)	Retrieves notebook metadata for the specified notebook ID.
	GetPreparedStatement(GetPreparedStatementRequest)	Retrieves the prepared statement with the specified name from the specified workgroup.
	GetPreparedStatementAsync(GetPreparedStatementRequest, CancellationToken)	Retrieves the prepared statement with the specified name from the specified workgroup.
	GetQueryExecution(GetQueryExecutionRequest)	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.
	GetQueryExecutionAsync(GetQueryExecutionRequest, CancellationToken)	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.
	GetQueryResults(GetQueryResultsRequest)	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.
	GetQueryResultsAsync(GetQueryResultsRequest, CancellationToken)	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.
	GetQueryRuntimeStatistics(GetQueryRuntimeStatisticsRequest)	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.
	GetQueryRuntimeStatisticsAsync(GetQueryRuntimeStatisticsRequest, CancellationToken)	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.
	GetSession(GetSessionRequest)	Gets the full details of a previously created session, including the session status and configuration.
	GetSessionAsync(GetSessionRequest, CancellationToken)	Gets the full details of a previously created session, including the session status and configuration.
	GetSessionStatus(GetSessionStatusRequest)	Gets the current status of a session.
	GetSessionStatusAsync(GetSessionStatusRequest, CancellationToken)	Gets the current status of a session.
	GetTableMetadata(GetTableMetadataRequest)	Returns table metadata for the specified catalog, database, and table.
	GetTableMetadataAsync(GetTableMetadataRequest, CancellationToken)	Returns table metadata for the specified catalog, database, and table.
	GetWorkGroup(GetWorkGroupRequest)	Returns information about the workgroup with the specified name.
	GetWorkGroupAsync(GetWorkGroupRequest, CancellationToken)	Returns information about the workgroup with the specified name.
	ImportNotebook(ImportNotebookRequest)	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.
	ImportNotebookAsync(ImportNotebookRequest, CancellationToken)	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.
	ListApplicationDPUSizes(ListApplicationDPUSizesRequest)	Returns the supported DPU sizes for the supported application runtimes (for example, `Athena notebook version 1`).
	ListApplicationDPUSizesAsync(ListApplicationDPUSizesRequest, CancellationToken)	Returns the supported DPU sizes for the supported application runtimes (for example, `Athena notebook version 1`).
	ListCalculationExecutions(ListCalculationExecutionsRequest)	Lists the calculations that have been submitted to a session in descending order. Newer calculations are listed first; older calculations are listed later.
	ListCalculationExecutionsAsync(ListCalculationExecutionsRequest, CancellationToken)	Lists the calculations that have been submitted to a session in descending order. Newer calculations are listed first; older calculations are listed later.
	ListCapacityReservations(ListCapacityReservationsRequest)	Lists the capacity reservations for the current account.
	ListCapacityReservationsAsync(ListCapacityReservationsRequest, CancellationToken)	Lists the capacity reservations for the current account.
	ListDatabases(ListDatabasesRequest)	Lists the databases in the specified data catalog.
	ListDatabasesAsync(ListDatabasesRequest, CancellationToken)	Lists the databases in the specified data catalog.
	ListDataCatalogs(ListDataCatalogsRequest)	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.
	ListDataCatalogsAsync(ListDataCatalogsRequest, CancellationToken)	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.
	ListEngineVersions(ListEngineVersionsRequest)	Returns a list of engine versions that are available to choose from, including the Auto option.
	ListEngineVersionsAsync(ListEngineVersionsRequest, CancellationToken)	Returns a list of engine versions that are available to choose from, including the Auto option.
	ListExecutors(ListExecutorsRequest)	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.
	ListExecutorsAsync(ListExecutorsRequest, CancellationToken)	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.
	ListNamedQueries(ListNamedQueriesRequest)	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.
	ListNamedQueriesAsync(ListNamedQueriesRequest, CancellationToken)	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.
	ListNotebookMetadata(ListNotebookMetadataRequest)	Displays the notebook files for the specified workgroup in paginated format.
	ListNotebookMetadataAsync(ListNotebookMetadataRequest, CancellationToken)	Displays the notebook files for the specified workgroup in paginated format.
	ListNotebookSessions(ListNotebookSessionsRequest)	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.
	ListNotebookSessionsAsync(ListNotebookSessionsRequest, CancellationToken)	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.
	ListPreparedStatements(ListPreparedStatementsRequest)	Lists the prepared statements in the specified workgroup.
	ListPreparedStatementsAsync(ListPreparedStatementsRequest, CancellationToken)	Lists the prepared statements in the specified workgroup.
	ListQueryExecutions(ListQueryExecutionsRequest)	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.
	ListQueryExecutionsAsync(ListQueryExecutionsRequest, CancellationToken)	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.
	ListSessions(ListSessionsRequest)	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.
	ListSessionsAsync(ListSessionsRequest, CancellationToken)	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.
	ListTableMetadata(ListTableMetadataRequest)	Lists the metadata for the tables in the specified data catalog database.
	ListTableMetadataAsync(ListTableMetadataRequest, CancellationToken)	Lists the metadata for the tables in the specified data catalog database.
	ListTagsForResource(ListTagsForResourceRequest)	Lists the tags associated with an Athena resource.
	ListTagsForResourceAsync(ListTagsForResourceRequest, CancellationToken)	Lists the tags associated with an Athena resource.
	ListWorkGroups(ListWorkGroupsRequest)	Lists available workgroups for the account.
	ListWorkGroupsAsync(ListWorkGroupsRequest, CancellationToken)	Lists available workgroups for the account.
	PutCapacityAssignmentConfiguration(PutCapacityAssignmentConfigurationRequest)	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.
	PutCapacityAssignmentConfigurationAsync(PutCapacityAssignmentConfigurationRequest, CancellationToken)	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.
	StartCalculationExecution(StartCalculationExecutionRequest)	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.
	StartCalculationExecutionAsync(StartCalculationExecutionRequest, CancellationToken)	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.
	StartQueryExecution(StartQueryExecutionRequest)	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.
	StartQueryExecutionAsync(StartQueryExecutionRequest, CancellationToken)	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.
	StartSession(StartSessionRequest)	Creates a session for running calculations within a workgroup. The session is ready when it reaches an `IDLE` state.
	StartSessionAsync(StartSessionRequest, CancellationToken)	Creates a session for running calculations within a workgroup. The session is ready when it reaches an `IDLE` state.
	StopCalculationExecution(StopCalculationExecutionRequest)	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.
	StopCalculationExecutionAsync(StopCalculationExecutionRequest, CancellationToken)	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.
	StopQueryExecution(StopQueryExecutionRequest)	Stops a query execution. Requires you to have access to the workgroup in which the query ran.
	StopQueryExecutionAsync(StopQueryExecutionRequest, CancellationToken)	Stops a query execution. Requires you to have access to the workgroup in which the query ran.
	TagResource(TagResourceRequest)	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.
	TagResourceAsync(TagResourceRequest, CancellationToken)	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.
	TerminateSession(TerminateSessionRequest)	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`.
	TerminateSessionAsync(TerminateSessionRequest, CancellationToken)	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`.
	UntagResource(UntagResourceRequest)	Removes one or more tags from an Athena resource.
	UntagResourceAsync(UntagResourceRequest, CancellationToken)	Removes one or more tags from an Athena resource.
	UpdateCapacityReservation(UpdateCapacityReservationRequest)	Updates the number of requested data processing units for the capacity reservation with the specified name.
	UpdateCapacityReservationAsync(UpdateCapacityReservationRequest, CancellationToken)	Updates the number of requested data processing units for the capacity reservation with the specified name.
	UpdateDataCatalog(UpdateDataCatalogRequest)	Updates the data catalog that has the specified name.
	UpdateDataCatalogAsync(UpdateDataCatalogRequest, CancellationToken)	Updates the data catalog that has the specified name.
	UpdateNamedQuery(UpdateNamedQueryRequest)	Updates a NamedQuery object. The database or workgroup cannot be updated.
	UpdateNamedQueryAsync(UpdateNamedQueryRequest, CancellationToken)	Updates a NamedQuery object. The database or workgroup cannot be updated.
	UpdateNotebook(UpdateNotebookRequest)	Updates the contents of a Spark notebook.
	UpdateNotebookAsync(UpdateNotebookRequest, CancellationToken)	Updates the contents of a Spark notebook.
	UpdateNotebookMetadata(UpdateNotebookMetadataRequest)	Updates the metadata for a notebook.
	UpdateNotebookMetadataAsync(UpdateNotebookMetadataRequest, CancellationToken)	Updates the metadata for a notebook.
	UpdatePreparedStatement(UpdatePreparedStatementRequest)	Updates a prepared statement.
	UpdatePreparedStatementAsync(UpdatePreparedStatementRequest, CancellationToken)	Updates a prepared statement.
	UpdateWorkGroup(UpdateWorkGroupRequest)	Updates the workgroup with the specified name. The workgroup's name cannot be changed. Only `ConfigurationUpdates` can be specified.
	UpdateWorkGroupAsync(UpdateWorkGroupRequest, CancellationToken)	Updates the workgroup with the specified name. The workgroup's name cannot be changed. Only `ConfigurationUpdates` can be specified.

Events

	Name	Description
	AfterResponseEvent	Inherited from Amazon.Runtime.AmazonServiceClient.
	BeforeRequestEvent	Inherited from Amazon.Runtime.AmazonServiceClient.
	ExceptionEvent	Inherited from Amazon.Runtime.AmazonServiceClient.

Version Information

.NET:
Supported in: 8.0 and newer, Core 3.1

.NET Standard:
Supported in: 2.0

.NET Framework:
Supported in: 4.5 and newer, 3.5