Hello, I was trying to apply your suggestion about partition pruning on the existing table, by using the distinct values coming from the partitioning column of the incoming table to be merged, I wanted to do this dinamically but I found a corner case: in case I have an historization table that I'd like to update, if one new record has a new date (i.e. 2024), and the old version of that record was created in 2023, my merge condition "hist.BK_id == incoming.BK_id AND partition_year in (2024)" wouldn't allow me to update (flag is_current = False) the old record... I end up having duplicates and I cannot figure out an efficient way to include the partition without doing another expensive lookup. Do you have any suggestion for this use case?
