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

Question

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

Answer 1

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.