604 questions with Azure Data Explorer tags

Sort by: Updated
Updated Created Answers
5 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.
604 questions
asked 2023-07-05T08:54:43.08+00:00
Truong Nga 15 Reputation points
edited an answer 2025-12-05T19:35:37.8766667+00:00
Gavin Stevens 0 Reputation points
2 answers

ADX streaming ingestion failures for non-streaming tables

I have several ADX outputs from various Azure Stream Analytics (ASA) jobs. All the outputs are configured on tables in databases where the tables have streaming ingestion disabled and the ingestion batching policy is inherited from the database. However,…

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.
604 questions
asked 2025-12-01T19:58:27.55+00:00
Javier Huamani 60 Reputation points
commented 2025-12-05T18:04:10.4766667+00:00
Pilladi Padma Sai Manisha 500 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Empty workspaces in Azure Data Explorer web portal

Hi, I am getting this odd experience on Azure Data Explorer web portal since this morning. I cannot see any of my dashboards, and none of the dashboard links that I bookmarked works. As soon as I open the dashbaord link (which worked completely earlier…

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.
604 questions
asked 2025-12-02T03:30:19.92+00:00
Feng Pan 20 Reputation points Microsoft Employee
accepted 2025-12-05T03:17:13.3266667+00:00
Feng Pan 20 Reputation points Microsoft Employee
3 answers

Deploying Azure Database Watcher via IaC fails intermittently

Hi there, I'm deploying the preview of Azure Database Watcher but I'm seeing some odd behaviour. When deploying the cluster, I receive the error below after deployments often. This is the bicep excerpt for the cluster deployment. I can't reproduce…

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.
604 questions
asked 2025-11-26T14:21:03.04+00:00
Daniel Rogers 1 Reputation point
answered 2025-11-28T11:19:47.4+00:00
Sina Salam 26,661 Reputation points Volunteer Moderator
1 answer

top 10 tables in Log Analytics Workspace

Hi All,   i want to see the top 10 tables using more space in the log analytics work space. need some help to fetch the top 10 tables can anyone please help me with query which can pull the top 10 tables using more space   appreciate for help in this. 

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.
604 questions
asked 2023-08-07T06:39:59.0733333+00:00
Venu Gopal Krishna VV 100 Reputation points
commented 2025-11-20T10:58:44.1166667+00:00
Janne Kujanpää 261 Reputation points
1 answer One of the answers was accepted by the question author.

Encoding policy and materialized views

Hello ADX experts. What happens if the source table of a materialized view has an encoding policy set for one or more columns? Is the encoding policy preserved in the MV, or is it just ignored? I have the following staging table defined: .create table…

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.
604 questions
asked 2025-11-11T07:31:31.1033333+00:00
Pål Kristian Halle 155 Reputation points
edited the question 2025-11-18T07:52:56.53+00:00
Pål Kristian Halle 155 Reputation points
1 answer

Table Level Security

I'm trying to grant access for certian groups based on tables. Right now everyone can see everything, only specific people need to see certain tables. How do I fix this? Thanks, Nathan

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.
604 questions
asked 2025-11-05T16:29:39.05+00:00
Nathan Sommer 40 Reputation points
commented 2025-11-10T08:50:40.5933333+00:00
Kalyani Kondavaradala 4,595 Reputation points Microsoft External Staff Moderator
1 answer

Is it possible to use an external table with an Azure SQL VM?

Hello, I am using an instance of SQL Server on an Azure VM, and I wanted to know if it is possible to use ADX External Tables. The VM does not have a public IP.

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.
604 questions
asked 2025-10-20T17:42:13.5266667+00:00
John Ellison 1 Reputation point
accepted 2025-11-06T19:41:32.8533333+00:00
John Ellison 1 Reputation point
2 answers One of the answers was accepted by the question author.

Most efficient way to take _n_ rows per group

Hello ADX experts. I have an ADX database with IoT sensor data. My use case is to retrieve a specified number of readings (rows) per MetricId after a certain date. The most natural way to do this seems to be using the partition by operator like…

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.
604 questions
asked 2025-11-03T12:11:48.5+00:00
Pål Kristian Halle 155 Reputation points
accepted 2025-11-05T09:41:22.2466667+00:00
Pål Kristian Halle 155 Reputation points
1 answer

Azure Data Explorer: LightIngest Managed Identity Authentication Issue

Hi all Hoping somebody could help me out here. We currently are trying to run LightIngest in a containerapp job in order to ingest massive amounts of data into adx, and do this with extra control mechanisms. however, the authentication via 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.
604 questions
asked 2025-10-03T09:43:00.3466667+00:00
01725609 105 Reputation points
edited a comment 2025-10-28T09:26:15.53+00:00
Pratyush Vashistha 5,045 Reputation points Microsoft External Staff Moderator
1 answer

ADX performance issues

Hello , How to troubleshoot a ADX performance issues ? thanks Himanshu

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.
604 questions
asked 2025-10-27T19:59:19.52+00:00
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator
answered 2025-10-27T23:45:26.4933333+00:00
Swapnesh Panchal 1,380 Reputation points Microsoft External Staff Moderator
1 answer

Best practices for designing an ETL process for ingesting large volumes

How would you design an ETL process for ingesting large volumes of data from multiple sources into Azure Data Explorer? What are some best practices to keep in mind?

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.
604 questions
asked 2025-10-22T20:34:34.9666667+00:00
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator
commented 2025-10-22T22:34:28.5066667+00:00
Swapnesh Panchal 1,380 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How can I improve query performance in Azure Data Explorer for high-volume application logs?

I'm analyzing web platform logs stored in an AppLogs table with columns like LogID, Timestamp, EventType, and Details. Most queries filter by EventType or time ranges to track errors. During periods of high log volume, I’m seeing issues like: Slow query…

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.
604 questions
asked 2025-10-16T18:33:02.59+00:00
pr2380 105 Reputation points
accepted 2025-10-17T16:26:43.3266667+00:00
pr2380 105 Reputation points
1 answer

Native Julia Connector for Azure Data Explorer

Dear Microsoft Azure Data Explorer Product Team, I am writing to formally request the development and support of a native Julia connector for Azure Data Explorer (Kusto). At present, Julia lacks an official or community-supported package for seamless…

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.
604 questions
asked 2025-09-30T08:08:14.15+00:00
Miguel 0 Reputation points
commented 2025-10-02T20:29:28.1966667+00:00
Swapnesh Panchal 1,380 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How do I know which service or part of service is generating a specific bill?

I marked as Data Explorer because it's where I am struggling currently but this can probably be applied to everything else. I have an ADX Cluster which I am being charged, for example, Hot ZRS Read and Write Operations. I also have cold read and write…

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.
604 questions
asked 2025-10-02T11:58:07.3133333+00:00
Nuno Rodrigues 20 Reputation points
accepted 2025-10-02T13:56:30.08+00:00
Nuno Rodrigues 20 Reputation points
1 answer

Cannot install KustoExplorer from https://aka.ms/ke

When trying to install the KustoExplorer from https://aka.ms/ke I get the following error during installation: PLATFORM VERSION INFO Windows : 10.0.22631.0 (Win32NT) Common Language Runtime : 4.0.30319.42000 System.Deployment.dll : 4.8.9176.0…

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.
604 questions
asked 2025-09-24T09:46:31.6933333+00:00
eer 0 Reputation points
answered 2025-09-24T12:27:09.4366667+00:00
Smaran Thoomu 32,520 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Azure Data Explorer: Working with aggregation materialized views and historical data

HI We have the following scenario SourceTable => Deduplication Materialized View => Multiple Aggregation Materialized views based on the deduplicated view (Daily, Weekly, Monthly) In the source table we can backfill historical data with…

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.
604 questions
asked 2025-08-27T07:13:57.3366667+00:00
01725609 105 Reputation points
edited a comment 2025-09-02T13:04:21.15+00:00
01725609 105 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Data Explorer query with joins + sort extremely slow (40s runtime, 2GB peak memory)

Hello, I am currently evaluating Azure Data Explorer (ADX) for my application and facing severe performance issues. My workload requires retrieving data quickly (ideally within 1–2 seconds) with queries that involve joins and sorting over large datasets.…

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.
604 questions
asked 2025-08-30T19:53:15.24+00:00
User1279836 20 Reputation points
accepted 2025-09-01T06:47:00.3333333+00:00
User1279836 20 Reputation points
1 answer

.alter column policy encoding for larger than BigObject32 provision

Hi https://learn.microsoft.com/en-us/kusto/management/alter-encoding-policy?view=microsoft-fabric Per above documentation, the largest object that can be held in a column is 32MB. How do we deal with objects larger than 32MB, for example - to process an…

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.
604 questions
asked 2025-08-17T20:59:53.71+00:00
databricksuser-5173 20 Reputation points
commented 2025-08-20T07:33:31.43+00:00
Venkat Reddy Navari 5,830 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Star schema with multiple fact tables

How would you structure your data if we have two fact tables. As an example, let's say I have an Accounts table as a dimension table, so only a single row for each account. Then I have an Orders table which could have multiple orders per Account. And a…

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.
604 questions
asked 2024-10-26T16:55:16.31+00:00
Carnabuci, Michael P 40 Reputation points
edited the question 2025-08-13T08:55:50.4466667+00:00
Gérard Oomens 113.2K Reputation points Volunteer Moderator