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.
531 questions
1 answer
How to fix internal server error 500 for kusto db using user managed identity ?
Hi , I am trying to use user assigned managed identity to connect with KUSTO db but getting internal server error 500 . kusto db already given the permissions to my managed identity . I am concern about the app service environment variable is that…
asked 2024-11-07T15:56:52.2233333+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(115.19999999999999, 56.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
SohamPrasad Girde (Wipro Designit Services, Inc.)
40
Reputation points Microsoft Vendor
answered 2024-11-07T21:00:44.9933333+00:00
Luis Arias
7,121
Reputation points
1 answer
One of the answers was accepted by the question author.
When will Azure Data Explorer pool for Synapse become GA
When will Azure Data Explorer pool for Synapse become GA
asked 2024-11-04T16:19:22.2766667+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, 47%, 34%)' 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)
Himanshu Zinzuwadia
45
Reputation points
commented 2024-11-06T23:19:01.3866667+00:00
Sander van de Velde | MVP
33,046
Reputation points MVP
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
commented 2024-11-04T15:14:47.5433333+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(310.4, 35%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAQ%3C/text%3E%3C/svg%3E)
Andres Quesada Ruiz
0
Reputation points
1 answer
Semantic error on alert based ADX
Hello, I’m configuring an alert based on an ADX cluster. The query is running successfully in both the alert setup and the Log Analytics workspace, but the alert health status returns the following: The query keeps failing because of a semantic error.…
asked 2024-10-27T19:08:11.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(25.6, 69%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dima Kaminin
0
Reputation points
edited an answer 2024-10-28T21:00:48.9633333+00:00
Sander van de Velde | MVP
33,046
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Azure ADX materialize() function
Is the materialize() function that is mentioned in this page: https://learn.microsoft.com/en-us/kusto/query/materialize-function?view=microsoft-fabric is GA?
asked 2024-10-21T16:17:41.7+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, 88%, 22%)' 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)
Shai Sherman
20
Reputation points
accepted 2024-10-22T06:24:36.2666667+00:00
Shai Sherman
20
Reputation points
1 answer
how to find the resource in portal for with KQL for this type: microsoft.insights/workloadmonitoring
how to find the resource in portal for with KQL for this type: microsoft.insights/workloadmonitoring
asked 2024-10-14T03:14:03.4766667+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(22.400000000000002, 41%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZS%3C/text%3E%3C/svg%3E)
Zhong, Shui Jin (Azure Account)
0
Reputation points
commented 2024-10-16T11:55:55.0366667+00:00
PRADEEPCHEEKATLA-MSFT
90,226
Reputation points Microsoft Employee
1 answer
Allowed operator in Azure Data Explorer RLS function
I'm attempting to implement RLS in ADX on already ingested data. The RLS policy function I'm creating looks like this. .create-or-alter function with (docstring = 'Restricts access to data.', folder = 'RLS') RestrictAccess(TableName: string) { …
asked 2024-09-26T10:33:04.77+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(214.4, 43%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA2%3C/text%3E%3C/svg%3E)
AdamRnarsson-2213
0
Reputation points
commented 2024-10-15T20:49:57.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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
2,680
Reputation points Microsoft Vendor
1 answer
Manage Azure Data Explorer Dashboard Programatically
Hi, I wanted to check if there is any ETA for the release of this feature. Regards, Antoine
asked 2024-10-08T14:46:39.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, 44%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQA%3C/text%3E%3C/svg%3E)
Quirin, Antoine
0
Reputation points
commented 2024-10-14T06:00:15.61+00:00
PRADEEPCHEEKATLA-MSFT
90,226
Reputation points Microsoft Employee
1 answer
ADX Cluster Is Alive sudden dip
Hi. Recently we experienced a weird phenomenon of a sudden and very short dip in our ADX Cluster Is Alive this didn't impact performance/data what-so-ever (as ingestion continued as usual and restored itself automatically) but I'm interested to learn:…
asked 2024-08-02T20:19:33.97+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(227.2, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOB%3C/text%3E%3C/svg%3E)
Ori Bandel
30
Reputation points
commented 2024-10-12T20:55:26.3566667+00:00
Ori Bandel
30
Reputation points
1 answer
Return rows that only have nulls?
I'm using Kusto/KQL. I have a huge dataset that I am working with that was migrated from another sources. I know that many of the fields only have null values. I'd like to be able to identify those columns. Sort of doing a null check on column by column,…
asked 2024-10-03T17:31:07.81+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, 97%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
John Thoni
0
Reputation points Microsoft Employee
answered 2024-10-04T02:18:12.8066667+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
11,200
Reputation points Microsoft Vendor
0 answers
ODBC uses service principal to connect to ADX
Hi, we're trying to let ODBC uses azure service principal to connect to ADX but encounters the error Error requesting access token The reference guide is this : https://learn.microsoft.com/en-us/azure/data-explorer/connect-odbc The client is…
asked 2021-10-19T05:39:42.39+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(224.00000000000003, 26%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAZ%3C/text%3E%3C/svg%3E)
Amy Z
296
Reputation points
edited a comment 2024-10-02T13:39:06.63+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(169.60000000000002, 32%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
Weber, Christian
0
Reputation points
0 answers
ADX Transactional Update Policy Guarantees
The update policy documentation for Azure Data Explorer makes the following statements about transactional update policies (these statements are inconsistent with each other): "guarantees consistency between data in the source and target…
asked 2024-03-08T15:53:20.1633333+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(102.4, 27%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Alex Lorimer
0
Reputation points
commented 2024-09-27T16:05:37.83+00:00
Alex Lorimer
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Intermittent Error with Materialized View in Kusto: "Index was outside the bounds of the array"
Hello, I'm encountering an issue with a materialized view in Kusto where I sometimes get an error when querying the view. Below is my materialized view definition: // materialized-views .create async materialized-view with (backfill=True,…
asked 2024-09-26T07:29:33.0666667+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(137.6, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWV%3C/text%3E%3C/svg%3E)
Wes Verhagen
50
Reputation points
accepted 2024-09-27T10:03:09.8833333+00:00
Wes Verhagen
50
Reputation points
1 answer
One of the answers was accepted by the question author.
how to delete a table in azure data explorer using kql query?
I was trying to delete a table called Heartbeat from Azure Data Explorer DB using a KQL script. The contents of the kql script is: .drop table Heartbeat ifexists On executing the kql script using github workflows, Im getting the following error: The…
asked 2023-11-24T12:40:50.0566667+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(108.80000000000001, 39%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
PRIYANKA S NAIR
40
Reputation points
accepted 2024-09-25T10:49:37.15+00:00
PRIYANKA S NAIR
40
Reputation points
1 answer
How materialized views work in Azure Data Explorer regarding cache policy?
Hey everyone, I am trying to implement some materialized views within my ADX cluster. I need to backfill the data for the last year and I understood that I must increase my hot cache policy for it to be able to. I have two questions regarding that: is it…
asked 2024-09-18T14:43:32.8866667+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(35.2, 86%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMO%3C/text%3E%3C/svg%3E)
Marcos Olmedilla
0
Reputation points
commented 2024-09-20T17:17:37.1933333+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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
16,735
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to access the databases and their tables while executing the KQL query at the cluster level?
i want to access the databases and their tables at the cluster connection level how can i achieve that?
asked 2024-08-12T11:36:43.82+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(9.6, 68%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Muhammad Usman Rafiq
20
Reputation points
accepted 2024-09-20T06:52:12.04+00:00
Muhammad Usman Rafiq
20
Reputation points
1 answer
Does the Managed Identity on GitHub action work with Delta-Kusto to connect ADX?
I'm working on a KQL scripts repo in GitHub and using Delta-Kusto (https://github.com/microsoft/delta-kusto) to implement CI/CD to ADX. Currently, I'm using a Service Principle to connect ADX and deploy, but I'm curious if there's a way to use Managed…
asked 2024-09-13T21:38:37.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(99.2, 30%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dhinesh Sornakili
0
Reputation points
commented 2024-09-17T06:06:18.2766667+00:00
PRADEEPCHEEKATLA-MSFT
90,226
Reputation points Microsoft Employee
1 answer
Kusto Load Balancer
Hi, Is it possible to setup a load balancer in front of two Kusto clusters. Could you please let me know if this is feasible and what steps would be involved in implementing such a setup? Your guidance on this matter would be greatly appreciated. Thanks
asked 2024-08-09T18:40:58.83+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(214.4, 20%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Shiva Lakshman Nallakatta
0
Reputation points Microsoft Employee
edited an answer 2024-09-16T12:00:27.4333333+00:00
Sander van de Velde | MVP
33,046
Reputation points MVP
1 answer
Best data architecture strategy in Azure Data Explorer
Hey everyone, I have some questions regarding the best pracetices for the data architecture within Azure Data Explorer. We currently have multiple databases with similar telemetry data in tables from multiple clients. We would like to do some…
asked 2024-09-06T12:09:54.3133333+00:00
Marcos Olmedilla
0
Reputation points
commented 2024-09-10T16:14:13.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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,105
Reputation points Microsoft Vendor
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…
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
35
Reputation points
commented 2024-09-02T08:52:28.51+00:00
Ori Bandel
30
Reputation points