Hey there! Have you heard of Kusto Query Language (KQL)? It’s a powerful querying language that’s becoming widely used across several Azure services, like Azure Monitor, Azure Data Explorer, and Microsoft Fabric.
So, how do you get started with KQL? Sure, you could comb through pages of documentation, but there’s a more engaging way: the Kusto Detective Agency! It’s a clever gamified experience from Microsoft where you can learn KQL by solving intriguing detective cases.
Curious? Join me in this video as I tackle the first case. Let’s dive in and have some fun!
▬▬▬▬▬▬ IMPORTANT LINKS ▬▬▬▬▬▬
My LinkedIn profile: https://www.linkedin.com/in/piotr-tybulewicz-81a8793/
My GitHub with drawings and source code: https://github.com/TybulOnAzure/StandaloneEpisodes
Kusto Detective Agency: https://detective.kusto.io/
SQL cheat sheet: https://learn.microsoft.com/en-us/kusto/query/sql-cheat-sheet?view=microsoft-fabric
Join types: https://learn.microsoft.com/en-us/kusto/query/join-operator?view=azure-data-explorer&preserve-view=true&pivots=azuredataexplorer#default-join-flavor
▬▬▬▬▬▬ MEMBERSHIP ▬▬▬▬▬▬
Join this channel to get access to perks:
https://www.youtube.com/channel/UCLnXq-Fr-6rAsCitq9nYiGg/join
▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬
00:00 Introduciton
00:15 KQL overview
02:04 Kusto Detective Agency
10:25 Your first KQL query
12:26 Syntax of KQL queries
14:44 The 1st real case
26:02 Solving the case
52:14 Summary