578 questions with Azure Data Explorer tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

How can I connect Azure Data Explorer to a Log Analytics resource using AMPLS to privately query

I have a log analytics workspace that is only accessible through AMPLS and Data Explorer doesnt appear to support connections to resources that are setup to only allow Restricted Private Inbound queries even when accessing via a device that has network…

Azure Data Explorer
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.
578 questions
asked 2025-04-07T16:02:41.57+00:00
James Shellis 20 Reputation points
accepted 2025-04-09T07:29:14.2666667+00:00
James Shellis 20 Reputation points
2 answers

Azure ADX - UpdatePolicy fails to insert data

Hi Everyone,   I believe everyone is doing good and safe.   I am facing challenge with ADX. Please find the problem details below.   Problem statement: We are unable to insert a result data into a target table from source table using an UpdatePolicy.  …

Azure Data Explorer
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.
578 questions
asked 2025-04-01T07:02:05.7166667+00:00
Krishna Kumar, Sai Hariharan 5 Reputation points
commented 2025-04-08T11:46:41.9033333+00:00
Anonymous
0 answers

E_RUNAWAY_QUERY

Hi, How do we systematically Debug and pinpoint the root cause of E_RUNAWAY_QUERY error? Are there any built in tools in ADX? .show queryplan is not useful. Typical errors read "Query Limits Exceeded...Partial Query Error.....Aggregated String…

Azure Data Explorer
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.
578 questions
asked 2025-03-31T23:41:58.65+00:00
databricksuser-5173 20 Reputation points
edited a comment 2025-04-07T10:55:21.35+00:00
Dileep Raj Narayan Thumula 330 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How do I recover data deleted from a table ?

How do I recover data deleted from a table ? The data has been automatically deleted by a data retention policy.

Azure Data Explorer
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.
578 questions
asked 2025-04-02T08:33:48.45+00:00
BIHI Tarik 20 Reputation points
accepted 2025-04-05T09:06:35.2066667+00:00
BIHI Tarik 20 Reputation points
2 answers

Inability in connecting to Azure Data Explorer cluster from WebUI

I created a ADE cluster through the Azure portal under my team's subscription. While the cluster looks active + has a URI link available, when I try to 1) click on the URI link or 2) add a connection from the WebUI, I get this error: Failed to connect…

Azure Data Explorer
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.
578 questions
asked 2025-03-31T21:40:39.32+00:00
Annie Zhou 40 Reputation points Microsoft Employee
commented 2025-04-03T06:37:46.71+00:00
phemanth 15,765 Reputation points Microsoft External Staff Moderator
1 answer

IsObject() isArray()

Hi, is there any IsArray() or IsObject() or IsBag() or typeof() function supported by Azure Data Explorer to check whether my Dynamic data is property bag or array, before applying mv-expand? My source sends semi-structured data to my application.…

Azure Data Explorer
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.
578 questions
asked 2025-03-30T01:29:27.4266667+00:00
databricksuser-5173 20 Reputation points
commented 2025-04-02T11:29:41.4433333+00:00
Anonymous
3 answers

Do I pay only for the storage in case that the Azure Data Explorer is stopped?

Hi all, In case that I have a stopped Azure Data Explorer cluster , do I pay only for the storage that I used. Kind regards, SM

Azure Data Explorer
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.
578 questions
asked 2023-09-26T18:30:57.4866667+00:00
SalvM 0 Reputation points
commented 2025-04-01T15:58:35.6466667+00:00
Sander van de Velde | MVP 36,776 Reputation points MVP Volunteer Moderator
1 answer

Datamodel graphic in context of PurView / Data Catalog

I govern conceptional, logical and physical models in Azure Data Catalog / PurView. How can I get an grahical overview of a selection of related entities? Is there a tool available providing some functionality to arrange entities and relationsships? …

Azure Data Explorer
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.
578 questions
Azure Data Catalog
Azure Data Catalog
An Azure service that serves as a system of registration and system of discovery for enterprise data assets.
112 questions
Microsoft Security | Microsoft Purview
asked 2022-02-01T14:35:48.18+00:00
Heijo Hewel 21 Reputation points
commented 2025-03-31T12:09:32.2766667+00:00
GabrielTanase-9830 1 Reputation point
1 answer

i want to create a ADX dashboard using terraform, but i am not able to get the terraform resource for that

i want to create a ADX dashboard using terraform, but i am not able to get the terraform resource for that

Azure Data Explorer
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.
578 questions
asked 2025-03-17T10:58:39.5166667+00:00
Nitika Singhal 0 Reputation points
commented 2025-03-19T07:40:36.1166667+00:00
Smaran Thoomu 25,100 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure Data Explorer ingests duplicated records from Event Hub

We have data ingestions set up between an event hub and Azure Data Explorer. There are abnormally high duplicated records in Azure Data Explorer database tables. I understand that the ingestion delivery is at least once. having dups are sort of expected.…

