Beta version of this site

This site is a work in progress, currently in its beta phase, and I'm thrilled to share it with you as it takes shape. While some links, images, and features are still being polished.

Thank you for visiting! I hope you’ll check back in a few weeks to see the final version and explore more.

You are also welcome on my blog at dcode.bi.

The KQL language

KQL (Kusto Query Language) is a query language developed by Microsoft, specifically designed for querying large datasets, typically in cloud-based environments like Azure. It originated from a service called Kusto, which was initially developed for the internal needs of Microsoft for handling massive amounts of telemetry data, logging, and diagnostic data. Over time, it evolved into a more generalized query language, applicable to a variety of data analytics applications in the cloud.

KQL is a specialized query language tailored to meet the demands of querying large, real-time datasets, particularly in the realms of telemetry, monitoring, and log analytics. Originating from the internal Kusto engine at Microsoft, KQL has evolved to become a key language in the Azure ecosystem, allowing users to perform powerful data analysis and diagnostics across a variety of use cases. Its design reflects a blend of performance, scalability, and ease of use, making it an essential tool for modern cloud-based data environments.

The sections

Queries

This section contains the documentation for the data selection and manipulation.

Read more

Management

Here you will find the documentation for the management part of KQL.

Read more

API

The KQL language also has API capabilities, find the documentation here.

Read more


About this Reference

This KQL reference contains information on the KQL language. The Guide is updated regularly to reflect the latest changes in Microsoft products. Each documentation part is presented with a syntax, supporting articles and often with examples.

While this KQL Guide is a ProBI project created and maintained by Brian Bønk, it also incorporates official Microsoft documentation to provide you with the most accurate and up-to-date information.

It has taken inspiration from the dax.guide and powerquery.how websites which does something similar for the DAX and PowerQuery language. From these sites, I’ve gotten guides and support to understand their way of working - a huge shout out to those sites and the teams behind them. Go take a look at their guides - they are really useful for both DAX and Power Query.