Azure Data Explorer

How to fix internal server error 500 for kusto db using user managed identity ?

Hi , I am trying to use user assigned managed identity to connect with KUSTO db but getting internal server error 500 . kusto db already given the permissions to my managed identity . I am concern about the app service environment variable is that…

When will Azure Data Explorer pool for Synapse become GA

When will Azure Data Explorer pool for Synapse become GA

How to fix 'parse' operator: Failed to resolve scalar expression named 'msg_s' If the issue persists, please open a support ticket. Request id: 117cf54a-1039-4496-b8b1-13730efa136e

Semantic error on alert based ADX

Hello, I’m configuring an alert based on an ADX cluster. The query is running successfully in both the alert setup and the Log Analytics workspace, but the alert health status returns the following: The query keeps failing because of a semantic error.…

Azure ADX materialize() function

Is the materialize() function that is mentioned in this page: https://learn.microsoft.com/en-us/kusto/query/materialize-function?view=microsoft-fabric is GA?

how to find the resource in portal for with KQL for this type: microsoft.insights/workloadmonitoring

how to find the resource in portal for with KQL for this type: microsoft.insights/workloadmonitoring

Allowed operator in Azure Data Explorer RLS function

I'm attempting to implement RLS in ADX on already ingested data. The RLS policy function I'm creating looks like this. .create-or-alter function with (docstring = 'Restricts access to data.', folder = 'RLS') RestrictAccess(TableName: string) { …

Manage Azure Data Explorer Dashboard Programatically

Hi, I wanted to check if there is any ETA for the release of this feature. Regards, Antoine

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:…

Return rows that only have nulls?

I'm using Kusto/KQL. I have a huge dataset that I am working with that was migrated from another sources. I know that many of the fields only have null values. I'd like to be able to identify those columns. Sort of doing a null check on column by column,…

ODBC uses service principal to connect to ADX

Hi, we're trying to let ODBC uses azure service principal to connect to ADX but encounters the error Error requesting access token The reference guide is this : https://learn.microsoft.com/en-us/azure/data-explorer/connect-odbc The client is…

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…

Intermittent Error with Materialized View in Kusto: "Index was outside the bounds of the array"

Hello, I'm encountering an issue with a materialized view in Kusto where I sometimes get an error when querying the view. Below is my materialized view definition: // materialized-views .create async materialized-view with (backfill=True,…

how to delete a table in azure data explorer using kql query?

I was trying to delete a table called Heartbeat from Azure Data Explorer DB using a KQL script. The contents of the kql script is: .drop table Heartbeat ifexists On executing the kql script using github workflows, Im getting the following error: The…

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…

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?

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…

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

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…

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…