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.
490 questions
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…
asked 2024-05-13T19:29:40.3966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 80%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHZ%3C/text%3E%3C/svg%3E)
Heidi Zhang
0
Reputation points Microsoft Employee
commented 2024-06-01T02:27:29.8133333+00:00
Heidi Zhang
0
Reputation points Microsoft Employee
0 answers
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…
asked 2024-05-31T22:51:48.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E_B%3C/text%3E%3C/svg%3E)
_Esteban Bett
30
Reputation points
asked 2024-05-31T22:51:48.55+00:00
_Esteban Bett
30
Reputation points
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…
asked 2024-05-06T23:28:45.5266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 71%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E0%3C/text%3E%3C/svg%3E)
03318626
35
Reputation points Microsoft Employee
commented 2024-05-30T07:29:59.8266667+00:00
PRADEEPCHEEKATLA-MSFT
80,491
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…
asked 2024-05-24T05:05:26.7966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 17%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sandeep Shekhar
0
Reputation points Microsoft Vendor
commented 2024-05-27T05:07:44.29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
6,885
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…
asked 2024-05-24T17:34:48.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 49%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
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…
asked 2024-05-13T07:58:55.7766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 28.000000000000004%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
itay4
31
Reputation points
commented 2024-05-16T18:54:43.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
27,976
Reputation points Microsoft Employee
1 answer
Graph Match operator error when project is not specified
I'm going through examples here: https://learn.microsoft.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…
asked 2024-05-10T22:37:39.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 39%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWY%3C/text%3E%3C/svg%3E)
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…
asked 2024-03-19T12:49:22.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 32%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
Villa, Carissa
0
Reputation points
commented 2024-05-10T22:52:26.52+00:00
BhargavaGunnam-MSFT
27,976
Reputation points Microsoft Employee
2 answers
How to ingest data in ADX using python script
I am using free trial and trying to ingest data into ADX using python SDK but facing this issue An error occurred: Principal 'msauser=1:live.com:00037FFE6E855292' is not authorized to perform operation 'Ingest' on 'any database'.
asked 2024-05-02T09:39:20.6033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Pranav Kumar
0
Reputation points
commented 2024-05-10T22:51:49.8133333+00:00
BhargavaGunnam-MSFT
27,976
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Is it possible to automate trusting an Azure Data Explorer database connection?
We dynamically create Azure users and generate a database for each user in our Azure Data Explorer cluster. There is a security feature in Data Explorer that asks the user whether they want to trust the connection to the database (see attached…
asked 2024-05-02T13:13:42.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 74%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E4%3C/text%3E%3C/svg%3E)
42726446
20
Reputation points
commented 2024-05-08T11:00:13.6266667+00:00
Sander van de Velde
29,856
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 71%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
Azure Data Explorer and other integration is not listed under the integration
Hi Team, I would like to integrate the Microsoft Azure Data Explorer in Viva. However it is not listed in the organization dashboard. Can someone help us on this? Though it is given on the search input, no results are found
asked 2023-12-06T11:25:33.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 55.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jeyeline M
0
Reputation points
commented 2024-05-07T16:53:11.24+00:00
Jeyeline M
0
Reputation points
1 answer
One of the answers was accepted by the question author.
How can I schedule materialized view (refresh daily data at EOD )in data explorer?
Hi, currently I 'have setup one materialized view, but I want to update view on at end of the day. Currently it's getting updated in near time. Is it possible in materialized view to schedule query on daily basis only ?
asked 2024-04-04T14:30:24.52+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 53%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Khushbu Kella
20
Reputation points Microsoft Employee
accepted 2024-05-02T06:34:01.12+00:00
Khushbu Kella
20
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to parse json string using kql
Log line looks something like this [QueueTrigger] Event Stats {'total_events': 8388, 'file_count': 2, 'aggregated_file_size': 573292} and kql is traces | where operation_Name has "QueueTriggerFuncApp" and message has 'Event stats' |…
asked 2024-04-24T07:36:45.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 88%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Ashwin Venkatesha
230
Reputation points
accepted 2024-04-25T06:46:24.93+00:00
Ashwin Venkatesha
230
Reputation points
asked 2023-07-05T08:54:43.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 68%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Truong Nga
10
Reputation points
answered 2024-04-15T09:46:56.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 47%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Maciej Rybak
0
Reputation points
1 answer
Query execution has exceeded the allowed limits (80DA0001)
Query Limits Exceeded Query execution has exceeded the allowed limits (80DA0001): 'summarize' operator has exceeded the memory budget (5368709120) during evaluation. Results may be incorrect or incomplete (E_RUNAWAY_QUERY; see…
asked 2024-03-12T18:07:49.3433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Rai, Abhishek
0
Reputation points
commented 2024-04-10T12:13:25.1066667+00:00
Rai, Abhishek
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Data Explorer - cannot share dashboard
Dear community I am following this tutorial https://learn.microsoft.com/en-us/azure/data-explorer/azure-data-explorer-dashboards#share-dashboards and trying to shae a dashbaord created in Azure Data Explorer, however, when adding members, either with…
asked 2024-03-10T21:51:11.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 61%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Matteo Traina
20
Reputation points
commented 2024-04-10T11:38:07.5266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 41%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Deyan Petrov
1
Reputation point
1 answer
Getting 0 results for partitioned external table in Azure Storage
I have an Azure App Gateway's WAF logs being written to blob storage and I'd like to query the data. We have been using Log Analytics to do this, so the move to blob storage is part of an effort to see if we can store the data with a retention policy…
asked 2024-04-08T18:45:02.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 28.000000000000004%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Greg McGee
0
Reputation points
answered 2024-04-10T08:09:04.6866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nehruji R
3,121
Reputation points Microsoft Vendor
1 answer
ADX cost estimation
I want to prepare an estimate for ADX with 2TB monthly data.. I checked this link "https://dataexplorer.azure.com/AzureDataExplorerCostEstimator.html " . What should I put in for the field "Estimated Data Compression (x times)" …
asked 2022-02-25T11:04:46.533+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 96%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Soumya Banerjee
126
Reputation points
commented 2024-04-09T11:27:08.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 14.000000000000002%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kaspar Kwok
0
Reputation points
1 answer
One of the answers was accepted by the question author.
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 35%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)