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

Sreekanth Kesaram 21 Reputation points
2021-07-13T07:34:13.767+00:00

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
    2021-07-13T11:55:16.673+00:00

    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@"Server=tcp:myserver.database.windows.net,1433;Database=MyDatabase;Authentication=Active Directory Integrated;Connection Timeout=30;"  
        <| print Id="d3b68d12-cbd3-428b-807f-2c740f561989", Name="YSO4", DateOfBirth=datetime(2017-10-15)  
    

    https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/data-export/export-data-to-sql

    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