Azure Data Explorer


Azure Data Explorer is a fully-managed big data analytics cloud platform and data-exploration service, developed by Microsoft, that ingests structured, semi-structured and unstructured data. The service then stores this data and answers analytic ad-hoc queries on it with seconds of latency. It is a full text indexing and retrieval database, including time series analysis capabilities and regular expression evaluation and text parsing.
It is offered as Platform as a Service as part of Microsoft Azure platform. The product was announced by Microsoft in 2018.

History

The development of the product began in 2014 as a grassroots incubation project in the Israeli R&D center of Microsoft, with the internal code name 'Kusto'. The project aim was to address Azure services' needs for fast and scalable log and telemetry analytics. In 2016 it became the backend big-data and analytics service for Application Insights Analytics
The product was announced as a Public Preview product at the Microsoft Ignite 2018 conference
, and was announced as a general availability product at the Microsoft Ignite conference of February 2019.

Features

Azure Data Explorer offers an optimized query language and visualizing options of its data with a SQL-like language called KQL. KQL is used for querying only and unlike SQL, KQL can not update or delete data.
Azure Data Explorer can ingest 200 MB per second per node. Data Ingestion methods are pipelines and connectors to common services like Azure Event Grid or Azure Event Hub, or programmatic ingestion using SDKs.
Data visualization can be achieved with tools like PowerBI or Grafana.

Design

Azure Data Explorer is a distributed database running on a cluster of compute nodes in Microsoft Azure. It is based on relational database management systems, supporting entities such as databases, tables, functions, and columns. It supports complex analytics query operators, such as calculated columns, searching and filtering or rows, group by-aggregates and joins.
The engine service exposes a relational data model: At the top level there is a collection of databases, each database contains a collection of tables and stored functions. Each table defines a schema.
In Azure Data Explorer, unlike a typical relational database management systems, there are no constraints like key uniqueness, primary and foreign key. The necessary relationships are established at the query time. The data in Azure Data Explorer generally follows this pattern: Creating Database, Ingesting data, Query the database.