Onboarding to the Kusto Detective Agency (Part 1)

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:

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

The Reward:

References: