Print Operator in Kusto Query | Kusto Query Language Tutorial (KQL)

 Topic: Print Operator in Kusto Query Language

Print Operator in Kusto Query | 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.

 //Print Function   
 // Can be used to print out values  
   
 print 'TechbrothersIT'  
   
 print "Aamir Shahzad"  
   
 //Perform some calculations and print results  
 print 4*3  
   
 // Give name to results ( Column Name)  
 print results= 4*3  
   
 //Use Variable and Print Variable Value  
 let abc=4;  
 print abc;  
   
 //Save results of Query in variable and then print  
 let RecordCount = TotalSale  
  | count;  
  //print TotalRecords = toscalar(RecordCount)  
   
  //Save results of Query in variable and then print  
 let TotalItemsSold = TotalSale  
  | summarize sum(ItemsSold);  
  //print TotalRecords = toscalar(TotalItemsSold)  
   
 //Print Multiple Variables  
  print ItemCount = toscalar(RecordCount), ItemSold = toscalar(TotalItemsSold)  

Video demo: Print Operator in Kusto Query | Kusto Query Language Tutorial (KQL)

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.