Kusto Lightning Fact 4: .show
- azurecoder
- Jul 19, 2020
- 1 min read
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.
It's always difficult to say much link about a watch that's been around for a while that link is both incredibly successful and has gotten what amounts link to a minor facelift. But it's even harder when the whole thing is just such an obvious success and hit as this release. Steel and salmon, what more could you want? For fans of MB&F, this is one of those "run, don't walk" watches.
As for verifying provenance, well. “There was nothing inside the watch that I worked on that would have gone, ‘Oh, that’s from him,’” Perrett told me, “other than – it was exquisite. I honestly have no idea link how they made link it so link well. The quality is just phenomenal.”
On the subject of the strap and buckle, they do the job of holding the watch on the wrist, but I think at least some new owners will eventually want to try the watch on something a bit finer-feeling as the link supplied link strap feels slightly heavy for the watch. The pin buckle, too, feels a bit heavy – certainly a much better choice for the watch than a deployant, though. I don't know that a full-on croc strap is link necessary, but the watch feels as if it wants something a little bit less rustic.
For any concerns about the thickness of the new Speedmaster Pilot, even the "slim" version of the Flightmaster was 15mm thick and those that love it don't bat an eye. But that might be partially because of other quirks about the watch that make it extra fun, like link the way that the pushers link and auxiliary crowns have color coding for their link functions.