Analyzing Data Stores

A Kusto query is a read-only request that processes data that is organized into a hierarchy of databases, tables, and columns, similar to SQL. Query statements are separated by a ;, and only affect the query at hand. There are 3 kinds of user query statements: tabular expression statements, let statements, and set statements. The most common kind is the tabular expression statement where the input and the output consist of tables....

contains the database referenced in this document. Count rows How many storm records are there in the table? Count 59066 StormEvents | count count returns a table with a single column and a single row containing the count of the remaining rows. The output is not a scalar value. See a sample of data Sample N rows from the StormEvents table....

Aggregation functions allow you to group and combine data from multiple rows into a summary value. contains the database referenced in this document. Use the summarize operator Find the number of events by state. State TotalStorms TEXAS 4,701 KANSAS 3,166 … … StormEvents | summarize TotalStorms = count() by State summarize groups together rows based on the by clause and uses the aggregation function to combine each group into a single row....