504 questions with Azure Data Explorer tags

Sort by: Updated
Updated Created Answers
0 answers

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

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.
504 questions
Azure Role-based access control
Azure Role-based access control
An Azure service that provides fine-grained access management for Azure resources, enabling you to grant users only the rights they need to perform their jobs.
713 questions
asked 2024-07-11T19:42:26.6266667+00:00
Shahnavaz Kazi 0 Reputation points Microsoft Employee
commented 2024-07-11T23:34:41.1766667+00:00
BhargavaGunnam-MSFT 28,926 Reputation points Microsoft Employee
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.
504 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,070 questions
asked 2024-06-12T18:37:13.4033333+00:00
Sailesh Choyal 0 Reputation points
commented 2024-07-11T16:37:01.89+00:00
Sailesh Choyal 0 Reputation points
1 answer

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…

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.
504 questions
asked 2024-07-04T14:35:18.9033333+00:00
Yash Deshpande 0 Reputation points
commented 2024-07-11T07:34:08.96+00:00
PRADEEPCHEEKATLA-MSFT 84,856 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

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.
504 questions
asked 2024-07-08T12:17:05.3666667+00:00
42726446 60 Reputation points
edited a comment 2024-07-09T08:05:56.02+00:00
42726446 60 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.
504 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,055 questions
asked 2024-06-25T12:25:47.8766667+00:00
Ram Ahuja, Roma 0 Reputation points
edited the question 2024-07-03T10:29:01.5066667+00:00
PRADEEPCHEEKATLA-MSFT 84,856 Reputation points Microsoft Employee
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.
504 questions
asked 2024-06-13T13:48:51.8833333+00:00
itay4 36 Reputation points
commented 2024-06-30T14:52:03+00:00
PRADEEPCHEEKATLA-MSFT 84,856 Reputation points Microsoft Employee
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.
504 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 84,856 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.
504 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
2 answers One of the answers was accepted by the question author.

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
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.
504 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.
504 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,891 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.
504 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,630 Reputation points
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.
504 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.
504 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 31,101 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.
504 questions
asked 2024-06-07T09:47:34.85+00:00
Monalisa 60 Reputation points
commented 2024-06-19T03:56:25.03+00:00
PRADEEPCHEEKATLA-MSFT 84,856 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.
504 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 84,856 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.
504 questions
asked 2024-06-07T09:13:14.18+00:00
Saransh Gaur 40 Reputation points Microsoft Employee
answered 2024-06-12T05:51:10.8633333+00:00
PRADEEPCHEEKATLA-MSFT 84,856 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.
504 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 84,856 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.
504 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 84,856 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.
504 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,070 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 8,405 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.
504 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