How to Perform UPSERT Insert/Update with Copy Activity in Azure Data Factory | ADF Tutorial 2022

Поделиться
HTML-код
  • Опубликовано: 7 ноя 2024

Комментарии • 6

  • @nimrodshenhav7463
    @nimrodshenhav7463 2 года назад +1

    Thanks, great video. Does UPSERT also deletes records that does not exists in source?

    • @aamirshahzad1848
      @aamirshahzad1848 2 года назад +1

      Thanks, no it does not delete the records.

  • @rahulrrw97
    @rahulrrw97 2 года назад +1

    Hello Sir, Does this work for Azure SQL to Azure SQL database, when I used Upsert then it add a new row, can you please make a video on "Azure SQL on Premise to Azure SQL Incremental load, Insert update and Delete if we need to sync data between two databases table.
    Please request you make video on this, thanks.

  • @devops840
    @devops840 2 года назад +2

    Hi Sir , Could you please let us know how to do dynamic parameters while using upsert ?
    I have multiple files for loading data into tables and do upsert .

  • @asthapriya8029
    @asthapriya8029 2 года назад

    Key column option is not available when I m using copy data is there something I need to enable to those option are avalialble

    • @jeffadkins43004
      @jeffadkins43004 Год назад

      did you check under the Advance as part of the column mapping?