question

RajKumar-6841 avatar image
0 Votes"
RajKumar-6841 asked KalyanChanumolu-MSFT answered

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

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

azure-data-factoryazure-sql-databaseazure-functions
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered

@RajKumar-6841 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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.