595 questions with Azure Data Explorer tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

How can I recover Kusto data that was deleted due to a previous two-month retention policy?

We initially configured the retention period to two months. However, we've recently discovered the need to access data older than that. As a result, we've extended the retention period to six months. Despite this change, we still need to recover data…

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.
595 questions
asked 2025-10-13T06:52:23.99+00:00
Allen Yu 20 Reputation points Microsoft Employee
commented 2025-10-15T02:52:33.37+00:00
Allen Yu 20 Reputation points Microsoft Employee
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.
595 questions
asked 2025-10-03T09:43:00.3466667+00:00
01725609 105 Reputation points
edited a comment 2025-10-09T10:00:01.3+00:00
01725609 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.
595 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 500 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.
595 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.
595 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 31,045 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.
595 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.
595 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.
595 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,820 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.
595 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 110.5K Reputation points Volunteer Moderator
0 answers

Difficulty accessing web form to contact either the MS Privacy Team or the Data Protection Officer

Hello. I've been trying repeatedly to access the web form to submit a Data Subject Access Request (DSAR) via the Data Protection Officer at the following link provided: https://aka.ms/privacyresponsemsa However, each time I'm directed to sign in and then…

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.
595 questions
asked 2025-08-12T11:52:20.1466667+00:00
NotTodaySatan-667 0 Reputation points
edited the question 2025-08-12T13:00:58.1266667+00:00
Gérard Oomens 110.5K Reputation points Volunteer Moderator
1 answer

How to use existing cache for external table when acceleration in progress

I enabled query acceleration for my external table which binds a delta table (1TB) on ADLS. But acceleration progress needs 1.5 hours to complete. I found during acceleration in progress, querying on the table is quite slower than case when acceleration…

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.
595 questions
asked 2025-07-31T06:22:57.8233333+00:00
Kunpeng Fan 0 Reputation points Microsoft Employee
commented 2025-08-07T14:05:52.09+00:00
Smaran Thoomu 31,045 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

The time series visualisation for queries in data explorer shows blank when I choose the multiple panels option

Following the examples in (https://learn.microsoft.com/en-us/kusto/query/anomaly-detection?view=microsoft-fabric) I'm trying to visualize a decomposition of a time series in Azure Data Explorer. However, when I choose the y-split option, the y-panels…

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.
595 questions
asked 2025-07-31T08:41:44.12+00:00
Cedric Mélange 20 Reputation points
accepted 2025-08-06T15:22:45.9466667+00:00
Cedric Mélange 20 Reputation points
1 answer One of the answers was accepted by the question author.

Need access to Kusto cluster DB - https://azure***&&&**.kusto.windows.net

We are trying to get access to [ https://azure***&&&**.kusto.windows.net ] kusto cluster DB to view the telemetry details and also finding the latest details who access the resource for all the subscription under Azure Storage service, need…

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.
595 questions
asked 2025-08-05T12:23:15.84+00:00
Pavan Kumar Varma Nadimpilli (MINDTREE LIMITED) 20 Reputation points Microsoft External Staff
accepted 2025-08-06T11:17:20.8366667+00:00
Pavan Kumar Varma Nadimpilli (MINDTREE LIMITED) 20 Reputation points Microsoft External Staff
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…

Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
750 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.
595 questions
asked 2023-11-01T20:42:29.5433333+00:00
Anonymous
commented 2025-08-01T19:13:35.1833333+00:00
Morais, Nelson 5 Reputation points
1 answer

Azure Data Explorer Kusto Sort Order make_set guaranteed order of input

Hi, https://learn.microsoft.com/en-us/kusto/query/make-set-aggregation-function?view=microsoft-fabric Above link says "The array's sort order is undefined". Is there a way to construct the array guaranteeing preserving the order of input…

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.
595 questions
asked 2025-07-31T21:06:01.9133333+00:00
databricksuser-5173 20 Reputation points
commented 2025-08-01T16:38:49.75+00:00
Venkat Reddy Navari 5,820 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Wrong extent dates in ADX deduplicated materialized view

Hi I'm having the following scenario. We have a Source Table (which can include duplicate records) We have a materialized view which deduplicates with the following command: .create materialized-view with (lookback=1d,…

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.
595 questions
asked 2025-07-15T10:47:17.63+00:00
01725609 105 Reputation points
accepted 2025-07-22T19:34:35.91+00:00
01725609 105 Reputation points
1 answer

Not able to run Kusto Explorer on my Local Machine

Kusto Explorer is not running on my local machine. Snippet of the Log file. COMPONENT STORE TRANSACTION FAILURE SUMMARY * Transaction at [17-07-2025 14:27:03] - Staging of a component (GJODRCJV.HAW.application) did not succeed. - Setting one or…

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.
595 questions
asked 2025-07-17T09:04:52.9633333+00:00
Rajarshi Sarkar 0 Reputation points Microsoft Employee
commented 2025-07-22T19:17:24.62+00:00
Smaran Thoomu 31,045 Reputation points Microsoft External Staff Moderator
2 answers

ADX cluster 1 zone

We currently have an Azure Data Explorer (ADX) cluster configured to run across Availability Zones 1, 2, and 3. The cluster is marked as Zonal, and under the cluster settings, it shows: Availability zones: 1, 2, 3 Zones status: Zonal Since this is 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.
595 questions
asked 2025-07-18T12:53:22.9866667+00:00
Sereena Kurunkadan 0 Reputation points
answered 2025-07-22T14:43:14.7933333+00:00
Sander van de Velde | MVP 36,951 Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

How do custom lookback columns in Azure Data Explorer deduplication Materialized Views work?

I was wondering if anybody has experience using lookback columns within deduplication Materialized Views in Adx https://learn.microsoft.com/en-us/kusto/management/materialized-views/materialized-view-create?view=microsoft-fabric#lookback-column Let's…

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.
595 questions
asked 2025-07-12T08:03:21.56+00:00
01725609 105 Reputation points
accepted 2025-07-14T08:07:48.92+00:00
01725609 105 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Data Explorer

Hello, I was looking for a way to connect Azure Data Explorer to storage account that has public access disabled, I noticed that Vnet Injection was deprecated in February. Is there any other way to connect securely to a storage account? Best…

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.
595 questions
asked 2025-06-30T15:20:31.4133333+00:00
Michel SFEIR 20 Reputation points
commented 2025-06-30T17:44:52.85+00:00
Michel SFEIR 20 Reputation points