ADX query/memory consumption limits using kql via Java SDK not working
Hello everyone, I am trying to query 1m entries from an ADX cluster via Java SDK. Since the entries are a lot I am performing it via paginated queries of size 50k. 50k entries for my table correspond to 70MB which as you can already tell I am getting…
Is it possible to automate trusting an Azure Data Explorer database connection?
We dynamically create Azure users and generate a database for each user in our Azure Data Explorer cluster. There is a security feature in Data Explorer that asks the user whether they want to trust the connection to the database (see attached…
How to ingest data in ADX using python script
I am using free trial and trying to ingest data into ADX using python SDK but facing this issue An error occurred: Principal 'msauser=1:live.com:00037FFE6E855292' is not authorized to perform operation 'Ingest' on 'any database'.
Using Conditional Formatting/ Formula to Compare Two Dates
I am trying to compare two dates in a large data sheet as a Success or Failure depending on the Ship Date. For example, on the first line, the Ship Date is 2/29/2024 which is after the due date (-1 of 2/26/2024), making it a failure. The Expected…
How can I schedule materialized view (refresh daily data at EOD )in data explorer?
Hi, currently I 'have setup one materialized view, but I want to update view on at end of the day. Currently it's getting updated in near time. Is it possible in materialized view to schedule query on daily basis only ?
How to parse json string using kql
Log line looks something like this [QueueTrigger] Event Stats {'total_events': 8388, 'file_count': 2, 'aggregated_file_size': 573292} and kql is traces | where operation_Name has "QueueTriggerFuncApp" and message has 'Event stats' |…
Query execution has exceeded the allowed limits (80DA0001)
Query Limits Exceeded Query execution has exceeded the allowed limits (80DA0001): 'summarize' operator has exceeded the memory budget (5368709120) during evaluation. Results may be incorrect or incomplete (E_RUNAWAY_QUERY; see…
Azure Data Explorer - cannot share dashboard
Dear community I am following this tutorial https://learn.microsoft.com/en-us/azure/data-explorer/azure-data-explorer-dashboards#share-dashboards and trying to shae a dashbaord created in Azure Data Explorer, however, when adding members, either with…
Getting 0 results for partitioned external table in Azure Storage
I have an Azure App Gateway's WAF logs being written to blob storage and I'd like to query the data. We have been using Log Analytics to do this, so the move to blob storage is part of an effort to see if we can store the data with a retention policy…
ADX cost estimation
I want to prepare an estimate for ADX with 2TB monthly data.. I checked this link "https://dataexplorer.azure.com/AzureDataExplorerCostEstimator.html " . What should I put in for the field "Estimated Data Compression (x times)" …
Azure Data Explorer: effective costs different than pricing calculator
Dear community I have created an Azure Data Explorer cluster, as a dev/test environment. The pricing calculator was estimating a certain amount for this setup but thereal cost is higher than that. Looking into the details it seems that the cluster has…
Need a KQL query to parse the given json according to the table structure given .
Dear Team, I am seeking your expertise to flatten a JSON file and store its contents in the specified table structure within Azure Data Explorer (ADX). Additionally, I require this transformation to be encapsulated as a function for reusability and…
Encountered Error When Recreating Azure Kusto Cluster: Name Already Taken
Hello, I recently removed an existing Kusto cluster from Azure using the "az kusto cluster remove" command. However, when attempting to recreate a new cluster with the same name, I encountered the following error message: "Name 'XXXX'…
Azure Data Explorer Ingestion from Event Hub using Private End point not working
I created event hub, send and receive some data and then installed azure data explorer and ingested the data from event hub. Then after that I created private endpoint on event hub and disabled the Public access. Created Private Endpoint on Azure Data…
Deploy ADX tables ,fucntions and mapping from NonProd to Prod using Kusto Command task in Azure DevOPS
I have a Azure Pipeline for deploying ADX tables and Functions using Kusto command task , how ever when I try deploying I am getting this weird error 2024-03-12T11:47:23.2165596Z ##[error]Service returned an error: Error: getaddrinfo ENOTFOUND…
Connect Az managed Grafana instance to Azure Data Explorer cluster
I have an Azure Data Explorer cluster that's stood up in tenant A. I am trying to connect to it from my Grafana UI(adding a new data source), which is in tenant B. In the Azure Data Explorer cluster DB, I have added the necessary permissions using the…
How to fix MAC signature found in the HTTP request is not the same as the computed signature. Server used following string to sign , in cosmosdb after key rotation
I rotated all the keys at once in the keys plane on the portal. (All older than 470 days). After that getting: Message: {"Errors":["The MAC signature found in the HTTP request is not the same as the computed signature. Server used…
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 dashboard
Hi Friends, I am new to Azure Synapse Analytics. I have deployed my Synapse workspace and also Data Explorer. I have ingested a CSV file. When I click on "Dashboard" in Azure Data Explorer page, I get an error: ""Unexpected server…