501 questions with Azure Data Explorer tags

Sort by: Updated
Updated Created Answers
1 answer

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…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-06-24T08:22:35.46+00:00
ADX user123 0 Reputation points
commented 2024-06-28T02:21:28.5066667+00:00
PRADEEPCHEEKATLA-MSFT 83,886 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

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,…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-06-03T08:36:02.5766667+00:00
Ori Bandel 20 Reputation points
edited an answer 2024-06-26T06:40:48.55+00:00
Ori Bandel 20 Reputation points
0 answers

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:…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,975 questions
asked 2024-06-12T18:37:13.4033333+00:00
Sailesh Choyal 0 Reputation points
edited a comment 2024-06-25T13:36:25.0666667+00:00
Sailesh Choyal 0 Reputation points
1 answer

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.

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,038 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,272 questions
asked 2024-06-25T12:25:47.8766667+00:00
Ram Ahuja, Roma 0 Reputation points
answered 2024-06-25T13:27:06.6633333+00:00
PRADEEPCHEEKATLA-MSFT 83,886 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Unable to install DLLs for MATLAB per help doc

https://video2.skills-academy.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
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-06-14T05:04:05.56+00:00
Vishal Vinayak Kulkarni 20 Reputation points
accepted 2024-06-25T08:29:46.92+00:00
Vishal Vinayak Kulkarni 20 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-06-24T07:02:22.94+00:00
Matteo Traina 40 Reputation points
accepted 2024-06-25T07:29:23.22+00:00
Matteo Traina 40 Reputation points
1 answer

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…

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,852 questions
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-06-24T15:14:15.6766667+00:00
David Taylor 0 Reputation points
edited an answer 2024-06-24T17:07:12.69+00:00
Adharsh Santhanam 2,320 Reputation points
0 answers

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…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-06-13T13:48:51.8833333+00:00
itay4 36 Reputation points
commented 2024-06-24T07:30:34.3766667+00:00
PRADEEPCHEEKATLA-MSFT 83,886 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

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'…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-03-26T10:10:50.81+00:00
Rezgui, Bilel 35 Reputation points
commented 2024-06-20T12:33:25.5266667+00:00
Chris Lowndes 0 Reputation points
1 answer

Azure Data Explorer dashboard parameter cannot show long string

I am trying to create a filterable string parameter in the Azure Data Explorer dashboard. The to-be-filtered strings are long and they cannot be shown completely in the filter bar. I tried hover on the string. There is preview of the complete text. And…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-06-20T03:28:51.09+00:00
Simona Meng 0 Reputation points Microsoft Employee
answered 2024-06-20T05:47:09.6133333+00:00
Sander van de Velde | MVP 30,711 Reputation points MVP
1 answer

Kusto query to get the below details CSV format

Kusto query to get the below details CSV format usedIpAddress connected or isolated to which backend (connected device) PrivateIPv4address , attached to ,attached type

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-06-07T09:47:34.85+00:00
Monalisa 20 Reputation points
commented 2024-06-19T03:56:25.03+00:00
PRADEEPCHEEKATLA-MSFT 83,886 Reputation points Microsoft Employee
1 answer

An admin command cannot be executed temporarily due to an internal state transition

We have an ADX cluster with two instances and java service querying external tables using jdbc sql driver. We ran a performance test, more than 3k requests. We saw many db query errors with this message: An admin command cannot be executed…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-05-31T22:51:48.55+00:00
_Esteban Bett 30 Reputation points
commented 2024-06-14T05:53:45.08+00:00
PRADEEPCHEEKATLA-MSFT 83,886 Reputation points Microsoft Employee
1 answer

Writing Kusto queries through code, looking for JSON format conversion to Kusto queries with limited functionality

