Transaction Management in Ducklake

[akash-goel]

Hi Team,

We need to implement transaction management for our current project. Specifically, we are executing five update queries, and it is crucial that if any one of these queries fails, we can roll back to the previous state. Currently, when we run the update queries, multiple snapshots are being created for each change and we are not able to rollback in case of failure.

Could you please assist us with implementing transaction management? If possible, sharing sample code demonstrating how to manage transactions in DuckDB would be greatly appreciated.

[guillesd]

Does something like this work @akash-goel ? https://ducklake.select/docs/stable/duckdb/usage/time_travel