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: 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
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
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
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: 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 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
.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
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
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
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
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
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
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 Data Explorer
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
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
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
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
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
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…