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.
shsagirMicrosoft Learn

https://aka.ms/MustLearnKQLhttps://azurecloudai.blog/2021/11/17/must-learn-kql-part-1-tools-and-resources/

Setting up the environment:

Start here:

https://detective.kusto.io/

Register your Cluster and Database here:

https://aka.ms/kustofree

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)

The Challenge:

Sum up the values in the “Score” column
Show Solution Onboarding | summarize sum(Score)

The Reward:

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.
shsagirMicrosoft Learn