Updating data in governed tables

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

AWS-User-5606360
2년 전
I see that for update-table-objects the etag is required "The Amazon S3 ETag of the object. Returned by GetTableObjects for validation and used to identify changes to the underlying data." so does that help with updates? What about with compaction when that s3 file doesn't exist and was compacted

주제

분석 스토리지

태그

데이터 레이크 AWS 레이크 포메이션

언어

English

AWS-User-5606360

질문됨 2년 전1611회 조회

2개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

Hi,

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

hope this helps

전문가

Fabrizio@AWS

답변함 2년 전

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.

AWS-User-1287467

답변함 2년 전

Updating data in governed tables

관련 콘텐츠