Software Development by Patrik

Simple KQL Commands

Count will return the number of rows in the query
Where allows filtering the rows that are returned based on a condition
Take will return a specified number of rows, but no guarantee which rows are returned
Sort will allow sorting the output into an order
Top will return the first N records sorted by the specified column
Extend command allows creating new columns from existing columns or other data such as hard-coded values
Summarize will return the total values for a specific grouping of rows