Question 104224 in Azure Question posted in
The official documentation to get you started can be found here.

Azure Logs Kusto Query Output to database table

I need to save a output from a Kusto query on monitoring logs into a database table but I am unable to find a way to do it. I am presuming there will be a way to get the output from a Kusto query and save it to storage then pull that data into a table using a pipeline.

Any suggestions welcome

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    So what we do not is we have created a logic application that runs the query real-time and returns the data via http then we save that to the table. No manual intervention


  2. 0

    I have reproduced in my environment and got expected results as below:
    Firstly, I have executed below Kusto query and exported it into csv file into local machine:

     AzureActivity
 | project OperationName,Level,ActivityStatus

    enter image description here

    And then uploaded the csv file from local machine into my Blob storage account as below:

    enter image description here

    Now I created an ADF service

    now create new pipeline in it and take Copy activity in that pipeline.

    enter image description here

    Then I created linked service for blob storage as source and linked service for SQL database as sink.

    In source dataset I gave the Blob file

    enter image description here

    In source dataset I gave SQL server table

    enter image description here

    Copy activity sink settings set table options as Auto create table

    enter image description here

    Output In SQL Query editor:

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search