Understand the basic structure of a Kusto query
Organizations in all sectors deal with a constant flow of data, and need to turn that data into meaningful, actionable insights. In the meteorological scenario, you've obtained a dataset with storm data from the US. In this unit, you'll learn about the basic structure of the Kusto Query Language (KQL) so that you can use it to analyze and interpret this dataset.
What's a Kusto query?
A Kusto query is a read-only request to process data and return results. The request is stated in plain text that's easy to read, author, and automate. A Kusto query has one or more query statements and returns data in a tabular or graph format.
Tabular query statements contain zero or more operators. Each operator starts with a tabular input and returns a tabular output. Operators are sequenced by a pipe (|). Data flows—or is piped—from one operator to the next. The data is filtered or manipulated at each step and fed into the following step.
Think of it like a funnel, where you start out with an entire data table. Each time the data passes through another operator, it's filtered, rearranged, or summarized. Because the piping of information from one operator to another is sequential, the query's operator order is important. At the end of the funnel, you're left with a refined output.
These operators are KQL-specific, although they often have parallels to SQL or other languages.
Let's look at an example query:
StormEvents
| where StartTime between (datetime(2007-11-01) .. datetime(2007-12-01))
| where State == "FLORIDA"
| count
The query begins with a reference to a table called StormEvents and contains the operators where and count. Each operator is separated by a pipe. The data rows for the source table are filtered by the value of the StartTime column, then filtered by State column's value. In the last line, the query returns a table with a single column and a single row that contains the count of the remaining rows.
In the next units, you'll connect to a dataset and learn about some of the most commonly used operators. Then, you'll use the operators to answer questions about a sample dataset that contains US meteorological data.