Using Athena ACID transactions
ACID transactions enable multiple users to concurrently and reliably add and delete Amazon S3 objects in an atomic manner, while isolating any existing queries by maintaining read consistency for queries against the data lake. Athena ACID transactions add single-table support for insert, delete, update, and time travel operations to the Athena SQL data manipulation language (DML). You and multiple concurrent users can use Athena ACID transactions to make reliable, row-level modifications to Amazon S3 data. Athena transactions automatically manage locking semantics and coordination and do not require a custom record locking solution.
Athena ACID transactions and familiar SQL syntax simplify updates to your business and
regulatory data. For example, to respond to a data erasure request, you can perform a SQL
DELETE
operation. To make manual record corrections, you can use a single
UPDATE
statement. To recover data that was recently deleted, you can issue
time travel queries using a SELECT
statement.
Because they are built on shared table formats, Athena ACID transactions are compatible
with other services and engines such as Amazon EMR and Apache spark
Athena transactions are available through the Athena console, API operations, and ODBC and JDBC drivers.