4 min read
|
Saved February 14, 2026
|
Copied!
Do you care about this?
The DuckDB-Iceberg extension now supports insert, update, and delete operations for Iceberg v2 tables in version 1.4.2. Users can interact with Iceberg REST Catalogs and manage table properties while utilizing SQL syntax for data manipulation. However, there are limitations regarding updates on partitioned tables and the lack of copy-on-write support.
If you do, here's more
DuckDB has made significant advancements in its Iceberg extension with the release of version 1.4.2, which now supports insert, update, and delete operations on Iceberg v2 tables. The previous version, 1.4.0, introduced basic write functionality, and the latest update enhances this by allowing users to manipulate data more flexibly using standard SQL commands. This is a notable development given the growing popularity of the Iceberg open table format, particularly among data platforms.
To utilize the new features, users must connect to an Iceberg REST Catalog, such as Apache Polaris or Amazon S3 Tables. The article provides straightforward SQL commands for creating tables and performing inserts, updates, and deletes. However, there are limitations: updates can only be executed on non-partitioned, unsorted tables, and DuckDB-Iceberg currently supports only positional deletes without copy-on-write functionality.
Version 1.4.2 also introduces functions for managing table properties, which help control how updates and deletes are handled. Users can set, view, and remove properties related to table behavior, enhancing control over data management. Additionally, the new Iceberg functions allow users to view table metadata and snapshots, which aids in tracking changes over time. Time travel capabilities enable querying historical data using specific snapshot IDs or timestamps, providing flexibility in data analysis. Finally, users can monitor requests made to the Iceberg REST Catalog by enabling HTTP logging, offering insights into how DuckDB interacts with external data sources.
Questions about this article
No questions yet.