Kusto Query Language is a powerful intuitive query language, which is being used by many Microsoft Services.
KQL Language concepts
- Relational operators (filters, union, joins, aggregations, …)
- Each operator consumes tabular input and produces tabular output
- Can be combined with ‘|’ (pipe).
- Similarities: OS shell, Linq, functional SQL…
- Ease to write, read, change
- Statements:
- Single statement query
- Use ‘let’ for reusing statements
- Multi-statement (‘;’) queries
official Azure Data Explorer KQL quick reference page - https://docs.microsoft.com/en-us/azure/data-explorer/kql-quick-reference
One of our customers released a cheat sheet for #KQL (Kusto Query Language).
Download: https://github.com/marcusbakker/KQL/blob/master/kql_cheat_sheet_v01.pdf
Documentation: here
Free Online course - http://aka.ms/KQLPluralsight
Doc - https://aka.ms/adx.docs
Q&A - StackOverFlow/TechCommunity
Updated Jan 30, 2022
Version 6.0Tzvia
Microsoft
Joined September 06, 2018
Azure Data Explorer Blog
Follow this blog board to get notified when there's new activity