Database Management Commands For Azure Data Explorer by using Kusto Query

Topic: Database Management Commands For Azure Data Explorer by using Kusto Query


Database Management Commands For Azure Data Explorer 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.


 //Database Control Commands  
   
 .show databases     //Returns a table in which every record corresponds to a database in the cluster that the user has access to  
 .show database     //Returns a table showing the properties of the context database  
 .show cluster databases     //Returns a table showing all databases attached to the cluster and to which the user invoking the command has access  
 .alter database prettyname //     Alters a database's pretty (friendly) name  
 .show database schema     //Returns a flat list of the structure of the selected databases with all their tables and columns in a single table or JSON object  
 .execute database script     //Executes batch of control commands in scope of a single database  
   

 .show databases   
 .show database   
 .show cluster databases   
 .alter database techbrothersdb prettyname 'demo'  

   
 // create multiple tables in a database by using Kusto  
 .execute database script <|  
 //create new table  
 .create table customer(customerid:int,customerName:string)  
 //create another table  
 .create table Sale(salid:int,productname:string)  
 
  
 //Show list of Tables with data types by using Kusto  
 .show database schema   
 
  
 // Drop multiple tables in Azure Data Explorer Database by using Kusto  
 .execute database script <|  
 //create new table  
 .drop table customer  
 //create another table  
 .drop table Sale  

Video Demo: Database Management Commands For Azure Data Explorer by using Kusto Query

4 comments:

  1. Best No Deposit Casinos 2021
    What is a No Deposit Bonus? — These 화이트 벳 offers include free spins for new players, e sport no deposit bonuses that can be used for 카드 카운팅 casino play and real 우리계열 money max88 games. It

    ReplyDelete
  2. HOW CAN I RECOVER MY LOST CRYPTO ? CRYPTO SCAM VICTIMS RECOVER THEIR LOST FUNDS THROUGH LOST RECOVERY MASTERS.

    The Lost Recovery Masters is a team of experienced Crypto Experts currently collecting funds back to all scam victims. Anyone that has fallen prey to these fake online imposters and bogus investments Schemes contact Lost Recovery Masters and explain your situation; They will assist you in all crypto scam retrieval funds, bitcoin wallets reclaiming, investment scam, mobile mass surveillance, and cyber - attacks. 

    Support team Mail: (lostrecovemast@mail.com        
    WhatsApp: +1(204)819-5505.

    Don't forget to mention 
     Michelle Brice referred you.

    ReplyDelete


  3. DO YOU LOST YOUR CRYPTO? YOU WANT TO RECOVERY YOUR STOLEN BITCOIN,
    FINALLY I GOT MY LOST BITCOIN BACK ALL THANKS TO KEVIN M HACKER

    VIA. Email: kevinmitnick100@hackermail.com, Telegram @Kelvinmhacker or WhatsApp via: +1-256-956-4498

    ReplyDelete
  4. RECOVER STOLEN CRYPTO ASSETS-SYNACK HACKERS
    The last thing I expected to be able to do was recover a total of $ 57530 USDT lost in my account, but fortunately Synack Hackers, a special team of authorized hackers, came to my aid. I had to seek assistance from the team who were able to regain my account in a matter of 48 hours after it had been lost to an internet imposter who pretended to be a broker and had denied me access for more than a month. They provided amazing services and were a pleasure to work with. Should you require their assistance? Synack Hackers is reachable via [s y n a c k h a c k e r s @ p r o t o n (.) m e ]

    ReplyDelete