Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
bijns
Regular Visitor

Upsert in Open Mirroring

I can't get upsert working in Open Mirroring. Every line I add with rowmarker 4 is still added and resulting in duplicate entries. Is it just because it's still in preview?

1 ACCEPTED SOLUTION
bijns
Regular Visitor

I have been working with support in the past weeks and today I got the update that there was a known issue and a fix has been applied by the backend team.

I have tested this and it is working now.

View solution in original post

5 REPLIES 5
bijns
Regular Visitor

I have been working with support in the past weeks and today I got the update that there was a known issue and a fix has been applied by the backend team.

I have tested this and it is working now.

bijns
Regular Visitor

Even when I use the basic sample files at https://learn.microsoft.com/en-us/fabric/database/mirrored-database/open-mirroring-landing-zone-form...

But with a fitting _metadata.json 
{
"keyColumns" : ["EmployeeID"]
}

Very consistent behaviour: 0, 1, 2 works, but 4 is behaving as 0. What is wrong?

Hi @bijns 

 

It might be an issue. I recommend that you create a support ticket to report this to Microsoft. Microsoft engineers can help check this at backend and verify whether this is an issue. They may have a solution or fix to this.

 

Best Regards,
Jing

v-jingzhan-msft
Community Support
Community Support

Hi @bijns 

 

Is it only UPSERT not working properly? Do the other three commands INSERT, UPDATE, DELETE with rowmarkers 0,1,2 work?

 

Best Regards,
Jing

Yes, everything else is working fine. It's just the behaviour of 4 as 0 that is wrong. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!