Somesh, it seems you are looking for multi-statement transaction behavior, which the community has discussed before.
* desgin doc: https://docs.google.com/document/d/1jr4Ah8oceOmo6fwxG_0II4vKDUHUKScb/edit * dev thread: https://lists.apache.org/thread/q7vgnfwdxng5q6mq45m0psghzy7553r7 On Fri, Mar 27, 2026 at 8:02 AM Somesh Dhal <[email protected]> wrote: > Can someone confirm if there's any way I can set > "validate_from_snapshot_id" for iceberg merge query? By default it picks up > the latest snapshot id of a table, but as I have a multi step process ( > merge being the last step ), I want to set this explicitly. Was expecting > to set this as options as part of mergeinto dataframe api, but don't see > that option. I have tried setting this in sql conf for current thread but > this doesn't work. Upon debugging more, I could see that this is only read > from write conf only for certain actions like overwrite partitions, dynamic > overwrite etc. Is there no absolute way to achieve this for merge query/api? >
