Updating data in governed tables

Question

Are governed tables insert/append only? Is it possible to update data already in the table? https://aws.amazon.com/blogs/big-data/part-3-effective-data-lakes-using-aws-lake-formation-part-3-using-acid-transactions-on-governed-tables/ has a good example of inserting data, but it doesn't look possible to define a primary key to be able to dedupilcate data if you did another insert on the same row or a way to do an update.

Thanks

Answer

It appears that the development team is still working on the update table method to support appends on Governed Tables. They are targeting Q1 2022 to have this feature complete. So as of now, there is no method that you can use out of the box to do an update based on the primary key.

Answer

Hi,

Lake Formation Governed Tables support object level ACID transactions. Record level transactions are not currently supported.

hope this helps

Updating data in governed tables

相關內容