We're using Azure Data Explorer for our big data queries. Now there's a request to pull data from ADX into SQL server for some types of queries.

Is this possible and if so how to do it?

CodePudding user response：

I'm pretty sure that it's not possible to run SQL on top of ADX natively. However, you can create some kind of listener that listens for events and forwards them to both SQL and ADX. But, this solution may become very difficult to support over time.

CodePudding user response：

As mentioned in the other answer, ADX supports a subset of the Microsoft SQL Server communication protocol (MS-TDS), with a subset of the T-SQL query language. One can connect to the T-SQL endpoint of an ADX cluster with any SQL client tool that supports AAD authentication.

If data export from ADX to SQL is required, using export to SQL command could be used.