KQL cheat sheets

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

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 input​
  • 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​

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

 

Free Online course - http://aka.ms/KQLPluralsight

 Doc - https://aka.ms/adx.docs

 Q&A  - StackOverFlow/TechCommunity

KQL_cheat_sheet_page_1.pngKQL_cheat_sheet_page_2.png

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.