article thumbnail

Backtesting index rebalancing arbitrage with Amazon EMR and Apache Iceberg

AWS Big Data

With scalable metadata indexing, Apache Iceberg is able to deliver performant queries to a variety of engines such as Spark and Athena by reducing planning time. To avoid look-ahead bias in backtesting, it’s essential to create snapshots of the data at different points in time. Tag this data to preserve a snapshot of it.

article thumbnail

Build a multi-Region and highly resilient modern data architecture using AWS Glue and AWS Lake Formation

AWS Big Data

The utility for cloning and experimentation is available in the open-sourced GitHub repository. This solution only replicates metadata in the Data Catalog, not the actual underlying data. Lake Formation permissions In Lake Formation, there are two types of permissions: metadata access and data access.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Improve operational efficiencies of Apache Iceberg tables built on Amazon S3 data lakes

AWS Big Data

The following examples are also available in the sample notebook in the aws-samples GitHub repo for quick experimentation. In that case, we have to query the table with the snapshot-id corresponding to the deleted row. We expire the old snapshots from the table and keep only the last two.

article thumbnail

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

AWS Big Data

Additionally, partition evolution enables experimentation with various partitioning strategies to optimize cost and performance without requiring a rewrite of the table’s data every time. Metadata tables offer insights into the physical data storage layout of the tables and offer the convenience of querying them with Athena version 3.