How to move Tables in Folders and Subfolders by Using Kusto | Kusto Query Language Tutorial (KQL)

 Topic: How to move Tables in Folders and Subfolders by Using Kusto | Kusto Query Language Tutorial (KQL)

How to move Tables in Folders and Subfolders by Using Kusto | 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.


 // Add Table To Main Folder  
 .create table Customer(id:int,Name:string)  
 .create table Salary(id:int,Salary:int)  
   

 //Let's move them to Sale Folder  
 .alter table Customer folder @"Sale"  
 .alter table Salary folder @"Sale"  
   

 // Let's create few more Tables  
 .create table AsiaCustomer(id:int,Name:string)  
 .create table EuropeCustomer(id:int,Name:string)  
 .create table NACustomer(id:int,Name:string)  
  
 
 .alter table AsiaCustomer folder @"Region\Asia"  
 .alter table EuropeCustomer folder @"Region\Europe"  
 .alter table NACustomer folder @"Region\NorthAmerica"  
  
 
 //Let's move them out of Asia,Europ and North America and leave them in Region  
 .alter table AsiaCustomer folder @"Region"  
 .alter table EuropeCustomer folder @"Region"  
 .alter table NACustomer folder @"Region"  

   
 // How about without any region at all  
 .alter table AsiaCustomer folder @""  
 .alter table EuropeCustomer folder @""  
 .alter table NACustomer folder @""  
   


Video Demo: How to move Tables in Folders and Subfolders by Using Kusto | Kusto Query Language Tutorial (KQL)

1 comment:

  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