How to access the databases and their tables while executing the KQL query at the cluster level?

Muhammad Usman Rafiq 20 Reputation points
2024-08-12T11:36:43.82+00:00

User's image

i want to access the databases and their tables at the cluster connection level how can i achieve that?

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.
526 questions
{count} votes

Accepted answer
  1. Sander van de Velde | MVP 32,726 Reputation points MVP
    2024-08-12T20:48:33.2833333+00:00

    Hello @Muhammad Usman Rafiq ,

    welcome to this moderated Azure community forum.

    Have you tried to start with the cluster() command first while building up your query?

    As seen in the samples there, you can do something like:

    cluster('help.kusto.windows.net').database('Samples').StormEvents | count
    

    I think you do not need that '.datajson' to count the data rows.


    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful

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.