Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
There are many data connectors, tools, and integrations that work seamlessly with the platform for ingestion, orchestration, output, and data query. This document is a high level overview about the available connectors, tools, and integrations. Detailed information is provided for each connector, along with links to its full documentation.
For overview pages on a specific type of integration, select one of the following buttons.
The following tables summarize the capabilities of each item. Select the tab corresponding to connectors or tools and integrations. Each item name is linked to its detailed description.
The following table summarizes the available tools and integrations and their capabilities:
Name | Ingest | Query | Share | Source control | Secure | Administrate | Visualize |
---|---|---|---|---|---|---|---|
Azure CLI | ✔️ | ||||||
Azure Data Lake | ✔️ | ✔️ | |||||
Azure Data Studio | ✔️ | ||||||
Azure Monitor | ✔️ | ✔️ | ✔️ | ||||
Azure Notebooks | ✔️ | ✔️ | |||||
DeltaKusto | ✔️ | ||||||
Jupyter Notebooks | ✔️ | ✔️ | |||||
KQL Parser | ✔️ | ||||||
Kusto.Explorer | ✔️ | ✔️ | |||||
Kusto CLI | ✔️ | ✔️ | ✔️ | ||||
Lightingest | ✔️ | ||||||
Microsoft Purview | ✔️ | ||||||
Monaco editor | ✔️ | ||||||
PowerShell | ✔️ | ||||||
SyncKusto | ✔️ | ||||||
Web UI | ✔️ | ✔️ | ✔️ |
The following are detailed descriptions of connectors and tools and integrations. Select the tab corresponding to connectors or tools and integrations. All available items are summarized in the Comparison tables above.
Azure CLI lets you manage Kusto resources.
- Functionality: Administration
- Documentation: az kusto
Azure Data Explorer integrates with Azure Blob Storage and Azure Data Lake Storage (Gen1 and Gen2), providing fast, cached, and indexed access to data stored in external storage.
- Functionality: Query
- Documentation: Query data in Azure Data Lake using Azure Data Explorer
The Kusto (KQL) extension for Azure Data Studio enables you to connect and query to Azure Data Explorer clusters. Users can write and run KQL queries and author notebooks with the Kusto kernel complete with IntelliSens
- Functionality: Query
- Documentation: Kusto extension overview, use Kusto, and use Kqlmagic
The Azure Data Explorer supports cross-service queries between Azure Data Explorer, Application Insights (AI), and Log Analytics (LA). You can query your Log Analytics or Application Insights workspace using Azure Data Explorer query tools and in a cross-service query.
- Functionality: Query
- Documentation: Azure Monitor
Kqlmagic is a command that extends the capabilities of the Python kernel in Azure Data Studio notebooks. You can combine Python and Kusto query language (KQL) to query and visualize data using rich Plotly library integrated with render commands. Kqlmagic brings you the benefit of notebooks, data analysis, and rich Python capabilities all in the same location. Supported data sources with Kqlmagic include Azure Data Explorer, Application Insights, and Azure Monitor logs.
- Functionality: Query, Visualization
- Documentation: Azure Notebooks
Delta Kusto is a Command-line interface (CLI) enabling Continuous Integration / Continuous Deployment (CI / CD) automation with Kusto objects (for example: tables, functions, policies, security roles) in Azure Data Explorer databases. It can work on a single database, multiple databases, or an entire cluster. Delta Kusto also supports multitenant scenarios.
- Functionality: Source control
- Documentation: Delta Kusto
Jupyter Notebook is an open-source web application that allows you to create and share documents containing live code, equations, visualizations, and narrative text. It's useful for a wide range of tasks, such as data cleaning and transformation, numerical simulation, statistical modeling, data visualization, and machine learning.
Kqlmagic extends the capabilities of the Python kernel in Jupyter Notebook so you can run Kusto Query Language (KQL) queries natively. You can combine Python and KQL to query and visualize data using the rich Plot.ly library integrated with the render operator. The kqlmagic extension is compatible with Jupyter Lab, Visual Studio Code Jupyter extension, and Azure Data Studio, and supported data sources include Azure Data Explorer, Azure Monitor logs, and Application Insights.
- Functionality: Query, Visualization
- Documentation: Jupyter Notebooks
- Community Blog: Analyze data in Azure Data Explorer using KQL magic for Jupyter Notebook
The open source repo contains C# parser and a semantic analyzer as well as a translator project that generates the same libraries in JavaScript.
- Functionality: language parsing
- Documentation: Kusto Query Language parser
Kusto.Explorer is free software for download and use on your Windows desktop. Kusto.Explorer allows you to query and analyze your data with Kusto Query Language (KQL) in a user-friendly interface.
- Functionality: Query, Visualization
- Documentation: Installation and user interface, using Kusto.Explorer
- Additional articles include options, troubleshooting, keyboard shortcuts, code features
Kusto.Cli is a command-line utility for sending queries and control commands on a Kusto cluster.
- Functionality: Query
- Documentation: Kusto CLI
Lightingest is a command-line utility for ad-hoc data ingestion into Azure Data Explorer.
- Functionality: Ingestion
- Ingestion type supported: Batching
- Use cases: Historical data load
- Repository: LightIngest
- Documentation: Use LightIngest to ingest data
Microsoft Purview simplifies data governance by offering a unified service to manage your data from various sources.
- Functionality: Governance
- Documentation: Integrate Azure Data Explorer with Microsoft Purview
You can integrate the Monaco Editor with Kusto Query Language support (monaco-kusto) into your app. Integrating monaco-kusto into your app offers you an editing experience such as completion, colorization, refactoring, renaming, and go-to-definition
- Functionality: Query
- Repository: Monaco Editor
- Documentation: Kusto Query Language setup and usage for the Monaco editor - The Kusto Query Language editor that can be embedded in web and electron based applications.
- Kusto Query Language plugin - Access the Kusto Query Language editor plugin.
- Embedding the Azure Data Explorer web UI - The Azure Data Explorer web UI can be embedded in an iframe and hosted in third-party websites.
PowerShell scripts can use the Kusto client libraries, as PowerShell inherently integrates with .NET libraries.
- Functionality: Query
- Documentation: Use Kusto .NET client libraries from PowerShell
Sync Kusto is a tool that enables users to synchronize various Kusto schema entities, such as table schemas and stored functions. This synchronization is done between the local file system, an Azure Data Explorer database, and Azure repos.
- Functionality: Source control
- Repository: SyncKusto
- Documentation: Sync Kusto
Azure Data Explorer provides a web experience that enables you to connect to your Azure Data Explorer clusters and write, run, and share Kusto Query Language (KQL) commands and queries
- Functionality: Ingestion, Export, Query, Visualization
- Ingestion type supported: Batching, Streaming
- Documentation: Azure Data Explorer web UI, Get data from file