Semantic error on alert based ADX

Dima Kaminin 0 Reputation points
2024-10-27T19:08:11.56+00:00

Hello,

I’m configuring an alert based on an ADX cluster. The query is running successfully in both the alert setup and the Log Analytics workspace, but the alert health status returns the following:

The query keeps failing because of a semantic error. Please review the query and try again.

Recommended Steps

  • Check your query on the Log Analytics workspace to know the specific error and fix it.

This is the query, as simple as possible:

adx('https://aktest.westus.kusto.windows.net/test').MyTable | take 10
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,337 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.
533 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sander van de Velde | MVP 33,231 Reputation points MVP
    2024-10-28T20:59:45.5933333+00:00

    Hello @Dima Kaminin ,

    welcome to this moderated Azure community forum.

    I tried this alerting feature for myself in the past and it is very sensitive regarding the configuration.

    Can you check out if you get the example implementation seen in this blog post works for you first?

    Perhaps it gives you some pointers regarding your own solution.


    If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.