question

SreekanthKesaram-9550 avatar image
0 Votes"
SreekanthKesaram-9550 asked SreekanthKesaram-9550 commented

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

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

azure-sql-databaseazure-data-explorer
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered SreekanthKesaram-9550 commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks Vaibhav let me try this once...

0 Votes 0 ·