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.
546 questions
1 answer
Are there any plans to create a docker container for Kustainer / Data Explorer emulator that is compatible with MacOS on arm64?
Hi everybody. As the title says, I would greatly appreciate to use the Kustainer image on my Mac with M1 processor. I can run the linux container but it fails with an exception: /kusto/Kusto.Personal / Kusto.Personal: Exception:…
asked 2024-02-16T14:23:12.6333333+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, 20%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CC
15
Reputation points
edited a comment 2025-02-12T08:45:58.1766667+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(211.20000000000002, 52%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Joakim Järvinen (Brightly)
0
Reputation points
2 answers
Unable to connect to new azure cluster
I am not authorized to connect to my newly-created azure data explorer cluster. My account is owner of the subscription, resource group and cluster, and it has alldatabaseadmin permission on the new cluster's database. Please advise ResourceIAM rolerole…
asked 2025-02-08T21:20:45.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(12.8, 73%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
jwinnd
0
Reputation points
commented 2025-02-12T01:30:44.2966667+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
8,050
Reputation points Microsoft Vendor
1 answer
Is there a way to deploy KQL - Time Series Query to get alerts for anomalies?
We have a KQL query that reads last 365 days of data from custom table (Log analytics workspace) and using Time-series functions it calculates anomalies in it. Now we are looking for deploying this query to get an alert email if there is anomaly. Is it…
asked 2024-02-07T14:35:49.07+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(313.6, 30%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
D Mallikarjuna Reddy
96
Reputation points
commented 2025-02-05T19:01:34.0966667+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, 15%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vermani, Bhuvnesh
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Few Azure Data Explorer Free Clusters
Hello, I would like to create few Azure Data Explorer Free Clusters and use them simultaneously to keep my data for different projects (development), is it even possible? The second question is - is it possible to give some permission to other users to…
![](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, 30%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
3 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-02-04T16:34:18.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(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,845
Reputation points Microsoft Vendor
1 answer
I'm using data factory and my explorer seems to be frozen. Behind the scenes I am able to create tables but when I request to drop a table it says that I have two columns with similar names and that I need to use SQL commands to rename these columns.
I have a table InstallBase which I have created successfully using a copy data task in Data Factory. When I go to Explorer I can't see the table. When I then do to drop the table using a drop table SQL command it drops the table but reports that I have…
asked 2025-02-04T11:57:09.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(214.4, 57.00000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Peter Carruthers
0
Reputation points
answered 2025-02-04T15:03:21.4266667+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
13,705
Reputation points Microsoft Vendor
2 answers
How to connect Azure Data Explorer pool in Synapse to Cosmos DB
Hi, I am trying to connect Data Explorer (Synapse pool) to the Analytical Store in a Cosmos DB container. I was informed on this forum that this is indeed possible and the documentation shows how to do this. Unfortunately when I try to ingest data into…
asked 2025-01-20T11:04:52.11+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(80, 61%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Christopher Wilkinson
0
Reputation points
commented 2025-01-23T21:45:42.3+00:00
Chandra Boorla
8,050
Reputation points Microsoft Vendor
1 answer
How to call ADX search API? I am not able to run it in postman
Hi Team, I want to provide search API to team, so that they can integrate it with there system. but I am not able to run ADX query API in postman. I am not able to understand what I should use to authenticate ADX in postman, how to get auth…
asked 2025-01-20T09:03:37.4533333+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(160, 39%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Disha Bodade
80
Reputation points
commented 2025-01-22T09:54:41.6366667+00:00
Ganesh Gurram
3,845
Reputation points Microsoft Vendor
1 answer
How does Azure Data Explorer in Synapse Analytics work as regards Cosmos db
Hi, I am trying different ways to get Cosmos db data into Synapse Analytics in real-time (near real-time is good enough). I have seen mentioned that it is possible to use Azure Data Explorer. Does Data Explorer use the Analytical Store to get the latest…
asked 2025-01-17T09:15:09.86+00:00
Christopher Wilkinson
0
Reputation points
commented 2025-01-21T18:35:52.6833333+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
19,955
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Sharing Azure Data Explorer dashboards externally ?
Hi, is it possible to share ADX Dashboards externally ? Naturally, I can share the dashboards internally - within the organization - per email & manage the permissions, but can I do the same with external viewers ? E.g. shareholders or any person…
asked 2022-05-02T08:52:19.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(211.20000000000002, 70%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Miroslav V
26
Reputation points
answered 2025-01-21T15:01:06.86+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(284.8, 25%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
Gabi Lehner
6
Reputation points Microsoft Employee
0 answers
How to get the partitions data from Azure ADX through SQL Server emulation?
I'm looking for support regarding viewing my partition data in Azure ADX through the jdbc SQLServer emulation. By following this page…
asked 2025-01-16T15:42:01.8966667+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(300.8, 26%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Shanmuganandha Vadivel Mahesh Kumar, FG-210
0
Reputation points
edited a comment 2025-01-17T10:27:10.7066667+00:00
Shanmuganandha Vadivel Mahesh Kumar, FG-210
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
1 answer
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
answered 2025-01-09T11:17:35.7+00:00
Ganesh Gurram
3,845
Reputation points Microsoft Vendor
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
Smaran Thoomu
19,955
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,845
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,845
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,766
Reputation points MVP