We are moving the alert triggering conditions to our codebase (C++). Currently, these conditions are written as KQL queries on the Azure portal. We are creating logic that can convert JSON format values to KQL. The generated KQL query will be simple and…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-06-07T09:13:14.18+00:00
Saransh Gaur 20 Reputation points Microsoft Employee
answered 2024-06-12T05:51:10.8633333+00:00
PRADEEPCHEEKATLA-MSFT 83,886 Reputation points Microsoft Employee
0 answers

Use certificate/FIC for Azure Data Explorer service connector on ADO

Hi team, our current azure data explorer service connector uses service principal key and secrets to authenticate. However, in response to a security incident we're solving, we need to convert the service connector to use SNI and certificates for…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-05-06T23:28:45.5266667+00:00
03318626 35 Reputation points Microsoft Employee
commented 2024-06-03T07:05:00.4766667+00:00
PRADEEPCHEEKATLA-MSFT 83,886 Reputation points Microsoft Employee
2 answers

Why do I get error for cross querying in Kusto

I can run my function successfully in local cluster but get errors while running in other clusters: Errors occurred while resolving remote entities. Cluster='https://dummy.kusto.windows.net/', Database='DummyDB': Semantic error: Schema of the stored…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-05-13T19:29:40.3966667+00:00
Heidi Zhang 0 Reputation points Microsoft Employee
commented 2024-06-03T07:04:23.24+00:00
PRADEEPCHEEKATLA-MSFT 83,886 Reputation points Microsoft Employee
2 answers

Issue while connecting Kusto DB from Azure Data Factory using Service Principal Id and Certificate

We are trying to migrate to Service Principal Id and Certificate authentication to connect to Azure Data Explorer DB through Azure Data Factory Linked service. We are authenticating our .Net Applications from the same AME Certificate and AME Service…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,975 questions
asked 2024-05-24T05:05:26.7966667+00:00
Sandeep Shekhar 0 Reputation points Microsoft Vendor
commented 2024-05-27T05:07:44.29+00:00
phemanth 7,825 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to delete data from Kusto table

I'm trying to use the .delete command instead of purge to remove data from a table. As, .delete does not change the ingestion timestamp, or the tags created and helps to restate the data when needed. The .delete command performs a soft delete, making…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-05-24T17:34:48.1466667+00:00
Sujatha Erepalli (Brillio LLC) 20 Reputation points Microsoft Vendor
edited a comment 2024-05-24T20:05:19.0233333+00:00
Sujatha Erepalli (Brillio LLC) 20 Reputation points Microsoft Vendor
0 answers

Azure DataExplorer - autorization code

I want to create the token using the authorization code flow, I use this scope: https://management.azure.com/.default but I keep getting this error: 'HTTP/1.1 401 Unauthorized\r\n' header: WWW-Authenticate: Bearer…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-05-13T07:58:55.7766667+00:00
itay4 36 Reputation points
commented 2024-05-16T18:54:43.18+00:00
BhargavaGunnam-MSFT 28,356 Reputation points Microsoft Employee
1 answer

Graph Match operator error when project is not specified

I'm going through examples here: https://video2.skills-academy.com/en-us/azure/data-explorer/kusto/query/graph-match-operator I'm attempting to use an anonymous node and edge combinations to get all matching nodes with the pattern ()--[]--() which to my…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
asked 2024-05-10T22:37:39.98+00:00
Waruna Yapa 0 Reputation points Microsoft Employee
edited a comment 2024-05-13T15:05:31.45+00:00
Waruna Yapa 0 Reputation points Microsoft Employee
3 answers

Using Conditional Formatting/ Formula to Compare Two Dates

I am trying to compare two dates in a large data sheet as a Success or Failure depending on the Ship Date. For example, on the first line, the Ship Date is 2/29/2024 which is after the due date (-1 of 2/26/2024), making it a failure. The Expected…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,186 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,975 questions
asked 2024-03-19T12:49:22.49+00:00
Villa, Carissa 0 Reputation points
commented 2024-05-10T22:52:26.52+00:00
BhargavaGunnam-MSFT 28,356 Reputation points Microsoft Employee