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.
479 questions
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
answered 2024-04-15T09:46:56.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(57.599999999999994, 47%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Maciej Rybak
0
Reputation points
1 answer
Query execution has exceeded the allowed limits (80DA0001)
Query Limits Exceeded Query execution has exceeded the allowed limits (80DA0001): 'summarize' operator has exceeded the memory budget (5368709120) during evaluation. Results may be incorrect or incomplete (E_RUNAWAY_QUERY; see…
asked 2024-03-12T18:07:49.3433333+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, 84%, 34%)' 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)
Rai, Abhishek
0
Reputation points
commented 2024-04-10T12:13:25.1066667+00:00
Rai, Abhishek
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Data Explorer - cannot share dashboard
Dear community I am following this tutorial https://learn.microsoft.com/en-us/azure/data-explorer/azure-data-explorer-dashboards#share-dashboards and trying to shae a dashbaord created in Azure Data Explorer, however, when adding members, either with…
asked 2024-03-10T21:51:11.8+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(3.2, 61%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Matteo Traina
20
Reputation points
commented 2024-04-10T11:38:07.5266667+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(3.2, 41%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Deyan Petrov
1
Reputation point
1 answer
Getting 0 results for partitioned external table in Azure Storage
I have an Azure App Gateway's WAF logs being written to blob storage and I'd like to query the data. We have been using Log Analytics to do this, so the move to blob storage is part of an effort to see if we can store the data with a retention policy…
asked 2024-04-08T18:45:02.16+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, 28.000000000000004%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Greg McGee
0
Reputation points
answered 2024-04-10T08:09:04.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(150.4, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nehruji R
1,511
Reputation points Microsoft Vendor
1 answer
How can I schedule materialized view (refresh daily data at EOD )in data explorer?
Hi, currently I 'have setup one materialized view, but I want to update view on at end of the day. Currently it's getting updated in near time. Is it possible in materialized view to schedule query on daily basis only ?
asked 2024-04-04T14:30:24.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(131.20000000000002, 53%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Khushbu Kella
0
Reputation points Microsoft Employee
commented 2024-04-10T04:43:47.14+00:00
PRADEEPCHEEKATLA-MSFT
76,586
Reputation points Microsoft Employee
1 answer
ADX cost estimation
I want to prepare an estimate for ADX with 2TB monthly data.. I checked this link "https://dataexplorer.azure.com/AzureDataExplorerCostEstimator.html " . What should I put in for the field "Estimated Data Compression (x times)" …
asked 2022-02-25T11:04:46.533+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(118.4, 96%, 21%)' 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)
Soumya Banerjee
126
Reputation points
commented 2024-04-09T11:27:08.96+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(131.20000000000002, 14.000000000000002%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kaspar Kwok
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Data Explorer: effective costs different than pricing calculator
Dear community I have created an Azure Data Explorer cluster, as a dev/test environment. The pricing calculator was estimating a certain amount for this setup but thereal cost is higher than that. Looking into the details it seems that the cluster has…
![](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(294.40000000000003, 35%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
Need a KQL query to parse the given json according to the table structure given .
Dear Team, I am seeking your expertise to flatten a JSON file and store its contents in the specified table structure within Azure Data Explorer (ADX). Additionally, I require this transformation to be encapsulated as a function for reusability and…
asked 2024-03-25T02:47:15.0166667+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(150.4, 28.000000000000004%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES3%3C/text%3E%3C/svg%3E)
SaravananGanesan-3177
1,660
Reputation points
commented 2024-04-07T20:02:31.5+00:00
SaravananGanesan-3177
1,660
Reputation points
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'…
asked 2024-03-26T10:10:50.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(176, 39%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Rezgui, Bilel
35
Reputation points
accepted 2024-04-02T07:51:01.7233333+00:00
Rezgui, Bilel
35
Reputation points
1 answer
Azure Data Explorer Ingestion from Event Hub using Private End point not working
I created event hub, send and receive some data and then installed azure data explorer and ingested the data from event hub. Then after that I created private endpoint on event hub and disabled the Public access. Created Private Endpoint on Azure Data…
asked 2024-03-11T20:56:24.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(224.00000000000003, 80%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIH%3C/text%3E%3C/svg%3E)
Ikram Hussain
0
Reputation points
commented 2024-04-01T12:20:53.7633333+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
Deploy ADX tables ,fucntions and mapping from NonProd to Prod using Kusto Command task in Azure DevOPS
I have a Azure Pipeline for deploying ADX tables and Functions using Kusto command task , how ever when I try deploying I am getting this weird error 2024-03-12T11:47:23.2165596Z ##[error]Service returned an error: Error: getaddrinfo ENOTFOUND…
asked 2024-03-12T11:55:51.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(201.6, 17%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DataEngineer
40
Reputation points
commented 2024-04-01T12:20:24.6933333+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
2 answers
Connect Az managed Grafana instance to Azure Data Explorer cluster
I have an Azure Data Explorer cluster that's stood up in tenant A. I am trying to connect to it from my Grafana UI(adding a new data source), which is in tenant B. In the Azure Data Explorer cluster DB, I have added the necessary permissions using the…
asked 2024-03-19T05:08:29.99+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, 47%, 18%)' 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)
Saikrishnan Srivatsan
0
Reputation points Microsoft Employee
commented 2024-04-01T12:17:47.35+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to fix MAC signature found in the HTTP request is not the same as the computed signature. Server used following string to sign , in cosmosdb after key rotation
I rotated all the keys at once in the keys plane on the portal. (All older than 470 days). After that getting: Message: {"Errors":["The MAC signature found in the HTTP request is not the same as the computed signature. Server used…
asked 2024-03-30T03:45:24.0533333+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(204.8, 76%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Adrian Wreyford
45
Reputation points
edited a comment 2024-03-30T15:03:09.9466667+00:00
Adrian Wreyford
45
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-03-27T08:10:49.24+00:00
PRADEEPCHEEKATLA-MSFT
76,586
Reputation points Microsoft Employee
1 answer
Azure Data Explorer dashboard
Hi Friends, I am new to Azure Synapse Analytics. I have deployed my Synapse workspace and also Data Explorer. I have ingested a CSV file. When I click on "Dashboard" in Azure Data Explorer page, I get an error: ""Unexpected server…
asked 2024-03-15T09:10:52.6233333+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, 51%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mohsen Arjmand
20
Reputation points
commented 2024-03-26T15:12:14.3766667+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, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
25,876
Reputation points Microsoft Employee
0 answers
Web content failed to get content error
We are importing ADX(kusto) dataset in Power BI using direct query mode. Since we scaled up the cpu count in ADX, the visuals got crashed in Power BI desktop/Service and got the below error. Web.Contents failed to get contents from…
asked 2024-03-12T09:40:52.54+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(0, 6%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mehala Muthiah
0
Reputation points
commented 2024-03-22T20:27:17.95+00:00
BhargavaGunnam-MSFT
25,876
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How can I connect Azure Cognitive Search with Azure Data Explorer if Azure Data Explorer is not available as a data source?
How can I connect Azure Cognitive Search with Azure Data Explorer if Azure Data Explorer is not available as a data source?
asked 2023-05-11T14:42:36.68+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(176, 71%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E9%3C/text%3E%3C/svg%3E)
95784285
25
Reputation points
commented 2024-03-21T14:30:01.7266667+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, 89%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
Jimi Okikiolu
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Regex matches are running very slow
Hi, I have a query like below - This query is running very slow. is there anyway I can speedup this query. My table is big and I am ingesting 60 billion rows in one hour. Also I have around 40 regex in the where clause, for simplicity I mentioned only…
asked 2024-03-07T23:24:43.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(108.80000000000001, 4%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Amritendu Mondal
20
Reputation points Microsoft Employee
accepted 2024-03-20T23:58:04.04+00:00
Amritendu Mondal
20
Reputation points Microsoft Employee
2 answers
Using Conditional Formatting/ Formula to Compare Two Dates
I am trying to compare two dates in a large data sheet as a Success or Failure depending on the Ship Date. For example, on the first line, the Ship Date is 2/29/2024 which is after the due date (-1 of 2/26/2024), making it a failure. The Expected…
asked 2024-03-19T12:49:22.49+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(278.4, 32%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
Villa, Carissa
0
Reputation points
answered 2024-03-19T22:35:57.91+00:00
Sander van de Velde
28,236
Reputation points MVP
1 answer
Connecting to Azure Data Explorer with JDBC
I am trying to connect to Azure Data Explorer with JDBC using MATLAB but I keep running into the error shown in the insert below. A little bit of googling revealed that this issue could potentially be resolved by "opening port 443 and the necessary…
asked 2024-02-29T08:05:32.5666667+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(144, 5%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Machiri Marodi
0
Reputation points
commented 2024-03-14T10:30:05.67+00:00
PRADEEPCHEEKATLA-MSFT
76,586
Reputation points Microsoft Employee