Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions,
see Getting Started with Amazon Web Services in China
(PDF).
Use Athena ACID transactions
The term "ACID transactions" refers to a set of properties (atomicity,
consistency, isolation, and
durability) that ensure data integrity in database 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 that also support shared table
formats.
Athena transactions are available through the Athena console, API operations, and ODBC and
JDBC drivers.