Remove Business Intelligence Remove Data Transformation Remove Snapshot Remove Workshop
article thumbnail

Perform upserts in a data lake using Amazon Athena and Apache Iceberg

AWS Big Data

It supports modern analytical data lake operations such as create table as select (CTAS), upsert and merge, and time travel queries. Athena also supports the ability to create views and perform VACUUM (snapshot expiration) on Apache Iceberg tables to optimize storage and performance.

article thumbnail

Orca Security’s journey to a petabyte-scale data lake with Apache Iceberg and AWS Analytics

AWS Big Data

This data is then used by various applications for streaming analytics, business intelligence, and reporting. Using Apache Iceberg’s compaction results in significant performance improvements, especially for large tables, making a noticeable difference in query performance between compacted and uncompacted data.