Additional Resources

Below are some good resources for getting started with KQL and exploring the language's capabilities.

Kusto 101 - A Jumpstart Guide to KQL - A straightforward introduction to KQL, coming from a SQL point of view.

Microsoft - KQL quick reference - A table of the most commonly used KQL operators/functions with their description and syntax.

Microsoft - SQL to Kusto cheat sheet - A table of commonly used SQL statements and their KQL equivalent.

Microsoft - Query best practices - A selection of best practices to keep in mind when writing KQL queries.

Microsoft - Kusto Query Language - The official KQL language reference. Though this link includes some information about functionality that is not available in the MedChat Custom Reports module (such as working with Azure Data Explorer directly and performing some of the administrative functions), it also includes full documentation on all of the KQL operators and functions. Take note of the Tabular operators, Scalar operators, Scalar functions, and Aggregation functions sections.