Insert / Update / Delete on S3 With Amazon Athena and Apache Iceberg | Amazon Web Services
Why Stack Overflow recommends it
Stack Overflow users link it when answering whether Athena can update or insert data in S3, since it shows the Iceberg table approach for CRUD operations.
Recommended by 2 people across 2 different months, 2022 to 2022.
What it is
An AWS walkthrough of using Amazon Athena with Apache Iceberg tables to run insert, update, delete and time travel queries on data stored in Amazon S3. It is a short demo-style overview from the official Amazon Web Services channel.
What people said
Recommends Bijohn Vincent · 2022-04 · Stack Overflow · on “Can AWS Athena update or insert data stored in S3?”
Finally there is a solution from AWS. Now you can perform CRUD (create, read, update and delete) operations on AWS Athena. Athena Iceberg [LINK] integration is generally available [LINK] now. Create [LINK] the table with: TBLPROPERTIES ( 'table_type' ='ICEBERG' [, property_name=property_value]) then you can use it's amazing feature. For a quick introduction, you can watch this video [this video] . (Or search Insert / Update / Delete on S3 With Amazon Athena and Apache Iceberg | Amazon Web Services on Youtube) Read Considerations and Limitations [LINK]
Recommends Yuva · 2022-05 · Stack Overflow · on “Athena error: Please ensure target table is an external table. (for Governed Table)”
AWS recently made GA of this feature in Apr 2022, i.e., ACID compliance, Insert/update over S3 objects using Apache Iceberg, time travel, etc., maybe you can read this document, and see if it helps, [LINK] & [this video]
Cites Oleksii · 2022-02 · Stack Overflow · on “Athena Iceberg Slow On Empty Table”
To my surprise it seems like it is normal for this format. Check execution time of queries on this official AWS video. [this video] Especially query 7.
Cites Arpit Bhasin · 2022-06 · Stack Overflow · on “Can AWS Athena update or insert data stored in S3?”
We could use something known as Apache Iceberg in collaboration with Athena to perform CRUD operations on S3 data inside AWS itself. The only caveat being that at the time of table creation we need to use extra parameter as table_type = 'ICEBERG'. Eg: create table demo ( id string, attr1 string ) location 's3://path' TBLPROPERTIES ( 'table_type' = 'ICEBERG' ) For more details : [this video]