Forum Discussion

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
2 years ago

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...
data engineering
Amruthafragomen's avatar
Amruthafragomen
New Member
2 years ago

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 ?

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
1 year ago

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.