Share via

Storing Log Analytics workspace data to Azure SQL DB

Sundar Sriram Garimella 136 Reputation points
2023-02-20T12:58:58.1133333+00:00

We had few sets of Data Factories running multiple pipelines. To monitor those, we had set up Diagnostic Settings to a Log Analytics Workspace. We are wondering if we can store them to Azure SQL through a pipeline (ADF) or Logic Apps.

  1. We need the parameters passed for the pipelines.
  2. Duration
  3. Status (Success / Running / Failure)
  4. Source
  5. Sink
  6. Activity details

Please help with details.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,344 questions
Accepted answer
  1. ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee
    2023-02-27T11:46:39.19+00:00

    Hi Sundar Garimella,

    Thank you for posting query in Microsoft Q&A Platform.

    Since. ADF don't want inbuilt connector for log analytics we need to consider making API call. You can use Copy activity in Azure data factory to perform this. In copy activity, under source tab use REST type connector dataset which make API call to your workspace and fetch the details. And under sink tab use SQL type dataset.

    User's image

    Hope this helps.

    Please consider hitting Accept Answer button. Accepted answers help community as well. Feel free raise new question for other requirements to help you better. Thank you.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 34,426 Reputation points MVP
    2023-02-20T13:24:19.6233333+00:00

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.