Serialize Operator Add Row Numbers to Result Sets | Kusto Query Language Tutorial (KQL)

Topic: Serialize Operator Add Row Numbers to Result Sets in Kusto Query Language

In this article, we are going to learn how to use a serialized operator in Kusto Query Language, Serialize Operator marks that the order of the input row set is safe to use for windows functions. 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.

 //serialize - Marks that the order of the input row set is safe to use for window functions.  
 // .drop table Customer  
 .create table Customer(CustomerId:int, Name:string)   
  .ingest inline into table Customer <|  
 1,Aamir  
 1,Raza  
 2,Lisa  
 3,steve  
 int(null),aamirtest  
 4,aamir  
 // Adding Row numbers to results  
 Customer   
 |serialize rn=row_number()  
 Customer   
 | order by Name asc   
 |serialize rn=row_number()  
 Customer   
 | order by tolower(Name) asc   
 |serialize rn=row_number()  

Video Demo: Serialize Operator Add Row Numbers to Result Sets | Kusto Query Language Tutorial (KQL)