Cannot view data lake gen 2 containers using analytics synapse linked service view (even with the contributor permission granted)
Each time i try to view the contents of a data lake gen 2 container using the portal 'Data' tab. I get the following error; 'Storage Explorer Error Uncaught ReferenceError: O is not defined.' I have already given the resource and myself, the storage…
Azure Data Explorer and other integration is not listed under the integration
Hi Team, I would like to integrate the Microsoft Azure Data Explorer in Viva. However it is not listed in the organization dashboard. Can someone help us on this? Though it is given on the search input, no results are found
Use certificate/FIC for Azure Data Explorer service connector on ADO
Hi team, our current azure data explorer service connector uses service principal key and secrets to authenticate. However, in response to a security incident we're solving, we need to convert the service connector to use SNI and certificates for…
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…