Kusto Detective Agency: Chall #4

Chall #4 Solution

Create the prime number table and import the data to your cluster:

.execute database script <|
.create-merge table PrimeNumbers (PrimeNumber: int)
.ingest async into table PrimeNumbers (@'https://kustodetectiveagency.blob.core.windows.net/prime-numbers/prime-numbers.csv.gz')

Now you can calculate the prime number and generate the URL

let SpecialPrimeNumberCandidates = PrimeNumbers
| sort by PrimeNumber asc 
| project PrimeNumber = toint(1 + PrimeNumber +  prev(PrimeNumber)), Number1= prev(PrimeNumber), Number2 = PrimeNumber
| where PrimeNumber < 100000000;
SpecialPrimeNumberCandidates
| join kind=inner PrimeNumbers on PrimeNumber
| top 1 by PrimeNumber desc 
| project url = strcat("https://aka.ms/", tostring(PrimeNumber))

you have now the URL : The URL is https://aka.ms/99999517

Visiting this URL you will get below hints

Well done, my friend. It’s time to meet. Let’s go for a virtual sTREEt tour… Across the Big Apple city, there is a special place with Turkish Hazelnut and four Schubert Chokecherries within 66-meters radius area. Go ‘out’ and look for me there, near the smallest American Linden tree (within the same area). Find me and the bottom line: my key message to you. Cheers, El Puente.

PS: You know what to do with the following:

• «
• 1
• 2
• 3
• »