Video series by boB Taylor, intro by Edwin Hernandez
Hello everyone! This time we bring you a series of video tutorials by boB Taylor, who is a member of the Microsoft's Performance & Quality Services Team. He recently completed this video series about Kusto Query Language, and this is a great opportunity for us to compile it into a single place for you along with some introductory information.
What is Kusto Query Language (KQL)?
You may be asking yourself: What is Kusto? What is KQL? And why would this matter for a Quality and Performance Test Blog? Well, Kusto itself was the internal code name for Azure Data Explorer, and Kusto Query Language (KQL) is the primary means of interaction with it. KQL allows you to send data queries, process data, and return the results of this processing without modifying the data or metadata. Now, why would this matter for Test Engineers? Let's first define what Azure Data Explorer can do for you:
Azure Data Explorer
Azure Data Explorer is a service that allows you to store log and telemetry data. It can handle many data streams emitted by several entities concurrently (websites, LOB apps, CRMs, Social data sources, IoT devices, Cloud components, etc.). This data is collected and stored. Data Explorer then provides a way for you to analyze this large volume of data, perform complex queries and drill down into specific events.
Therefore, Azure Data Explorer provides a great way for you to perform diagnostics, monitoring, and reporting of all components of your application and environment. This kind of analysis is key for performance testing and application optimization.
Kusto Query Language(KQL)
KQL is a read-only query language. The syntax is similar to SQL, but it was created specifically to work with large datasets in Azure. Since it's read-only there are no update or delete clauses. It is based on relational management systems, which use schema entities, and is organized into a hierarchy like SQL's databases tables and columns.
Other Azure Services
KQL is the primary mean to query data from Azure Data Explorer; however, it is also used to interact with the following inter-related Azure services:
- Application Insights
- Log Analytics
- Azure Monitor, and again:
- Azure Data Explorer
Microsoft documentation
If you want to learn more from the official Microsoft documentation, make sure to check out the following:
boB Taylor's Video Series
If you are done leafing through the official documentation above and want a much more detailed training. boB created a series of video tutorials where he goes into detail on KQL, from the fundamentals to complex functions, passing through the most common operators:
|
1
|
What is KQL and why should I care?
|
Link to video
|
|
2
|
The Editors or how do I write and execute KQL queries
|
Link to video
|
|
3
|
Our first KQL operators
|
Link to video
|
|
4
|
Wait where can I consume Kusto data?
|
Link to video
|
|
5
|
Summarize
|
Link to video
|
|
6
|
Project, extend, and explain
|
Link to video
|
|
7
|
Distinct, sample-distinct, top, and top-nested
|
Link to video
|
|
8
|
Scalar functions part 1
|
Link to video
|
|
9
|
More scalar operators!
|
Link to video
|
|
10
|
Fun with datetime, timespan and date_part
|
Link to video
|
|
11
|
Conditional logic and strings
|
Link to video
|
|
12
|
Advanced aggregation operators
|
Link to video
|
|
13
|
Let, join, and union
|
Link to video
|
|
14
|
Datatable, prev, next, row_cumsum, and materialize
|
Link to video
|
|
15
|
Range, make-series
|
Link to video
|
|
16
|
Series_decompose family of functions
|
Link to video
|
|
17
|
The remaining time series functions
|
Link to video
|
|
18
|
Machine Learning Plugins
|
Link to video
|
|
19
|
User Analytics Plug-ins
|
Link to video
|
|
20
|
Last on KQL - charting
|
Link to video
|
In Conclusion…
If you want to monitor and diagnose the performance of your application in Azure, KQL is a key resource. It is a good skill to have in your portfolio, especially if you are involved in load testing. Please make sure to check our other article about a Collection of Useful Tool for Performance Test Engineers, and please leave any questions in the comments section.
Thanks!
