Answer already found! Need to use DB UUID-name, not the friendly name.
REST API queries to "aria3.kusto.windows.net" versus "kusto.aria.microsoft.com"
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!
1 answer
Sort by: Most helpful
-
Kadri Kukk 0 Reputation points Microsoft Employee
2024-04-15T20:22:54.0166667+00:00