Draft:Kusto Query Language
 | Review waiting, please be patient.
This may take 2–3 weeks or more, since drafts are reviewed in no specific order. There are 439 pending submissions waiting for review.
Where to get help
How to improve a draft
You can also browse Wikipedia:Featured articles and Wikipedia:Good articles to find examples of Wikipedia's best writing on topics similar to your proposed article. Improving your odds of a speedy review To improve your odds of a faster review, tag your draft with relevant WikiProject tags using the button below. This will let reviewers know a new draft has been submitted in their area of interest. For instance, if you wrote about a female astronomer, you would want to add the Biography, Astronomy, and Women scientists tags. Editor resources
Reviewer tools
|
KQL
This article is about the database language.
Kusto Query Language (KQL) (pronounced K-Q-L, or coup-stoh) is a domain main-specific language used to manage data. Microsoft created the language to fit needs that the similar SQL could not handle.[1] While primarily used with Microsoft products, KQL is also compatible with IBM and can be converted to work in Splunk.[2] The exact date of creation of this coding language is not specified by Microsoft. The creators of the language are currently anonymous. KQL's namesake is often attributed as being Academy Award winning filmmaker Jacques Cousteau.[3]
Syntax
In KQL there are options to search by speech type, such as the "hassuffix" and "hasprefix" commands.[4] KQL has several crossovers with SQL (Standard Query Language) such as the utilization of the asterisk (*) as a wildcard.[5] The language has over 15 operators that utilize the exclamation mark.[6]
In Popular Culture
The KC7 Foundation has created a series of games for secondary students and career changers to learn KQL while simulating real world cybersecurity events.[7]
References
- ^ shsagir (2025-02-23). "Kusto Query Language (KQL) overview - Kusto". learn.microsoft.com. Retrieved 2025-03-14.
- ^ "Splunk query using azure KQL concat". community.splunk.com. 2024-06-17. Retrieved 2025-03-14.
- ^ Josephine (2023-12-26). "Kusto (KQL) for Azure SQL Audit". sqlkitty. Retrieved 2025-03-14.
- ^ Morowczynski, Mark (2024). The Definitive Guide to KQL: Using Kusto Query Language for operations, defending, and threat hunting (1st ed.). Microsoft Press.
- ^ Virtuas (2022-10-06). "Microsoft Search KQL Cheat Sheet - VIRTUAS". virtuas.com. Retrieved 2025-03-14.
- ^ "String operators". www.ibm.com. Template:Lastupdated. Retrieved 2025-03-14.
{{cite web}}: Check date values in:|date=(help) - ^ Foundation, KC7. "KC7 - The free cyber detective game". kc7cyber.com. Retrieved 2025-03-14.
{{cite web}}: CS1 maint: numeric names: authors list (link)