Thanks in Advance, I have requirement like insert/update data in Azure SQL table from the tables in ADX cluster.
Thanks in Advance, I have requirement like insert/update data in Azure SQL table from the tables in ADX cluster.
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://docs.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
13 people are following this question.