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.
539 questions
0 answers
Cross-tenant data connection between event hub and ADX
HI Team, how to create Cross-tenant data connection between event hub and ADX using SPN authentication
asked 2025-01-09T02:42:53.4633333+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(112.00000000000001, 87%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Raja Mohamed Masthan Syed Ahamed
0
Reputation points Microsoft Employee
commented 2025-01-13T04:19:53.8733333+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(201.6, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Ganesh Gurram
3,025
Reputation points Microsoft Vendor
2 answers
What authentication steps/settings should I double check if the initial login process hangs while the app says "A popup authentication should come up on your browser next" and then never does?
Dataexplorer has been installed but hangs upon bringing up a window to login. A user/pass are never put in so, we are unable to get any further. I need help looking for settings most likely to be a culprit. Also, this is on a MS 365 E5…
asked 2025-01-10T13:09:14.94+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(182.40000000000003, 94%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
Rick Osteen
0
Reputation points
commented 2025-01-10T20:24:14.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(166.4, 38%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Richard Ramon Osteen
0
Reputation points
2 answers
How to deploy Azure Data Explorer Dashboard using Azure DevOps CI/CD pipeline?
I have created an ADX dashboard in dev environment which basically shows visualization of an app insights logs . I want to copy that dashboard and promote it to next environment QAT with data source updated with the QAT app insights. I was trying to…
asked 2023-11-07T16:46:38.0266667+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(243.2, 75%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akash Gupta
20
Reputation points
commented 2025-01-09T13:45:23.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(201.6, 37%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Niels
40
Reputation points
0 answers
Data Explorer scale out issue
We have Standard_D12_v2 First scale out configuration: The cluster got more than 90% CPU and didn't scale to 4 instances, instead it was down. We tested also a Second configuration, custom auto scale rule CPU > 80% Same issue. Cluster never…
asked 2024-12-10T15:21:25.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(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-12-13T05:26:44.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(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
18,965
Reputation points Microsoft Vendor
1 answer
Unable to update or modify Azure Purview account tags using Terraform
I am attempting to update or modify Azure Purview account tags using Terraform, but I am encountering an error indicating that an Azure policy is blocking the operation. We want to identify the deny policy using a Kusto query or data explorer. Could you…
asked 2024-12-03T05:50:46.4466667+00:00
Nikhil Raj
20
Reputation points
edited a comment 2024-12-10T02:30:26.2766667+00:00
Ganesh Gurram
3,025
Reputation points Microsoft Vendor
2 answers
Ingestion response takes too long
Hello ADX experts. I have a background worker that are doing calculations in near real-time. The results are then ingested to ADX using the .NET SDK. It's important that the ingestion operation doesn't take too long, or it will accumulate a delay which…
asked 2024-11-29T12:23:26.6366667+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(201.6, 57.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Pål Kristian Halle
110
Reputation points
commented 2024-12-03T18:59:33.3+00:00
Ganesh Gurram
3,025
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How to recover data for failed ingestion
Hello ADX experts. I'm using queued ingestion which seems to always be successful (i.e. inserted to queue) regardless of whether the queued data can be merged to the main table. (Please correct me if I'm wrong.) I did a quick test and temporarily renamed…
asked 2024-11-29T12:35:49.2333333+00:00
Pål Kristian Halle
110
Reputation points
commented 2024-12-02T15:26:50.2966667+00:00
Pål Kristian Halle
110
Reputation points
1 answer
One of the answers was accepted by the question author.
Most cost-effective way to migrate existing data
Hello ADX experts. I have tested ADX for a while now and have decided to try it in production. However, a big uncertainty is the migration process. We are looking to migrate about 50 TB of data from an Azure SQL database. What would be the most…
asked 2024-11-29T12:15:08.8866667+00:00
Pål Kristian Halle
110
Reputation points
accepted 2024-12-02T09:45:01.4266667+00:00
Pål Kristian Halle
110
Reputation points
1 answer
One of the answers was accepted by the question author.
How to customize the name of file in export command in Azure data explorer
I am exporting data to blob storage using the .export command , i want the the file name to be <TableName>_<today'sDateTime> but i am unable to change the file name in namePrefix property of .export command and cannot find any specific…
asked 2023-07-20T10:17:40.9866667+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(12.8, 72%, 11%)' 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)
siddharth bansal
346
Reputation points
accepted 2024-11-26T10:39:05.15+00:00
siddharth bansal
346
Reputation points
1 answer
Missing parameter in Azure Portal deployment of an Azure Data Explorer Cluster resource
I've detected an issue with how the portal is deploying Data Explorer cluster resources. While having the following policy activated: "Public network access on Azure Data Explorer should be disabled - 43bc7be6-5e69-4b0d-a2bb-e815557ca673", you…
asked 2024-11-15T15:18:10.8766667+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(217.60000000000002, 36%, 31%)' 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)
REZAI Arash
0
Reputation points
commented 2024-11-19T19:54:41.6333333+00:00
Sander van de Velde | MVP
34,201
Reputation points MVP
2 answers
ADX plugin postgresql_request failed to load System.Security.Cryptography.Algorithms
I have an Azure Data Explorer (ADX) instance in combination with a PostgreSQL Flexible Server (16.4) and want to access the SQL table test_adx_meta from ADX. There are no firewall or IP range limitations. I followed the official postgres_request…
asked 2024-11-13T10:24:34.47+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(16, 49%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
lwerthm
0
Reputation points
commented 2024-11-18T17:40:24.5566667+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, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
1,700
Reputation points Microsoft Vendor
2 answers
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
commented 2024-11-11T12:03:18.39+00:00
Ganesh Gurram
3,025
Reputation points Microsoft Vendor
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
34,201
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
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
90,496
Reputation points
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
6,375
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
90,496
Reputation points
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
12,895
Reputation points Microsoft Vendor