Azure Data Explorer

How to optimize ADX Cluster with very high CPU usage?

We're currently using 3 nodes in our ADX cluster, which are experiencing extreme workload due to running very heavy calculations that result in long periods (between 30-60 mins) of 100% CPU usage of the cluster (all nodes) The calculation can, and will,…

An admin command cannot be executed temporarily due to an internal state transition

We have an ADX cluster with two instances and java service querying external tables using jdbc sql driver. We ran a performance test, more than 3k requests. We saw many db query errors with this message: An admin command cannot be executed…

Not receiving diagnostic setting logs like ADXQuery to log analytics workspace from ADX

Hi Team, I am working with an ADX cluster. I require ADX diagnostic logs to analyse them. So earlier our team have enabled diagnostic settings in ADX and sending those logs to log analytics workspace. But there were no logs of ADX in log analytics…

Granting Azure Arc Managed Identity access to Azure Data Explorer cluster/DB

I'd like to allow an Azure Arc managed identity access to a few Azure Data Explorer DBs. It looks like this is possible for regular managed identities - you can grant access to a managed identity's object id. It doesn't look like Azure Arc machines have…

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…

Why do I get error for cross querying in Kusto

I can run my function successfully in local cluster but get errors while running in other clusters: Errors occurred while resolving remote entities. Cluster='https://dummy.kusto.windows.net/', Database='DummyDB': Semantic error: Schema of the stored…

Issue while connecting Kusto DB from Azure Data Factory using Service Principal Id and Certificate

We are trying to migrate to Service Principal Id and Certificate authentication to connect to Azure Data Explorer DB through Azure Data Factory Linked service. We are authenticating our .Net Applications from the same AME Certificate and AME Service…

How to delete data from Kusto table

I'm trying to use the .delete command instead of purge to remove data from a table. As, .delete does not change the ingestion timestamp, or the tags created and helps to restate the data when needed. The .delete command performs a soft delete, making…

Azure DataExplorer - autorization code

I want to create the token using the authorization code flow, I use this scope: https://management.azure.com/.default but I keep getting this error: 'HTTP/1.1 401 Unauthorized\r\n' header: WWW-Authenticate: Bearer…

Graph Match operator error when project is not specified

I'm going through examples here: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/graph-match-operator I'm attempting to use an anonymous node and edge combinations to get all matching nodes with the pattern ()--[]--() which to my…

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 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'.

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…

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

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' |…

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

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…