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