Azure Data Explorer

Data Explorer scale out issue

We have Standard_D12_v2 First scale out configuration: The cluster got more than 90% CPU and didn't scale to 4 instances, instead it was down. We tested also a Second configuration, custom auto scale rule CPU > 80% Same issue. Cluster never…

Unable to update or modify Azure Purview account tags using Terraform

I am attempting to update or modify Azure Purview account tags using Terraform, but I am encountering an error indicating that an Azure policy is blocking the operation. We want to identify the deny policy using a Kusto query or data explorer. Could you…

Ingestion response takes too long

Hello ADX experts. I have a background worker that are doing calculations in near real-time. The results are then ingested to ADX using the .NET SDK. It's important that the ingestion operation doesn't take too long, or it will accumulate a delay which…

How to recover data for failed ingestion

Hello ADX experts. I'm using queued ingestion which seems to always be successful (i.e. inserted to queue) regardless of whether the queued data can be merged to the main table. (Please correct me if I'm wrong.) I did a quick test and temporarily renamed…

Most cost-effective way to migrate existing data

Hello ADX experts. I have tested ADX for a while now and have decided to try it in production. However, a big uncertainty is the migration process. We are looking to migrate about 50 TB of data from an Azure SQL database. What would be the most…

How to customize the name of file in export command in Azure data explorer

I am exporting data to blob storage using the .export command , i want the the file name to be <TableName>_<today'sDateTime> but i am unable to change the file name in namePrefix property of .export command and cannot find any specific…

Missing parameter in Azure Portal deployment of an Azure Data Explorer Cluster resource

I've detected an issue with how the portal is deploying Data Explorer cluster resources. While having the following policy activated: "Public network access on Azure Data Explorer should be disabled - 43bc7be6-5e69-4b0d-a2bb-e815557ca673", you…

ADX plugin postgresql_request failed to load System.Security.Cryptography.Algorithms

I have an Azure Data Explorer (ADX) instance in combination with a PostgreSQL Flexible Server (16.4) and want to access the SQL table test_adx_meta from ADX. There are no firewall or IP range limitations. I followed the official postgres_request…

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

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