561 questions with Azure Data Explorer tags

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

Microsoft Sentinel where clause failing for more than one character

I'm having difficulty searching a field for a value in KQL. The field I am searching I get by decoding a base64 encoded string using the built in function base64_decode_tostring(). The string I am decoding is: …

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.
561 questions
Microsoft Sentinel
Microsoft Sentinel
A scalable, cloud-native solution for security information event management and security orchestration automated response. Previously known as Azure Sentinel.
1,268 questions
asked 2022-10-12T16:36:22.197+00:00
Liam Jones 146 Reputation points
accepted 2025-04-17T15:02:04.1666667+00:00
Liam Jones 146 Reputation points
1 answer

ADX Kusto Self Join with a combination of equality and inequality

Hi, How do we generate Kusto query to achieve a self-join query, where one column matches but the other doesn't? For example: myTable | where myColumnSubset == "mySubGroup" | join kind=inner ( myTable | where myColumnSubset ==…

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.
561 questions
asked 2025-04-14T23:00:47.3466667+00:00
databricksuser-5173 0 Reputation points
answered 2025-04-15T18:36:00.82+00:00
Ganesh Gurram 6,460 Reputation points Microsoft External Staff
1 answer One of the answers was accepted by the question author.

I would like to know if connector is available for SAP BPC?

Hi Experts, I am working on solution development to ingest data from different SAP systems to ADLS Gen 2. I have selected ADF for the integration and could see ADF connectors available for SAP BW, HANA, C2C etc. However, I don't find any information…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,554 questions
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.
561 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,464 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2023-12-18T13:44:07.4133333+00:00
Sivaramakrishnan S 20 Reputation points
commented 2025-04-09T08:08:05.3266667+00:00
Gowtham Selvaraj 0 Reputation points
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.
561 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.
561 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
Rakesh Govindula 965 Reputation points Microsoft External Staff
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.
561 questions
asked 2025-03-31T23:41:58.65+00:00
databricksuser-5173 0 Reputation points
edited a comment 2025-04-07T10:55:21.35+00:00
Dileep Raj Narayan Thumula 5 Reputation points Microsoft External Staff
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.
561 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.
561 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,320 Reputation points Microsoft External Staff
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.
561 questions
asked 2025-03-30T01:29:27.4266667+00:00
databricksuser-5173 0 Reputation points
commented 2025-04-02T11:29:41.4433333+00:00
Rakesh Govindula 965 Reputation points Microsoft External Staff
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.
561 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,146 Reputation points MVP
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.
561 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.
110 questions
Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,545 questions
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.
561 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 22,840 Reputation points Microsoft External Staff
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.
561 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.
561 questions
asked 2025-03-12T14:19:14.68+00:00
FedericoZarelli-6386 20 Reputation points
commented 2025-03-14T07:32:40.85+00:00
Smaran Thoomu 22,840 Reputation points Microsoft External Staff
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.
561 questions
asked 2025-03-13T09:07:49.05+00:00
Souvik Saha Choudhary 21 Reputation points
answered 2025-03-13T14:29:58.1633333+00:00
Venkat Reddy Navari 1,585 Reputation points Microsoft External Staff
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.
561 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.
561 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,320 Reputation points Microsoft External Staff
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.
561 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.
561 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,146 Reputation points MVP
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.
561 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 1,705 Reputation points Microsoft External Staff