Data Types and How to Create Table by using Kusto Query | Kusto Query Language Tutorial (KQL)

Topic: Data Types and How to Create Table by using Kusto Query | Kusto Query Language Tutorial (KQL)

Data Types and How to Create Table by using 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.

 // Data Types and How to Create Table by using Kusto  
   
 .create table Person(  
 isMale:bool,//     boolean     System.Boolean     int8  
 dob:datetime,//     date     System.DateTime     datetime  
 hobbies:dynamic,//     System.Object     array or dictionary or any of the other values  
 upid:guid,          //System.Guid     guid  
 salary:int,          //System.Int32     int  
 phonenumber:long,//          System.Int64     long  
 height:real,     //double     System.Double     real  
 fullname:string,     //     System.String     string  
 weigh:decimal     //     System.Data.SqlTypes.SqlDecimal     decimal  
 )  
   

 //How to insert the data into table  
   
  .ingest inline into table Person <|  
 true,2010-01-01,"{""hobby1"":""Programming"", ""Hobby2"":""Hiking""}",6db865a1-6a09-493d-8027-d27db847fc3f, 4000,5050000999,5.11,Aamir Shahzad,170  
 0,2000-01-01,"{""hobby1"":""Programming"", ""Hobby2"":""Hiking""}",99b865a1-6a09-493d-8027-d27db847fc3f, 3000,7050000999,4.10,Lisa Robert,140  
   

 //How to check the inserted data  
 Person  
   
 Microsoft link for data types in Kusto  
 https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/scalar-data-types/  

Video Demo: Data Types and How to Create Table by using Kusto Query | Kusto Query Language Tutorial (KQL)