Amazon Athena

2024/01/19 - 1 updated api methods

Changes   Introducing new NotebookS3LocationUri parameter to Athena ImportNotebook API. Payload is no longer required and either Payload or NotebookS3LocationUri needs to be provided (not both) for a successful ImportNotebook API call. If both are provided, an InvalidRequestException will be thrown.

2023/12/05 - 12 updated api methods

Changes   Adding IdentityCenter enabled request for interactive query

2023/11/17 - 3 updated api methods

Changes   Adding SerivicePreProcessing time metric

2023/06/08 - 2 updated api methods

Changes   You can now define custom spark properties at start of the session for use cases like cluster encryption, table formats, and general Spark tuning.

2023/06/02 - 1 new api methods

Changes   This release introduces the DeleteCapacityReservation API and the ability to manage capacity reservations using CloudFormation

2023/05/15 - 2 updated api methods

Changes   You can now define custom spark properties at start of the session for use cases like cluster encryption, table formats, and general Spark tuning.

2023/04/28 - 7 new api methods

Changes   You can now use capacity reservations on Amazon Athena to run SQL queries on fully-managed compute capacity.

2023/03/27 - 3 updated api methods

Changes   Enforces a minimal level of encryption for the workgroup for query and calculation results that are written to Amazon S3. When enabled, workgroup users can set encryption only to the minimum level set by the administrator or higher when they submit queries.

2023/03/08 - 2 updated api methods

Changes   A new field SubstatementType is added to GetQueryExecution API, so customers have an error free way to detect the query type and interpret the result.

2022/11/30 - 23 new 3 updated api methods

Changes   This release includes support for using Apache Spark in Amazon Athena.

2022/11/07 - 3 updated api methods

Changes   Adds support for using Query Result Reuse

2022/07/21 - 1 new api methods

Changes   This feature allows customers to retrieve runtime statistics for completed queries

2022/06/30 - 1 new 3 updated api methods

Changes   This feature introduces the API support for Athena's parameterized query and BatchGetPreparedStatement API.

2022/04/15 - 2 updated api methods

Changes   This release adds subfields, ErrorMessage, Retryable, to the AthenaError response object in the GetQueryExecution API when a query fails.

2022/03/02 - 6 updated api methods

Changes   This release adds support for S3 Object Ownership by allowing the S3 bucket owner full control canned ACL to be set when Athena writes query results to S3 buckets.

2022/02/28 - 1 new api methods

Changes   This release adds support for updating an existing named query.

2022/02/14 - 2 updated api methods

Changes   This release adds a subfield, ErrorType, to the AthenaError response object in the GetQueryExecution API when a query fails.

2022/02/04 - 6 updated api methods

Changes   You can now optionally specify the account ID that you expect to be the owner of your query results output location bucket in Athena. If the account ID of the query results bucket owner does not match the specified account ID, attempts to output to the bucket will fail with an S3 permissions error.

2022/01/28 - 2 updated api methods

Changes   This release adds a field, AthenaError, to the GetQueryExecution response object when a query fails.

2021/03/05 - 5 new api methods

Changes   Adds APIs to create, list, update, and delete prepared SQL statements that have optional placeholder parameters. A prepared statement can use different values for these parameters each time it is run.

2021/02/04 - 1 new 6 updated api methods

Changes   Adds the Athena ListEngineVersions action and the EngineVersion data type. ListEngineVersions returns the available Athena engine versions, including Auto, as a list of EngineVersion objects.

2020/06/01 - 9 new 3 updated api methods

Changes   This release adds support for connecting Athena to your own Apache Hive Metastores in addition to the AWS Glue Data Catalog. For more information, please see https://docs.aws.amazon.com/athena/latest/ug/connect-to-data-source-hive.html

2019/11/25 - 2 updated api methods

Changes   This release adds additional query lifecycle metrics to the QueryExecutionStatistics object in GetQueryExecution response.

2019/09/17 - 2 updated api methods

Changes   This release adds DataManifestLocation field indicating the location and file name of the data manifest file. Users can get a list of files that the Athena query wrote or intended to write from the manifest file.

2019/08/15 - 3 updated api methods

Changes   This release adds support for querying S3 Requester Pays buckets. Users can enable this feature through their Workgroup settings.

2019/02/22 - 3 new 1 updated api methods

Changes   This release adds tagging support for Workgroups to Amazon Athena. Use these APIs to add, remove, or list tags on Workgroups, and leverage the tags for various authorization and billing scenarios.

2019/02/18 - 5 new 8 updated api methods

Changes   This release adds support for Workgroups to Amazon Athena. Use Workgroups to isolate users, teams, applications or workloads in the same account, control costs by setting up query limits and creating Amazon SNS alarms, and publish query-related metrics to Amazon CloudWatch.

2018/10/11 - 3 updated api methods

Changes   1. GetQueryExecution API changes to return statementType of a submitted Athena query. 2. GetQueryResults API changes to return the number of rows added to a table when a CTAS query is executed.

2017/05/18 - 11 new api methods

Changes   This release adds support for Amazon Athena. Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.