Suppose you're a data analyst with a passion for meteorological data. You want to use the Kusto Query Language to explore a dataset for answers to basic questions about the kinds and locations of storms in the United States.
What will we be doing?
You'll write simple queries in the Kusto Query Language (KQL) to explore and gain insights from a sample dataset. You'll learn how to:
Count the number of records by using thecountoperator
Return a specific number or rows by using thetakeoperator
Select columns to return by using theprojectoperator
Filter data by using thewhereoperator
Reorder returned data by using thesortoperator
Build queries using multiple operators
What is the main goal?
By the end of this session, you'll be able to write a query with the most commonly used operators: count, take, project, where, sort, and others.