AWS Tutorials - Amazon Athena ACID Transactions (Powered by Apache Iceberg)

Handling Transactions in AWS Lake Formation (Governed Tables) - • AWS Tutorials - Handli...
Amazon Athena supports ACID Transactions to perform concurrent row or record level operations for insert, update and delete of the data. ACID Transaction is Athena is enabled by either Governed Tables or Iceberg Tables. In this video, learn how Amazon Athena uses Iceberg tables to provide ACID Transactions feature.

[@hsz7338]

Thank you for the contents, greatly appreciate it. On Apache Iceberg delete e.g., 'user7', although it didn't appear in the latest Snapshot, it still appeared in the historical snapshot. Does that mean the Physical data record still exists? If Yes, does Athena support the hard delete feature with Apache Iceberg in case we have such a use case requirement?

[@optimisteve]

can you perform data wrangler with an iceberg table?

[@rudysarquis]

Hello, how are you? I have a gorverned tables with lake formation, and a think to use iceberg, do you know how i can do that? I see some people using, but have some trouble with lake formation. Can you help me?

[@user-yz3vx3oi6o]

I tried select * from "tablename$iceberg_history". (replaced tablename with my own table name). it doesn't work for me. any suggestion?

[@AWSTutorialsOnline]

what does not work? You got any error or got no history back?

[@user-yz3vx3oi6o]

@@AWSTutorialsOnline got error. "tablename$history" works.

[@sabelomuzimsimango8467]

I also got that error

[@sabelomuzimsimango8467]

did you figure it out

[@soumyachatterjee8863]

Can you plz share a sample parquet file for POC?

[@soumyachatterjee8863]

Also it would be very helpful if you can provide SQL query in comment section

[@AWSTutorialsOnline]

I am not sure about the ask. You can create a table of your choice and use normal SQL queries for the CRUD operation. Please check this link for sample SQLs - docs.aws.amazon.com/athena/latest/ug/querying-iceberg.html