Populate sink table with new column values

Raj0125 511 Reputation points
2022-05-04T10:12:47.923+00:00

@ AnuragSharma-MSFT

Hi ,

I am trying to achieve the below requirement in ADF.Please suggest on this

https://learn.microsoft.com/en-us/answers/questions/832605/duplicate-records-is-populating.html?childToView=836113#answer-836113

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,071 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2022-05-05T18:40:06.13+00:00

    Hello @Raj0125 ,
    Thanks for the question and using MS Q&A platform.

    As we understand the ask here is run the SQL query in the thread posted using ADF and I am guessing you want to insert that into a SQL table , please do let us know if its not accurate.

    You can use the copy activity in ADF to get his done . You can read about this here : https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-overview

    199318-image.png

    199401-image.png

    Please do let me if you have any queries.
    Thanks
    Himanshu


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments