How to use StormEvents Sample Table for Kusto Queries | Kusto Query Language Tutorial (KQL)

Topic: How to Use StormEvents Sample Table for Kusto Queries.

How to use StormEvents Sample Table for Kusto Queries | Kusto Query Language Tutorial (KQL) Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. The query uses schema entities that are organized in a hierarchy similar to SQL's: databases, tables, and columns. A Kusto query is a read-only request to process data and return results. The request is stated in plain text, using a data-flow model that is easy to read, author, and automate. Kusto queries are made of one or more query statements.

 // how to use sample stormevent table   
 cluster("https://help.kusto.windows.net").database("Samples").StormEvents  
 | take 10  
   
 cluster("https://help.kusto.windows.net").database("Samples").StormEvents  
 | where State =="FLORIDA"  
   
 // get record by state  
 cluster("https://help.kusto.windows.net").database("Samples").StormEvents  
 | summarize count() by State   

Video Demo: How to Use StormEvents Sample Table for Kusto Queries.