topic Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse? in Data Engineering

Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

anabealmeidas — Fri, 20 Feb 2026 15:43:01 GMT

I have a problem: I need to extract data from an on-premise Oracle database and load it into Lakehouse. Currently, I use the "overwrite" option of the "Activity Copy" feature in the Microsoft Fabric Pipeline, but I would like to replace it with "upsert".

I'm trying to understand how to use Upsert in the Microsoft Fabric Pipeline, but I read that upsert is not supported when using Lakehouse as the destination. After reading more about the "Upsert" option, it appears there is an option to use the Data Factory's Copy Job features, but I'd like to understand if there's a simpler option and if this feature is indeed unavailable in the pipeline.

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

Lodha_Jaydeep — Fri, 20 Feb 2026 16:04:12 GMT

You're correct Upsert is not currently supported in Copy Activity when the destination is a Lakehouse (Delta table) in Microsoft Fabric.

For Lakehouse targets, Copy Activity only supports:

Append
Overwrite

There isn’t a built-in Upsert option for Delta tables in Fabric pipelines at the moment.

If you need Upsert behavior (insert new rows and update existing ones), the recommended approach is:

Use Copy Activity to load data from your on-prem Oracle source (via gateway) into a staging table in the Lakehouse using Append mode.
Add a Notebook activity after the copy step.
In the notebook, use a Delta MERGE INTO statement to perform the Upsert into your final table.

This is currently the standard and supported pattern in Fabric for incremental loads into Lakehouse.

So unfortunately, there isn’t a simpler “toggle” solution in the pipeline itself right now using MERGE via Notebook or SQL is the correct way to handle it.

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

ssrithar — Fri, 20 Feb 2026 16:22:00 GMT

Hi @anabealmeidas ,

Upsert is NOT supported in Copy activity when the sink is a Lakehouse table in Microsoft Fabric.

In Microsoft Fabric Pipelines, the Copy activity supports Upsert only for certain relational sinks (like SQL databases).

When your destination is a Lakehouse (Delta table):

The Copy activity supports:
- Append
- Overwrite
It does NOT support:
- Upsert
- Merge logic
- Key-based updates
  Recommended Solution
  Instead of using Copy Upsert, use this architecture:
  Step 1 — Copy to Staging Table (Append mode)
  Use Copy activity to load Oracle data into:
  - A staging Delta table in the Lakehouse Or a staging folder
  Step 2 — Perform MERGE using Spark (Notebook)
  Use a Fabric Notebook to run Delta MERGE INTO.

This is the best way to accomplish this.

If this post helps, then please appreciate giving a Kudos or accepting as a Solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

anabealmeidas — Fri, 20 Feb 2026 18:58:24 GMT

Thanks for help me!

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

anabealmeidas — Fri, 20 Feb 2026 18:58:34 GMT

Thanks for help me!

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

smeetsh — Thu, 26 Feb 2026 00:15:53 GMT

as of last month "merge" has gone general audience, so yes upsert is now possible. You have to use a script activity for this.

topic Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse? in Data Engineering

Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

Recommended Solution

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?

Re: Is Upsert Supported in Microsoft Fabric Pipeline When Loading from On-Prem Oracle to Lakehouse?