Forum Discussion

waltheed's avatar
waltheed
Icon for Impactful Individual rankImpactful Individual
3 years ago
Solved

Fabric Data Factory Pipeline: Incremental load

How can I create an incremental load in Data Factory Pipeline?   I only see the Table Actions append or overwrite. But I want to be able to add new rows, update existing ones and mark deleted rows....
Need Help
pipelines
  • ajarora's avatar
    ajarora
    3 years ago

    Your table action options imply that you are using pipelines. If so, good news, we have just added a new feature that allows you to "upsert" the new rows into existing tables instead of append/overwrite only.

    Its in private preview, please ping me with your workspace id, and we can enable it for you along with instructions. cc makromer 

ajarora's avatar
ajarora
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Your table action options imply that you are using pipelines. If so, good news, we have just added a new feature that allows you to "upsert" the new rows into existing tables instead of append/overwrite only.

Its in private preview, please ping me with your workspace id, and we can enable it for you along with instructions. cc makromer 

wgjunsay's avatar
wgjunsay
Icon for Advocate I rankAdvocate I
2 years ago

Hello, is it possible to have this enabled for our capacity? It would help us a lot as we are planning on moving some of our enterprise data to Fabric from SQL DB.