REST API queries to "aria3.kusto.windows.net" versus "kusto.aria.microsoft.com"

Kadri Kukk 0 Reputation points Microsoft Employee
2024-04-15T18:28:18.3366667+00:00

Hello

I am trying to fetch data from 2 databases in Kusto Aria using REST API calls in PowerShell script in .yml pipeline. I am fetching token using MSAL and adding that to auth headers.

QUESTION:

Which URL I should use "aria3.kusto.windows.net" versus "kusto.aria.microsoft.com" (EU cluster is not applicable in my case)?

PROBLEM:

If I use the "aria3.kusto.windows.net", I am able to fetch the needed data without any issues.

However, having seen this manual https://www.aria.ms/developers/deep-dives/eudb-design/#shared-kusto, I understand I should use the "kusto.aria.microsoft.com". But with this URL, I get an error that the database does not exist.

My query looks as follows:

$myHeaders = $headerValues

$body = @{

  "db" =  $myDbName

   "csl" =  $queryAria

}

$jsonBody = $body | ConvertTo-Json

Invoke-RestMethod -Method "Post" -Uri "$aria3ClusterUrl/v1/rest/query" -Headers $myHeaders -Body $jsonBod

Do the DB name and the query need to be encoded somehow, so that it would also work in case of "kusto.aria.microsoft.com"?

Or is it OK to still use "aria3.kusto.windows.net" instead?

Thanks!

Azure Database for MariaDB
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Kadri Kukk 0 Reputation points Microsoft Employee
    2024-04-15T20:22:54.0166667+00:00

    Answer already found! Need to use DB UUID-name, not the friendly name.