Azure Data Explorer
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.
578 questions
asked 2025-03-14T17:59:18.19+00:00
J.P. Zhang 25 Reputation points Microsoft Employee
accepted 2025-03-17T19:50:46.1066667+00:00
J.P. Zhang 25 Reputation points Microsoft Employee
2 answers

Why ADX uses 2 VMs SKUs D11 v2 and D2a v4 ?

Hello Team, Analysing my costs, I noticed that there are 2 SKUs associated with ADX, D11 v2 and D2a v4. The purpose of D11 v2 is clear - this is the one I selected as underlaying machine for the cluster and has utilization 100% since my cluster is always…

Azure Data Explorer
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.
578 questions
asked 2025-03-12T14:19:14.68+00:00
FedericoZarelli-6386 60 Reputation points
commented 2025-03-14T07:32:40.85+00:00
Smaran Thoomu 25,100 Reputation points Microsoft External Staff Moderator
1 answer

All logs are not showing in the Log Analytics Workspace - Azure Data Explorer

I created a Log Analytics Workspace connection in Azure Data Explorer. I tried to query AzureDiagnostics logs for one month. But it was not showing all the expected logs. How can I get all logs?

Azure Data Explorer
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.
578 questions
asked 2025-03-13T09:07:49.05+00:00
Anonymous
answered 2025-03-13T14:29:58.1633333+00:00
Venkat Reddy Navari 3,630 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Encountered Error When Recreating Azure Kusto Cluster: Name Already Taken

Hello, I recently removed an existing Kusto cluster from Azure using the "az kusto cluster remove" command. However, when attempting to recreate a new cluster with the same name, I encountered the following error message: "Name 'XXXX'…

Azure Data Explorer
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.
578 questions
asked 2024-03-26T10:10:50.81+00:00
Rezgui, Bilel 35 Reputation points
edited a comment 2025-03-07T10:54:11.75+00:00
Archie Gupta 0 Reputation points Microsoft Employee
0 answers

Azure Data Explorer External Table with Partition

I am trying to create an Azure Data Explorer external table in azure using a parquet file with partitions and somehow ,I am not able to get the URI properly using UI or KQL always getting error or return query count from external table as 0. without…

Azure Data Explorer
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.
578 questions
asked 2025-02-26T14:33:00.44+00:00
DataEngineer 40 Reputation points
commented 2025-03-03T07:30:39.1333333+00:00
phemanth 15,765 Reputation points Microsoft External Staff Moderator
1 answer

IoT Hub ingestion into Azure Data Explorer runs at 100% avg ingestion utilization

My setup consists of several databases in a single Kusto cluster, each having a landing table with ingestion mapping configured from IoT Hubs. The data in the landing table is then split with update policies into specialized tables. I have no ingestion…

Azure Data Explorer
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.
578 questions
asked 2023-12-04T18:49:34.9866667+00:00
Kovács, Ferenc 61 Reputation points
commented 2025-02-28T10:22:45.96+00:00
Kovács, Ferenc 61 Reputation points
1 answer One of the answers was accepted by the question author.

Is it allowed to use an Azure Data Explorer cluster with a "Dev/Test" workload for production database monitoring?

Hello! We've been evaluating the Azure Database Watcher service and have nothing but great things to say. However, we have a question about provisioning the service in production. We understand the benefits and limitations of "free" Azure Data…

Azure Data Explorer
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.
578 questions
asked 2025-02-26T18:03:04.82+00:00
Wes Kennedy 25 Reputation points
commented 2025-02-26T21:39:57.64+00:00
Sander van de Velde | MVP 36,776 Reputation points MVP Volunteer Moderator
1 answer

Data ingestion from azure function to ADX

hi all, I am trying to get an azure function app going to write the incoming http json payload to ADX table. below are the steps i followed: Create a new DB in ADX and create a corresponding table. create a new function app using node and create a…

Azure Data Explorer
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.
578 questions
asked 2025-02-24T01:09:01.7133333+00:00
Abhishake Jaiswal 160 Reputation points
commented 2025-02-26T08:20:39.9466667+00:00
J N S S Kasyap 4,085 Reputation points Microsoft External Staff Moderator
1 answer

ADX (KQL) - Unable to query data older than 3 months

I have a situation where I am unable to query historical data (older than 3 months) from our ADX database. My database has a retention period of 3600 days and cache period of 270 days. There are no ingestion failures I ran the following…

Azure Data Explorer
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.
578 questions
asked 2025-02-12T16:54:46.34+00:00
pjbcoetzer 0 Reputation points
answered 2025-02-12T19:40:00.1366667+00:00
phemanth 15,765 Reputation points Microsoft External Staff Moderator
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:…

Azure Data Explorer
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.
578 questions
asked 2024-02-16T14:23:12.6333333+00:00
CC 20 Reputation points
edited a comment 2025-02-12T08:45:58.1766667+00:00
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…

Azure Data Explorer
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.
578 questions
asked 2025-02-08T21:20:45.5566667+00:00
jwinnd 0 Reputation points
commented 2025-02-12T01:30:44.2966667+00:00
Chandra Boorla 14,685 Reputation points Microsoft External Staff Moderator