How to get both before and after updated records in azure data factory from Azure sql

Question

I had a scenario if a new record is updated, I need both before the update and currently updated value in azure data factory, and pass it to function app. Since CDC is not supported in Azure SQL I cannot get History records. Kindly suggest me to get better solution

Answer 1

@Raj Kumar Welcome to Microsoft Q&A forums.

CDC is not supported on Azure SQL database yet. You can however use Temporal Tables to maintain version history of the data being modified.
Once you have the history of changes logged into a separate table, you can query it from Azure Data Factory or from Function App directly.

Please go through the link provided and let us know if you have further questions.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.