cloud · · 3 min read

Amazon S3 Tables Now Fully Support Apache Iceberg V3 Specification

By Daniel Abib

Amazon S3 Tables Now Fully Support Apache Iceberg V3 Specification

Enhanced Data Management Capabilities

Amazon Web Services has announced that its S3 Tables service now provides complete support for all data types defined in the Apache Iceberg V3 specification. This update allows users to create new V3 tables or upgrade existing V2 tables to access enhanced functionality. The change applies to all AWS regions where S3 Tables are available and takes effect immediately for customers using the service.

The upgrade introduces several advanced features previously unavailable in V2, including deletion vectors for more efficient data removal, row lineage tracking for improved auditability, and support for new data types such as variant, nanosecond timestamps, unknown, geometry, and geography. These additions align S3 Tables with the evolving capabilities of the open-source Iceberg format, which has gained widespread adoption as a standard for managing large-scale analytical data lakes.

How Does This Affect Existing Workloads?

With V3 support, users can now store and query complex geospatial data using geometry and geography types, enabling location-based analytics directly within S3 Tables. The variant type allows for flexible schema handling of semi-structured data, while nanosecond timestamps provide precision timing for high-frequency trading or scientific applications. Deletion vectors improve performance by marking deleted rows without rewriting entire data files, reducing storage overhead and query latency. Row lineage offers granular traceability of data changes, supporting compliance and debugging workflows.

Existing V2 tables can be upgraded in place without requiring data migration, preserving current configurations while unlocking V3 features. AWS notes that the upgrade process is designed to be seamless, with no downtime for ongoing queries. However, certain V3-specific features like deletion vectors and row lineage only apply to new data written after the upgrade, meaning historical data will not automatically gain these capabilities unless rewritten. Customers are advised to review their data access patterns and consider rewriting older partitions to fully leverage the new functionality.

What happens to my existing V2 tables after upgrading to V3? Your existing V2 tables remain fully functional after the upgrade process. New data written to the table will benefit from V3 features like deletion vectors and row lineage, while existing data retains its original format unless explicitly rewritten.

Frequently Asked Questions

Do I need to change my query syntax to use new data types like geometry or variant? No, standard SQL queries work with the new data types as long as your query engine supports Apache Iceberg V3. Engines such as Apache Spark, Flink, and Trino have corresponding V3 support and can read and write these types without modification.

Are there any additional costs associated with using V3 tables in S3 Tables? There are no extra charges for using V3 table features within S3 Tables. Standard S3 storage and request fees apply, and the V3 upgrade does not alter pricing models for the service.

More stories:

Content written by Daniel Abib for techbriefe.com editorial team, AI-assisted.

Share:

Leave a comment