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)