TheGuyWhoCodes 5 days 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.

1
szarnyasg 5 days ago

Yes - updates on existing rows are supported.

(I work at DuckDB Labs.)

TheGuyWhoCodes 5 days ago

Thanks 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.