Forum Discussion
QUESTION::COPY DATA::UPSERT FAIL
The source is an on-prem SQL Server, and the destination is a lakehouse table. I use a Copy data activity pointing to the lakehouse SQL endpoint in order to get access to the Upsert option.
Ca...
I'm facing the same issue, I tried both lakehouse and warehouse , Both returned same error. I suspect its the issue Azure sql db on warehouse. Will enabling staging help ?
No. I have a support ticket open since one month ago. The product team is still debugging and hasn't come back with a fix yet.
I got a response finally. Even though UPSERT is a functionality that's exposed in the GUI, it's a UI bug because UPSERT is not available with a lakehouse when using the SQL endpoint. So you have to build it manually using a Copy data activity and a SQL SELECT statement with a WHERE clause to filter for only the newest rows.
