I would like to delete all records related to a client. My datalake is composed of parquet files. Is it possible to delete data with a query on Athena
DELETE
FROM myTable
WHERE client_id=73513
Is it possible to delete a record with Athena?
Viewed 1966
2 Answers
I know there has been more than a year, but I decided to share it here because this comes out on top when you search for Athena delete. ACID level transactions are now supported for Athena using Iceberg https://aws.amazon.com/about-aws/whats-new/2021/11/amazon-athena-acid-apache-iceberg/
Related