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:


Tutorial: Kusto queries
This tutorial describes how to use queries in the Kusto Query Language to meet common query needs.

Setting up the environment:

Start here:

Register your Cluster and Database here:

Keep your cluster URL ready:


Script to be executed:

.execute database script <|
// Create table for the data
.create-merge table Onboarding(Score:long)
// Import data
.ingest into table Onboarding ('') with (ignoreFirstRecord=true)

The Challenge:

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

The Reward:


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.