How to get the Aduit details when data transfer from Azure blob storage to Azure SQL database.

Question

Hi,

How can we achieve this in ADF.

We are Transferring Data From Azure blob storage to Azure SQL database. we need to create report from SQL, That report shows details of Audit type like, starting time, end time, how many rows inserted, how many rows updated, error exception log etc. for this report we need to getting these information and How to store data in Azure SQL Database.  

Any help would be highly appreciate.

Thank you.

Answer 1

Hi,

How can we achieve this in ADF.

We are Transferring Data From Azure blob storage to Azure SQL database. we need to create report from SQL, That report shows details of Audit type like, starting time, end time, how many rows inserted, how many rows updated, error exception log etc. for this report we need to getting these information and How to store data in Azure SQL Database.  

Any help would be highly appreciate.

Thank you.

Good day,

You can use Azure Monitor. Data Factory outputs diagnostic logs in Azure Monitor. You can get more information here.

---

Ronen Ariely  [Personal Site]    [Blog]    [Facebook]    [Linkedin]