| title | Query integrations overview |
|---|---|
| description | Learn about the available query integrations. |
| ms.reviewer | aksdi |
| ms.topic | integration |
| ms.date | 12/01/2025 |
Kusto Query Language (KQL) is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. Use KQL to explore your data in different environments, and in other Microsoft services.
Use the following filters to see other connectors, tools, and integrations that are available for your use case.
:::row::: :::column span=""::: > [!div class="nextstepaction"] > Overview :::column-end::: :::column span=""::: > [!div class="nextstepaction"] > Data integrations :::column-end::: :::column span=""::: > [!div class="nextstepaction"] > Visualization integrations :::column-end::: :::row-end:::
The following tables summarize the available query connectors, tools, and integrations.
| Name | Functionality | Roles | Use cases |
|---|---|---|---|
| Apache Spark | Query, Ingest, and Export | Data Analyst, Data Scientist | Machine learning (ML), Extract-Transform-Load (ETL), and Log Analytics scenarios using any Spark cluster |
| Azure Functions | Query, Ingest, and Orchestrate | Data Engineer, Application Developer | Integrate Azure Data Explorer into your serverless workflows to ingest data and run queries against your cluster |
| JDBC | Query | Application Developer | Use JDBC to connect to Azure Data Explorer databases and execute queries |
| Logic Apps | Query and Orchestrate | Low Code Application Developer | Run queries and commands automatically as part of a scheduled or triggered task. |
| Matlab | Query | Data Analyst, Data Scientist | Analye data, develop algorithms and create models. |
| ODBC | Query | Application Developer | Establish a connection to Azure Data Explorer from any application that is equipped with support for the ODBC driver for SQL Serve. |
| Power Apps | Query and Orchestrate | Low Code Application Developer | Build a low code, highly functional app to make use of data stored in Azure Data Explorer |
| Power Automate | Query and Orchestrate | Low Code Application Developer | Orchestrate and schedule flows, send notifications, and alerts, as part of a scheduled or triggered task |
| Name | Functionality | Roles | Use Cases |
|---|---|---|---|
| Azure Data Lake | Query | Data Engineer, Data Analyst | Fast access to data stored in external storage |
| Azure Data Studio | Query, Author Notebooks | Data Engineer, Data Analyst, Data Scientist | Quickly observe trends and anomalies against massive amounts of data stored in Azure Data Explorer |
| Azure Monitor | Query and Export | Data Engineer | Low cost data retention |
| Jupyter Notebooks | Author Notebooks | Data Engineer, Data Scientist | Create and share documents containing live code, equations, visualizations for statistical modeling, data visualization, and machine learning using data stored in Azure Data Explorer. |
| Kusto.Explorer | Query, Ingest, Admin and Dashboarding | Data Engineer, Data Analyst, Data Scientist | End-to-end data exploration |
| Kusto CLI | Query and Admin | Application Admin, System Administrator | Send queries and control commands to an Azure Data Explorer cluster using command line utility |
| Kusto Query Language parser | Query and Schema Exploration | Application Developer | Parse queries, perform semantic analysis, check for errors, and optimize your queries. |
| Kusto Query Language Monaco editor | Query, Admin, and Dashboarding | Application Developer, Data Engineer | Integrate Monaco Editor in your application |
| Real-Time Intelligence in Microsoft Fabric | Query, Ingest, Admin, and Dashboarding | Data Engineer, Data Analyst, Data Scientist | End-to-end data exploration |
| Web UI | Query, Ingest, Admin, and Dashboarding | Data Engineer, Data Analyst, Data Scientist | End-to-end data exploration |
For more information about connectors and tools, see Integrations overview.