How to Add or Remove Columns in Table by Kusto Query | Kusto Query Language Tutorial (KQL)

Topic: How to Add or Remove Columns in Table by Kusto Query | Kusto Query Language Tutorial (KQL)

How to Add or remove columns in the table by Kusto Query language | 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.



 // How to Add or Drop Columns to existing table by using .alert-merge and .alter table  
   
 //.alter-merge  
 //Columns that don't exist and which you specify, are added at the end of the existing schema.  
 //If the passed schema doesn't contain some table columns, the columns won't be deleted.  
 //If you specify an existing column with a different type, the command will fail.  
   
 .create table MyTable(id:int)  
  
 
 //ingest some data into the table   
 .ingest inline into table MyTable <|  
 100  

   
 // Add two more columns   
 MyTable  
 .alter-merge table MyTable (Name:string, Address:string)   
   
 MyTable  
 //insert some data  
 .ingest inline into table MyTable <|  
 101,aamir,fake address  
   
 // run the statement with existing columns  
 .alter-merge table MyTable (Address:string,phonenumber:string)   
   
   
 //.alter table  
 //The table will have exactly the same columns, in the same order, as specified. Specify the table columns:  
 //If existing columns aren't specified in the command, they'll be dropped and data in them will be lost, like with the .drop column command.  
 //When you alter a table, altering a column type isn't supported. Use the .alter column command instead.  
 //.alter table works in little different way  
 .create table Customer(Customerid:int)  
  
 
 .ingest inline into table Customer <|  
 100  
   
 // check data  
 Customer  
   
 //check the schema of a table in Kusto  
 .show table Customer cslschema  
   
 .alter table Customer(customerName:string,address:string)  
 .alter table Customer(address:string,customerName:string)  
   
 // check the data  
 Customer  
   
 //ingest data   
 .ingest inline into table Customer <|  
 Aamir,fakeaddress1  
 
  
 //add new column phone number and make sure existing columns address and CustomerName do not drop  
 .alter table Customer(address:string,customerName:string,phonenumber:string)  
   
 //check the data  
 Customer  
   
 // ingest some data  
 .ingest inline into table Customer <|  
 Aamir,fakeaddress1,505-xxxx-0000  
   
 //check the data  
 Customer  
   
 //drop column phone number from Customer table, simple exclude the column from .alter table list you want to drop  
 .alter table Customer(customerName:string,address:string)  
   
 //Check if column dropped  
 Customer  
   

Video Demo: How to Add or Remove Columns in Table by Kusto Query | Kusto Query Language Tutorial (KQL)

3 comments:

  1. Servo Drive offers you long lasting, quality work that will not disappoint you. Reliability, safety and quality control are the advantages of this manufacturer who can give you the best products. It offers high flexibility in integration and data exchange, making it the ideal choice for today's industrial environments. So be sure to make your choice in its favor.

    ReplyDelete
  2. SYNACK TECH IS FAST AND EFFECIENT
    You really need to be careful of the risk involved in the world of cryptocurrency and investments. I was naive enough to believe I could make huge returns from my cryptocurrency investments without doing proper research about it. I lost $543,000 worth of USDT and BTC in a failed cryptocurrency investment scheme. Luckily for me, I was able to reach out to a reputable cryptocurrency recovery company that goes by the name Synack Tech and was able to successfully recover all the money I had invested into the scheme. {{{s y n a c k h a c k @ t e c h | - | c e n t e r | d o t | c o m }}} I’m forever grateful to the services of Synack Tech and this message is a recommendation to everyone who intends to recover lost digital assets of any kind. Not only are they fast but also reliable and they update you on the progress accordingly.

    ReplyDelete
  3. HARNESS THE EFFECIENCY OF CRYPTO RECOVERY-SYNACK TECH
    I came across SYNACK TECH which is an exceptional and highly reputable private licensed investigation firm based in the states that i had the privilege of engaging with after my company suffered a loss of $950,000 worth of btc due to a mistaken transfer to an unknown account by our financial accountant. Despite our desperate attempts to recover the funds through traditional channels and various recovery firms, we were met with disappointment and further financial losses. However, our fortunes changed when we discovered SYNACK TECH. Upon contacting them, their team of skilled professionals' swiftly and effectively managed to recover $830,300 of our lost funds, bringing immense relief and peace to our company. Their dedication and expertise were truly impressive, and their ability to successfully recover such a significant portion of the lost funds is a testament to their exceptional capabilities in the realm of cryptocurrency recovery. I wholeheartedly recommend SYNACK TECH for any hacking services and crypto recovery needs as their outstanding performance has not only mitigated the financial impact on our company but also restored faith in the possibility of recovering lost assets in the complex world of cryptocurrency. This experience has highlighted the invaluable importance of seeking out a reputable and skilled professionals like SYNACK TECH when faced with similar challenges, as their proficiency and commitment to their clients' success are truly unique and unmatched. With their extensive knowledge and unwavering dedication, SYNACK TECH has proven to be an invaluable asset in navigating the complexities of cryptocurrency recovery, providing hope and a lifeline for those who have experienced significant financial losses in the digital asset space. Their swift and effective actions have not only mitigated the devastating impact of our financial loss but have also restored our confidence in the possibility of recovering lost assets in the intricate world of cryptocurrency. I cannot overstate the level of gratitude and admiration we hold for SYNACK TECH, as they have not only demonstrated unmatched expertise but have also exhibited a deep commitment to their clients’ success. If you in a similar predicament reach out to SYNACKHACK {@} TECH {-} CENTER {DOT} COM

    ReplyDelete