Need Urgent help! How to insert/Update Data to Azure Sql table from table data in ADX's cluster.

Sreekanth Kesaram 21 Reputation points

Thanks in Advance, I have requirement like insert/update data in Azure SQL table from the tables in ADX cluster.

Azure SQL Database
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
479 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,576 Reputation points

    I haven't tried this but just found below documentation which says - KQL Query result can be exported to Azure SQL

    .export async to sql MySqlTable  
        h@",1433;Database=MyDatabase;Authentication=Active Directory Integrated;Connection Timeout=30;"  
        <| print Id="d3b68d12-cbd3-428b-807f-2c740f561989", Name="YSO4", DateOfBirth=datetime(2017-10-15)  

    Another option is to try create pipeline in Azure data factory - copy data from ADX table to SQL table (staging) and run SQL Procedure to insert/update to final table


    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

0 additional answers

Sort by: Most helpful