Azure Data Explorer tools and integrations overview
Azure Data Explorer is a fast, fully managed data analytics service for real-time analysis of large volumes of data streaming from applications, websites, IoT devices, and more. Azure Data Explorer collects, stores, and analyzes diverse data to improve products, enhance customer experiences, monitor devices, and boost operations.
Azure Data Explorer offers different tools and integrations to do data ingestion, queries, visualization, orchestration and more. In addition to its native services, Azure Data Explorer allows users to integrate easily with various products and platforms, enable various customer use cases, optimize the business process by streamlining workflows, and reducing costs.
This article supplies you with a list of Azure Data Explorer tools, connectors, and integrations with links to relevant documents for additional information.
Ingest data
Data ingestion is the process used to load data records from one or more sources into Azure Data Explorer. Once ingested, the data becomes available for query. Azure Data Explorer provides several tools and connectors for data ingestion.
Azure Data Explorer ingestion tools
- LightIngest - Help utility for ad-hoc data ingesting into Azure Data Explorer
- Ingestion wizard: overview and ingest data from a container to a new table or from a local file to an existing table
Ingestion integrations
- Event hub: Ingest from event hub overview and using the Azure portal, C#, Python or Azure Resource Manager template
- Event Grid: Ingest from Event Grid overview and using the Azure portal, C#, Python or Azure Resource Manager template
- IoT Hub: Ingest from IoT Hub overview and using the Azure portal, C#, Python or Azure Resource Manager template
- Logstash
- Azure Data Factory: integration overview, copy data, Copy in bulk using the Azure Data Factory template, and run Azure Data Explorer control commands using Azure Data Factory command activity
- Azure Synapse Apache Spark
- Apache Spark
- Apache Kafka
- Telegraf
- Azure Cosmos DB
- Power Automate
Query data
Azure Data Explorer query tools
There are several tools available for running queries in Azure Data Explorer.
- Azure Data Explorer web UI
- Kusto.Explorer
- installation and user interface, using Kusto.Explorer
- Additional topics include options, troubleshooting, keyboard shortcuts, code refactoring, code navigation, and code analyze
- Kusto CLI
Query open source repositories
The following open source repositories contain the source code for the Kusto Query Language (KQL) parser and editor:
- Kusto Query Language parser - A .NET core repository for the Kusto Query Language parser and semantic tree.
- 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.
Query integrations
- Azure Monitor
- Azure Data Lake
- Azure Synapse Apache Spark
- Apache Spark
- Microsoft Power Apps
- Azure Data Studio: Kusto extension overview, use Kusto, and use Kqlmagic
Visualizations, dashboards, and reporting
The visualization overview details data visualization, dashboards, and reporting options.
Notebook connectivity
- Azure Notebooks
- Jupyter Notebooks
- Azure Data Studio: Kusto extension overview, use Kusto, and use Kqlmagic
Orchestration
- Power Automate
- Microsoft Logic App
- Azure Data Factory