Skip to main content

 none
Incremental data Loading in ADFv2 if table does not have Last Modified date column. RRS feed

  • Question

  • Hi All,

    Is there any possible way to implement incremental data loading in ADF if tables don't have Last ModifiedDate column.?Guys,Could you please share your views if someone has implemented the same.?

    Best Regards,

    Pankaj

    Monday, October 21, 2019 5:42 PM

All replies

  • Hi All,

    Is there any possible way to implement incremental data loading in ADF if tables don't have Last ModifiedDate column.?Guys,Could you please share your views if someone has implemented the same.?

    There is an option which uses Change tracking feature but in this case you should have access to Source SQL server to enable the Change tracking feature. 

    Incrementally load data from Azure SQL Database to Azure Blob Storage using change tracking information


    Regards,
    Vaibhav

    Monday, October 21, 2019 6:15 PM
  • Hi Vaibhav Chaudhari, Thanks for sharing your insights in helping the community.

    Hi pankaj92, Just checking to see if the above answer was helpful. If this answers your query, please consider to click “Mark as Answer” and "Up-Vote" as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.



    Thank you

    If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster.

    Wednesday, October 23, 2019 4:31 PM
    Moderator
  • Hi pankaj92,

    Just checking to see if you still need assistance.


    Thank you

    If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster.

    Friday, October 25, 2019 12:18 AM
    Moderator