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

Question

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

Answer 1

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