Hi,
I would like to revisit a previously discussed question: incremental model (Merge) without update. It seems the topic was closed, but I think it was somewhat overlooked. The solution mentioned by joellabes with the NOT EXISTS clause works well when scanning all matching tables. However, there are cases where we would like to use a rolling match (i.e., partial matching) to avoid unnecessary complexity and costs associated with duplicating data.
Is it possible to request conditional functionality on the when matched then update set lines? Specifically, if merge_update_columns is empty, I tested it out, but for some reason, it still updates all columns. I did custom macros by simply chopping that line off but it really looks like overkill and other may be interested in such feature
Thank you!