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.
522 questions
0 answers
How materialized views work in Azure Data Explorer regarding cache policy?
Hey everyone, I am trying to implement some materialized views within my ADX cluster. I need to backfill the data for the last year and I understood that I must increase my hot cache policy for it to be able to. I have two questions regarding that: is it…
asked 2024-09-18T14:43:32.8866667+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, 86%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMO%3C/text%3E%3C/svg%3E)
Marcos Olmedilla
0
Reputation points
commented 2024-09-19T19:42:13.0466667+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
15,040
Reputation points Microsoft Vendor
1 answer
Does the Managed Identity on GitHub action work with Delta-Kusto to connect ADX?
I'm working on a KQL scripts repo in GitHub and using Delta-Kusto (https://github.com/microsoft/delta-kusto) to implement CI/CD to ADX. Currently, I'm using a Service Principle to connect ADX and deploy, but I'm curious if there's a way to use Managed…
asked 2024-09-13T21:38:37.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(99.2, 30%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dhinesh Sornakili
0
Reputation points
commented 2024-09-17T06:06:18.2766667+00:00
PRADEEPCHEEKATLA-MSFT
88,876
Reputation points Microsoft Employee
1 answer
Kusto Load Balancer
Hi, Is it possible to setup a load balancer in front of two Kusto clusters. Could you please let me know if this is feasible and what steps would be involved in implementing such a setup? Your guidance on this matter would be greatly appreciated. Thanks
asked 2024-08-09T18:40:58.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(214.4, 20%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Shiva Lakshman Nallakatta
0
Reputation points Microsoft Employee
edited an answer 2024-09-16T12:00:27.4333333+00:00
Sander van de Velde | MVP
32,086
Reputation points MVP
1 answer
How to access the databases and their tables while executing the KQL query at the cluster level?
i want to access the databases and their tables at the cluster connection level how can i achieve that?
asked 2024-08-12T11:36:43.82+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(9.6, 68%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Muhammad Usman Rafiq
0
Reputation points
commented 2024-09-16T05:50:26.6166667+00:00
AnnuKumari-MSFT
32,821
Reputation points Microsoft Employee
1 answer
Best data architecture strategy in Azure Data Explorer
Hey everyone, I have some questions regarding the best pracetices for the data architecture within Azure Data Explorer. We currently have multiple databases with similar telemetry data in tables from multiple clients. We would like to do some…
asked 2024-09-06T12:09:54.3133333+00:00
Marcos Olmedilla
0
Reputation points
commented 2024-09-10T16:14:13.56+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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
1,920
Reputation points Microsoft Vendor
1 answer
An admin command cannot be executed temporarily due to an internal state transition
We have an ADX cluster with two instances and java service querying external tables using jdbc sql driver. We ran a performance test, more than 3k requests. We saw many db query errors with this message: An admin command cannot be executed…
asked 2024-05-31T22:51:48.55+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-09-02T08:52:28.51+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
1 answer
YAML migration for Azure-Kusto query
I'm trying to trigger a gate check in YAML, this is what I have so far, with the sensitive bits removed. What is wrong with this snippet? I'm getting the following error - Encountered error(s) while parsing pipeline YAML:…
asked 2024-08-29T18:01:49.9233333+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, 56.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Abhay Punjabi
0
Reputation points Microsoft Employee
answered 2024-08-30T11:17:14.1466667+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
10,250
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Separate data in data explorer and use as datastore
Hello, We are sending data from IoT Central to Event Hubs and then to Data Explorer, with the hopes of then sending the data to Azure Machine Learning. In order to send data from Event Hubs to Data Explorer it needs a data ingestion into a table…
![](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, 69%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
![](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(272, 33%, 36%)' 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)
2 answers
E_LOW_MEMORY_CONDITION Query Execution lacks memory resource to complete (message: bad allocation)
Hi all, I'm new to ADX and I need your support. I used to use this query a week ago and it went well both in ADX and PBI but somehow it shows an error today as attached in PBI (in ADX is still working). Here is the query I used for reference. let T1 =…
asked 2024-08-26T04:56:33.5466667+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(195.2, 66%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sangsattaya, Manatsanan
0
Reputation points
answered 2024-08-26T10:10:00.63+00:00
phemanth
10,250
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure Data Explorer - PostgreSQL plugin - Entra ID support
I am working on integrating Postgres DB with ADX - I want to use the external table plugin. I see that currently the only authentication method supported is Username and Password. Is there planned adding EntraID support for the PostgreSQL plugin? Thanks…
asked 2024-08-21T09:50:30.87+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(19.2, 33%, 11%)' 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)
JAGODZINSKI Tomasz
20
Reputation points
edited a comment 2024-08-22T11:13:34.84+00:00
PRADEEPCHEEKATLA-MSFT
88,876
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Should I worry about a high number of extents?
Hello ADX experts. I am currently doing a POC to see if ADX will work for us. So far I enjoy the ADX developer experience. Since I haven't found a clear recommendation for how to partition my table, I have created two tables where I ingest identical…
asked 2024-08-12T22:02:28.9333333+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
65
Reputation points
commented 2024-08-14T13:18:37.8433333+00:00
Pål Kristian Halle
65
Reputation points
1 answer
How to add external Cache in Azure data explorer?
Currently, I have two instances of the "Standard_E8ads_v5" SKU, with CPU utilization ranging between 40% and 60%. However, the cache utilization is at 100%, and this is causing slow load times for cold cache data. I need to increase the CPU…
asked 2024-08-02T12:09:24.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(313.6, 3%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Shubham Jaunjal
0
Reputation points
commented 2024-08-13T20:23:43.94+00:00
Sander van de Velde | MVP
32,086
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Is there a better way to stream data?
Hello Support, We currently have a system where there are 10 devices per iot hub, and each of those devices are routed to their own event hub. From there they are ingested and streamed in ADX, each having there own table in the database. I tried using…
asked 2024-08-07T01:38:29.9633333+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, 89%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nathan Sommer
40
Reputation points
accepted 2024-08-08T23:33:24.1766667+00:00
Nathan Sommer
40
Reputation points
2 answers
One of the answers was accepted by the question author.
Kusto table not being detected by ADF Copy Data activity
Hello, I am creating a pipeline in Azure Data Factory that uses a Scope activity to generate some data and uses a Copy Data activity to push that data to Kusto. I manually created a table in Azure Data Explorer with the Schema alongside a new dataset…
![](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, 2%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFN%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Migrate from Azure SQL Hyperscale - Is ADX suitable?
Hi. We want to migrate our time series table from Azure SQL Database (Hyperscale tier), and ADX looks promising. I would like to do a POC first to see if it fits our needs, and I would be very grateful if someone can give me suggestions for different…
asked 2024-08-05T22:20:57.7633333+00:00
Pål Kristian Halle
65
Reputation points
commented 2024-08-06T21:47:35.4266667+00:00
Pål Kristian Halle
65
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
Ori Bandel
30
Reputation points
answered 2024-08-05T18:43:55.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(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)
Bhargava-MSFT
30,891
Reputation points Microsoft Employee
3 answers
Kusto Stored Function passing Dynamic parameter from C# Azure Function
Hey, I'm trying to create an Azure Function that queries the adx database. In my function would I create an object or list to pass to the Stored Function Using this in the in the code but getting an error queryGetTransaction = "declare…
asked 2022-01-27T16:35:05.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(115.19999999999999, 26%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZM%3C/text%3E%3C/svg%3E)
Zach Moore
6
Reputation points
answered 2024-08-05T13:55:27.66+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, 34%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Damiano Salezze
0
Reputation points
3 answers
One of the answers was accepted by the question author.
How to optimize ADX Cluster with very high CPU usage?
We're currently using 3 nodes in our ADX cluster, which are experiencing extreme workload due to running very heavy calculations that result in long periods (between 30-60 mins) of 100% CPU usage of the cluster (all nodes) The calculation can, and will,…
asked 2024-06-03T08:36:02.5766667+00:00
Ori Bandel
30
Reputation points
answered 2024-08-02T20:08:38.02+00:00
Ori Bandel
30
Reputation points
2 answers
MULTIJSON data format missing when creating a Data Explorer data connection in the Azure Portal
When creating a data connection from ADX/Kusto to EventHub, I would like to choose the MULTIJSON data format. If I recall correctly, this option was available in the Azure Portal, but there is only the JSON format now (see screenshot). The docs still…
asked 2023-11-01T20:42:29.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(211.20000000000002, 90%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
J-C
5
Reputation points
commented 2024-07-30T19:18:36.17+00:00
Sander van de Velde | MVP
32,086
Reputation points MVP
1 answer
How to Add text to point(s) in Kusto Chart
I have a kql script that creates the table here and the line chart below the table. Is it possible to display text on one or more points, as where it says "Champion" in the line chart at bottom?: Query myquery | render linechart with ( …
asked 2024-07-21T17:23:17.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(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 2024-07-29T05:57:38.42+00:00
Smaran Thoomu
15,040
Reputation points Microsoft Vendor