533 questions with Azure Data Explorer tags

Sort by: Updated
1 answer

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…

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.
533 questions
asked 2024-11-15T15:18:10.8766667+00:00
REZAI Arash 0 Reputation points
commented 2024-11-19T19:54:41.6333333+00:00
Sander van de Velde | MVP 33,231 Reputation points MVP
2 answers

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…

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.
533 questions
Azure Database for PostgreSQL
asked 2024-11-13T10:24:34.47+00:00
lwerthm 0 Reputation points
commented 2024-11-18T17:40:24.5566667+00:00
Mahesh Kurva 975 Reputation points Microsoft Vendor
2 answers

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…

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.
533 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,955 questions
asked 2024-11-07T15:56:52.2233333+00:00
SohamPrasad Girde (Wipro Designit Services, Inc.) 40 Reputation points Microsoft Vendor
commented 2024-11-11T12:03:18.39+00:00
Ganesh Gurram 1,510 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

When will Azure Data Explorer pool for Synapse become GA

When will Azure Data Explorer pool for Synapse become GA

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.
533 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,012 questions
asked 2024-11-04T16:19:22.2766667+00:00
Himanshu Zinzuwadia 45 Reputation points
commented 2024-11-06T23:19:01.3866667+00:00
Sander van de Velde | MVP 33,231 Reputation points MVP
4 answers

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 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.
533 questions
asked 2023-07-05T08:54:43.08+00:00
Truong Nga 10 Reputation points
commented 2024-11-04T15:14:47.5433333+00:00
Andres Quesada Ruiz 0 Reputation points
1 answer

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 Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,337 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.
533 questions
asked 2024-10-27T19:08:11.56+00:00
Dima Kaminin 0 Reputation points
edited an answer 2024-10-28T21:00:48.9633333+00:00
Sander van de Velde | MVP 33,231 Reputation points MVP
1 answer One of the answers was accepted by the question author.

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?

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.
533 questions
asked 2024-10-21T16:17:41.7+00:00
Shai Sherman 20 Reputation points
accepted 2024-10-22T06:24:36.2666667+00:00
Shai Sherman 20 Reputation points
1 answer

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

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.
533 questions
asked 2024-10-14T03:14:03.4766667+00:00
Zhong, Shui Jin (Azure Account) 0 Reputation points
commented 2024-10-16T11:55:55.0366667+00:00
PRADEEPCHEEKATLA 90,241 Reputation points
1 answer

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) { …

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.
533 questions
asked 2024-09-26T10:33:04.77+00:00
AdamRnarsson-2213 0 Reputation points
commented 2024-10-15T20:49:57.3966667+00:00
Chandra Boorla 3,460 Reputation points Microsoft Vendor
1 answer

Manage Azure Data Explorer Dashboard Programatically

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

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.
533 questions
asked 2024-10-08T14:46:39.9766667+00:00
Quirin, Antoine 0 Reputation points
commented 2024-10-14T06:00:15.61+00:00
PRADEEPCHEEKATLA 90,241 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:…

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.
533 questions
asked 2024-08-02T20:19:33.97+00:00
Ori Bandel 30 Reputation points
commented 2024-10-12T20:55:26.3566667+00:00
Ori Bandel 30 Reputation points
1 answer

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

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.
533 questions
asked 2024-10-03T17:31:07.81+00:00
John Thoni 0 Reputation points Microsoft Employee
answered 2024-10-04T02:18:12.8066667+00:00
phemanth 11,465 Reputation points Microsoft Vendor
0 answers

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…

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.
533 questions
asked 2021-10-19T05:39:42.39+00:00
Amy Z 296 Reputation points
edited a comment 2024-10-02T13:39:06.63+00:00
Weber, Christian 0 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…

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.
533 questions
asked 2024-03-08T15:53:20.1633333+00:00
Alex Lorimer 0 Reputation points
commented 2024-09-27T16:05:37.83+00:00
Alex Lorimer 0 Reputation points
2 answers One of the answers was accepted by the question author.

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

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.
533 questions
asked 2024-09-26T07:29:33.0666667+00:00
Wes Verhagen 50 Reputation points
accepted 2024-09-27T10:03:09.8833333+00:00
Wes Verhagen 50 Reputation points
1 answer One of the answers was accepted by the question author.

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…

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.
533 questions
asked 2023-11-24T12:40:50.0566667+00:00
PRIYANKA S NAIR 40 Reputation points
accepted 2024-09-25T10:49:37.15+00:00
PRIYANKA S NAIR 40 Reputation points
1 answer

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…

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.
533 questions
asked 2024-09-18T14:43:32.8866667+00:00
Marcos Olmedilla 0 Reputation points
commented 2024-09-20T17:17:37.1933333+00:00
Smaran Thoomu 17,520 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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?

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.
533 questions
asked 2024-08-12T11:36:43.82+00:00
Muhammad Usman Rafiq 20 Reputation points
accepted 2024-09-20T06:52:12.04+00:00
Muhammad Usman Rafiq 20 Reputation points
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…

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.
533 questions
asked 2024-09-13T21:38:37.6866667+00:00
Dhinesh Sornakili 0 Reputation points
commented 2024-09-17T06:06:18.2766667+00:00
PRADEEPCHEEKATLA 90,241 Reputation points
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

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.
533 questions
asked 2024-08-09T18:40:58.83+00:00
Shiva Lakshman Nallakatta 0 Reputation points Microsoft Employee
edited an answer 2024-09-16T12:00:27.4333333+00:00
Sander van de Velde | MVP 33,231 Reputation points MVP