Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1057404%22%20slang%3D%22en-US%22%3EAzure%20Data%20Explorer%20KQL%20cheat%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1057404%22%20slang%3D%22en-US%22%3E%3CP%3EKusto%20Query%20Language%20is%20a%20powerful%20intuitive%20query%20language%2C%20which%20is%20being%20used%20by%20many%20Microsoft%20Services.%3C%2FP%3E%0A%3CP%3EKQL%20Language%20concepts%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3ERelational%20operators%20(filters%2C%20union%2C%20joins%2C%20aggregations%2C%20%E2%80%A6)%3C%2FSPAN%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-ccp-props%3D%22%7B%26quot%3B335559683%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A360%2C%26quot%3B335559731%26quot%3B%3A0%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335562764%26quot%3B%3A2%2C%26quot%3B335562765%26quot%3B%3A1%2C%26quot%3B335562766%26quot%3B%3A4%2C%26quot%3B335562767%26quot%3B%3A0%2C%26quot%3B335562768%26quot%3B%3A4%2C%26quot%3B335562769%26quot%3B%3A0%7D%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20Each%20operator%20consumes%20tabular%20input%20and%20produces%20tabular%20input%3C%2FSPAN%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-ccp-props%3D%22%7B%26quot%3B335559683%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A360%2C%26quot%3B335559731%26quot%3B%3A0%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335562764%26quot%3B%3A2%2C%26quot%3B335562765%26quot%3B%3A1%2C%26quot%3B335562766%26quot%3B%3A4%2C%26quot%3B335562767%26quot%3B%3A0%2C%26quot%3B335562768%26quot%3B%3A4%2C%26quot%3B335562769%26quot%3B%3A0%7D%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20Can%20be%20combined%20with%20%E2%80%98%7C%E2%80%99%20(pipe).%3C%2FSPAN%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-ccp-props%3D%22%7B%26quot%3B335559683%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A360%2C%26quot%3B335559731%26quot%3B%3A0%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335562764%26quot%3B%3A2%2C%26quot%3B335562765%26quot%3B%3A1%2C%26quot%3B335562766%26quot%3B%3A4%2C%26quot%3B335562767%26quot%3B%3A0%2C%26quot%3B335562768%26quot%3B%3A4%2C%26quot%3B335562769%26quot%3B%3A0%7D%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3ESimilarities%3A%20OS%20shell%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3ELinq%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%20functional%20SQL%E2%80%A6%3C%2FSPAN%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-ccp-props%3D%22%7B%26quot%3B335559683%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A360%2C%26quot%3B335559731%26quot%3B%3A0%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335562764%26quot%3B%3A2%2C%26quot%3B335562765%26quot%3B%3A1%2C%26quot%3B335562766%26quot%3B%3A4%2C%26quot%3B335562767%26quot%3B%3A0%2C%26quot%3B335562768%26quot%3B%3A4%2C%26quot%3B335562769%26quot%3B%3A0%7D%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20Ease%20to%20write%2C%20read%2C%20change%3C%2FSPAN%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-ccp-props%3D%22%7B%26quot%3B335559683%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A360%2C%26quot%3B335559731%26quot%3B%3A0%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335562764%26quot%3B%3A2%2C%26quot%3B335562765%26quot%3B%3A1%2C%26quot%3B335562766%26quot%3B%3A4%2C%26quot%3B335562767%26quot%3B%3A0%2C%26quot%3B335562768%26quot%3B%3A4%2C%26quot%3B335562769%26quot%3B%3A0%7D%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20Statements%3A%3C%2FSPAN%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-ccp-props%3D%22%7B%26quot%3B335559683%26quot%3B%3A1%2C%26quot%3B335559685%26quot%3B%3A1080%2C%26quot%3B335559731%26quot%3B%3A0%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335562764%26quot%3B%3A2%2C%26quot%3B335562765%26quot%3B%3A1%2C%26quot%3B335562766%26quot%3B%3A4%2C%26quot%3B335562767%26quot%3B%3A0%2C%26quot%3B335562768%26quot%3B%3A4%2C%26quot%3B335562769%26quot%3B%3A0%7D%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20Single%20statement%20query%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-ccp-props%3D%22%7B%26quot%3B335559683%26quot%3B%3A1%2C%26quot%3B335559685%26quot%3B%3A1080%2C%26quot%3B335559731%26quot%3B%3A0%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335562764%26quot%3B%3A2%2C%26quot%3B335562765%26quot%3B%3A1%2C%26quot%3B335562766%26quot%3B%3A4%2C%26quot%3B335562767%26quot%3B%3A0%2C%26quot%3B335562768%26quot%3B%3A4%2C%26quot%3B335562769%26quot%3B%3A0%7D%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20Use%20%E2%80%98let%E2%80%99%20for%20reusing%20statements%3C%2FSPAN%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-ccp-props%3D%22%7B%26quot%3B335559683%26quot%3B%3A1%2C%26quot%3B335559685%26quot%3B%3A1080%2C%26quot%3B335559731%26quot%3B%3A0%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335562764%26quot%3B%3A2%2C%26quot%3B335562765%26quot%3B%3A1%2C%26quot%3B335562766%26quot%3B%3A4%2C%26quot%3B335562767%26quot%3B%3A0%2C%26quot%3B335562768%26quot%3B%3A4%2C%26quot%3B335562769%26quot%3B%3A0%7D%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20Multi-statement%20(%E2%80%98%3B%E2%80%99)%20queries%3C%2FSPAN%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EOne%20of%20our%20customers%20released%20a%20cheat%20sheet%20for%20%23KQL%20(Kusto%20Query%20Language).%3C%2FP%3E%0A%3CP%3EDownload%3A%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmarcusbakker%2FKQL%2Fblob%2Fmaster%2Fkql_cheat_sheet_v01.pdf%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fmarcusbakker%2FKQL%2Fblob%2Fmaster%2Fkql_cheat_sheet_v01.pdf%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDocumentation%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fkusto%2Fquery%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFree%20Online%20course%20-%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2FKQLPluralsight%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Faka.ms%2FKQLPluralsight%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3BDoc%20-%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fadx.docs%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fadx.docs%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3BQ%26amp%3BA%20%26nbsp%3B-%20%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2Ftagged%2Fazure-data-explorer%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EStackOverFlow%3C%2FA%3E%2F%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzure-Data-Explorer%2Fbd-p%2FKusto%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3ETechCommunity%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20730px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160852i5B2265FE667D834C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22KQL_cheat_sheet_page_1.png%22%20title%3D%22KQL_cheat_sheet_page_1.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20719px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160853i47D16F2F61F04AFA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22KQL_cheat_sheet_page_2.png%22%20title%3D%22KQL_cheat_sheet_page_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1057404%22%20slang%3D%22en-US%22%3E%3CP%3Eif%20you%20are%20working%20with%20KQL%20%2F%20Kusto%20%2F%20Azure%20Data%20Explorer%20and%20looking%20for%26nbsp%3BKQL%20cheat%20sheet%2C%20this%20post%20is%20for%20you%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20719px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160850i8A891CAF62F2A3B7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22KQL_cheat_sheet_page_2.png%22%20title%3D%22KQL_cheat_sheet_page_2.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20730px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160851i39B12C61B51B1CF4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22KQL_cheat_sheet_page_1.png%22%20title%3D%22KQL_cheat_sheet_page_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1057404%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Explorer%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ekql%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EKusto%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E

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

 

Documentation: here 

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