• azurecoder

Kusto Lightning Fact 4: .show

A key facet of using Azure Data Explorer is the ability to easily use command control. For those that have a good SQL background some of the things you'll see discussed here are like DMVs (Data Management Views) but much easier to interpret and execute.

Starting from the top we have:

.show table sales principals

This shows the access control permissions for the sales table. If you execute it the results would be broken down into these Roles:

  • Cluster AllDatabasesAdmin

  • Database master Admin

  • Table sales Admin

From the top we have cluster permissions, then database permissions and then specific permissions to the sales table. On my table I personally have all 3 sets!

In addition there are a few types of principals:

  • AAD Users

  • AAD Groups

  • AAD Applications

All of these types are supported as principals.

.show databases

shows a list of databases on the cluster and associated things like version and the storage account where the database is stored.

.show capacity

will be useful later on when we look at ingesting data into ADX. For now it shows the number of "slots" available for ingesting to include connections to ingest from various sources as well as streaming ingestion slots. There are some features for "extents" which are partitions within a table as well.

.show cache

shows the details of the cache. The cache is used to cache most commonly used queries. The larger your cluster the more cache you're likely to have. Cache speeds up most used queries and makes your cluster much more efficient.

There are many more uses of .show which we haven't covered but these should get you started and cover the majority of things you'll find useful over time.

40 views0 comments

Recent Posts

See All