![](https://it-infrastructure.solutions/content/images/2022/12/image-32.png)
This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage.
Helpful first steps:
Video:
Links:
Tutorial: Kusto queries
This tutorial describes how to use queries in the Kusto Query Language to meet common query needs.
![](https://learn.microsoft.com/en-us/media/logos/logo-ms-social.png)
https://aka.ms/MustLearnKQLhttps://azurecloudai.blog/2021/11/17/must-learn-kql-part-1-tools-and-resources/
Setting up the environment:
Start here:
Register your Cluster and Database here:
![](https://it-infrastructure.solutions/content/images/2022/12/image-84.png)
![](https://it-infrastructure.solutions/content/images/2022/12/image-85.png)
Keep your cluster URL ready:
https://<Cluster-ID>.northeurope.kusto.windows.net
Script to be executed:
.execute database script <|
// Create table for the data
.create-merge table Onboarding(Score:long)
// Import data
.ingest into table Onboarding ('https://kustodetectiveagency.blob.core.windows.net/onboarding/onboarding.csv.gz') with (ignoreFirstRecord=true)
![](https://it-infrastructure.solutions/content/images/2022/12/image-86.png)
![](https://it-infrastructure.solutions/content/images/2022/12/image-87.png)
The Challenge:
Sum up the values in the “Score” column
Show Solution
Onboarding | summarize sum(Score)
![](https://it-infrastructure.solutions/content/images/2022/12/image-93.png)
![](https://it-infrastructure.solutions/content/images/2022/12/image-89.png)
![](https://it-infrastructure.solutions/content/images/2022/12/image-90.png)
![](https://it-infrastructure.solutions/content/images/2022/12/image-91.png)
The Reward:
![](https://it-infrastructure.solutions/content/images/2022/12/image-92.png)
References:
Kusto Detective Agency: Hints and my experience
Kusto Query Language (KQL) overview- Azure Data Explorer
Learn about how to use Kusto Query Language to explore data.
![](https://learn.microsoft.com/en-us/media/logos/logo-ms-social.png)