4 ms·
Is there any information about updates to existing rows? The FAQ says "Similarly to other data lakehouse technologies, DuckLake does not support constraints, ke
by TheGuyWhoCodes 1y ago
Is there any information about updates to existing rows?
The FAQ says "Similarly to other data lakehouse technologies, DuckLake does not support constraints, keys, or indexes."
However in Iceberg there are Copy-On-Write and Merge-On-Read strategies dealing with updates.
- szarnyasg 1y agoYes - updates on existing rows are supported. (I work at DuckDB Labs.)
- TheGuyWhoCodes 1y agoThanks szarnyasg. If I've got you here, can you use the ducklake extension commands to get the parquet files for a query without running said query? That way you could use another query engine while still use duckdb to handle the data mutation.