Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,306 questions
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
32,736
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,146
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,525
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,146
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,125
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,555
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,146
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
32,736
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
2,950
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
1 answer
YAML migration for Azure-Kusto query
I'm trying to trigger a gate check in YAML, this is what I have so far, with the sensitive bits removed. What is wrong with this snippet? I'm getting the following error - Encountered error(s) while parsing pipeline YAML:…
asked 2024-08-29T18:01:49.9233333+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, 56.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Abhay Punjabi
0
Reputation points Microsoft Employee
answered 2024-08-30T11:17:14.1466667+00:00
phemanth
11,125
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Separate data in data explorer and use as datastore
Hello, We are sending data from IoT Central to Event Hubs and then to Data Explorer, with the hopes of then sending the data to Azure Machine Learning. In order to send data from Event Hubs to Data Explorer it needs a data ingestion into a table…
asked 2021-04-21T20:19:09.177+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, 69%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
yjay
256
Reputation points
commented 2024-08-29T01:55:45.7866667+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, 33%, 36%)' 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)
Nguyễn Thanh Tú
170
Reputation points
2 answers
E_LOW_MEMORY_CONDITION Query Execution lacks memory resource to complete (message: bad allocation)
Hi all, I'm new to ADX and I need your support. I used to use this query a week ago and it went well both in ADX and PBI but somehow it shows an error today as attached in PBI (in ADX is still working). Here is the query I used for reference. let T1 =…
asked 2024-08-26T04:56:33.5466667+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(195.2, 66%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sangsattaya, Manatsanan
0
Reputation points
answered 2024-08-26T10:10:00.63+00:00
phemanth
11,125
Reputation points Microsoft Vendor