How to Create Single or Multiple Tables in Single Statement by using Kusto | Kusto Query Tutorial

 Topic: How to Create Single or Multiple Tables in a Single Statement by Using KUSTO Query.

How to create single or multiple tables in a single file statement 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.

 //.create-merge table  
 // This can be used to create new table. If table does exists then it will add the new columns if specified columns already  
 // does not exist in the table. If you will specify a column with the different data type, then the command will fail. this commend does not   
 // drop columns if not mentioned in column list.  
   
 .create-merge table Customer(CustomerId:int ,CustomerName:string,  
 CustomerAddress:string,  
 Age:int)  
 with (docstring="this is Customer Table",folder ="CustomerData")  
   
 //Let's check the definition of table  
 .show table Customer schema as json   
   
 // add one row data  
 .ingest inline into table Customer <|  
 100,Aamir,SomeAddress,43  
   
 // check data  
 Customer  
   
 // let's rerun and add one more column, phonenumber:string, add add new docstring and move to new folder  
 .create-merge table Customer(  
 CustomerId:int ,  
 CustomerName:string,  
 CustomerAddress:string,  
 Age:int,  
 phonenumber:string)  
 with (docstring="Customer table new definition",folder ="CustomerData1")  
   
   
 //Let's check the definition of table  
 .show table Customer schema as json   
   
 // Show list of tables  
 .show tables  
   
 // check the data  
 Customer  
   
   
 //.create-merge tables : Let you create multiple table in single command  
  .create-merge tables  
  CustomerAsia (Name:string, dob:datetime, UserId:string),  
  CustomerEurope (Name:string, dob:datetime, UserId:string,Region:string)  
   
  //check all tables  
  .show tables  

Video Demo: How to Create Single or Multiple Tables in Single Statement by using Kusto Query Language

4 comments:

  1. I know an organization who have private investigators for hire who can help you get into your spouse’s phones,emails remotely from your phone they can also help you with your
    * credit score
    * clearing of criminal record
    *increasing of school grades etc
    You can confirm for yourself from their email support@wavedrive.tech or website https://wavedrive.tech so you can also give your testimony
    Whatsapp No: +14106350697

    ReplyDelete
  2. Was late on paying my furniture bill 3 months in a row and now my credit score dropped from 745 to 368 and that was devastating. I needed someone to help me improve my score to get it back to the regular limit. Thank you 'Remoterepair @ clerk . Com' for proving to be a good credit agent and helping me clear up the debts thereby improving my credit scores.

    ReplyDelete
  3. I tried getting a car loan some times last year but my credit score ruined the process. I resorted to doing research online on how I could fix my score because I really needed the car that period because of my new job. I bumped into a website “hacksandrecovery dot net” after many searches and I contacted the admin explaining my credit situation. They requested my info and necessary details and they were able to fix my score in under 5 days, I was amazed, they are fast and reliable.
    You can visit their website too for your credit score repair or contact their website admin via whatsapp on +1(571)310-7736

    ReplyDelete
  4. I will only recommend the best here. I can assure you RAYLINK is the best and really good in increasing of credit score, deleting of negatives collections, paying off loans and maxed out credit card debt on your report. He help me get mine done within three days and my score is 821 now and I can proudly say he added 220 points. Thank me later. RAYLINKCYBERSERVICES@GMAIL.COM

    ReplyDelete