I found some similar questions but none exactly matching my use case.
When trying to use a MERGE statement Microsoft mentions the following: