How to Add text to point(s) in Kusto Chart
I have a kql script that creates the table here and the line chart below the table. Is it possible to display text on one or more points, as where it says "Champion" in the line chart at bottom?: Query myquery | render linechart with ( …
Data Management Instance Scaling in Azure Data Explorer and VM Reservation Implications
Hello community, I have a question regarding the scaling of Data Management instances in Azure Data Explorer (ADX), focusing on VM types and cost implications. Recently, our ADX setup unexpectedly utilized D2 v2 VMs for data management instead of the…
MULTIJSON data format missing when creating a Data Explorer data connection in the Azure Portal
When creating a data connection from ADX/Kusto to EventHub, I would like to choose the MULTIJSON data format. If I recall correctly, this option was available in the Azure Portal, but there is only the JSON format now (see screenshot). The docs still…
Questions about tdigest* KQL functions
In the documentation for the tdigest function, it shows sample outputs in the following format but doesn't explain what each of the nested arrays represent. [[n],[a,b,c],[d,e,f]] It appears the second array is every unique sample that was in the input…
Cannot view data lake gen 2 containers using analytics synapse linked service view (even with the contributor permission granted)
Each time i try to view the contents of a data lake gen 2 container using the portal 'Data' tab. I get the following error; 'Storage Explorer Error Uncaught ReferenceError: O is not defined.' I have already given the resource and myself, the storage…
ADX/KQL through SQL linked server
Hello, Recently we have created a linked server in SQL Server and connection operates well. This link server targets an ADX cluster, and a named database.Nevertheless, I admit that I am quite familiar with SQL language, but I never been able to retrieve…
Azure Data Explorer: effective costs different than pricing calculator
Dear community I have created an Azure Data Explorer cluster, as a dev/test environment. The pricing calculator was estimating a certain amount for this setup but thereal cost is higher than that. Looking into the details it seems that the cluster has…
Unable to update Azure kusto callout policy
I am trying to update Azure kusto's callout policy using below command: .alter-merge cluster policy callout [{ "CalloutType": "external_data", "CalloutUriRegex": "<
How to pass multiple values to parameter at once in Azure Data Explorer dashboard
I want to search for multiple values . For example 10 - 15 values at once I cannot use "Multiple Selection parameter " as it impacts performance, time to run a initial all values query and then manually searching and selecting required value in…
How to fix MAC signature found in the HTTP request is not the same as the computed signature. Server used following string to sign , in cosmosdb after key rotation
I rotated all the keys at once in the keys plane on the portal. (All older than 470 days). After that getting: Message: {"Errors":["The MAC signature found in the HTTP request is not the same as the computed signature. Server used…
How to run a purge command in ADX using ADF?
Approach 1 Created an ADX activity in ADF, and in the command field, I wrote the purge command (which I copied from Azure Docs): .purge table MyTable in database DBName allrecords I tried running the purge command but it keeps returning syntax error:…
Cannot Open ADT Explorer
I checked in role assignments, and I am the owner. I get the following JSON response in my browser when I try to open the explorer…
How to disable the "Create a free cluster" redirect on first Data Explorer login?
I teach my students how to use KQL to search in Data Explorer and Sentinel. To accomplish that, I have the following workflow: Create a database in a Data Explorer cluster I own Create a new Azure user Assign that new Azure user permission to read…
Can we connect ADX to Databricks, without using App Registration.?
I am trying to Access ADX data into Databricks, but failing to configure connection between databricks and ADX. I don't have permissions to use App registration. Is there any way to do with managed identity or any other alternative.
404 Error when Performing Actions in Azure Data Explorer with Client Credentials
I am currently working on an application that utilizes Azure Data Explorer, and I am attempting to use client credentials for authentication. While I have successfully authenticated, I encounter a 404 error whenever I attempt to perform any actions. Here…
How to optimize ADX Cluster with very high CPU usage?
We're currently using 3 nodes in our ADX cluster, which are experiencing extreme workload due to running very heavy calculations that result in long periods (between 30-60 mins) of 100% CPU usage of the cluster (all nodes) The calculation can, and will,…
Unable to install DLLs for MATLAB per help doc
https://learn.microsoft.com/en-us/azure/data-explorer/query-matlab?tabs=windows This is the link where i found help page to install DLLs in MATLAB to proceed for Azure authentication from MATLAB. The initial lines of the document asks to download latest…
Azure Data Explorer: Alerts not triggering
Dear community After seeing this link, I decided to setup alerts in ADX. I follow the procedure and able to see the results of the query, however no alerts seem to be triggered: below you can see a couple of screenshots, any help is highly…
Upload data to Microsoft Azure Storage Explorer
How can I upload large encrypted data from my hard drive to Microsoft Azure Storage Explorer into a Blob Container? Each time I try, I encounter the error "failed, error: UnexpectedCancel (used SAS, overwrite enabled completed)" or…
Encountered Error When Recreating Azure Kusto Cluster: Name Already Taken
Hello, I recently removed an existing Kusto cluster from Azure using the "az kusto cluster remove" command. However, when attempting to recreate a new cluster with the same name, I encountered the following error message: "Name 'XXXX'…