Reader small image

You're reading from  Scalable Data Analytics with Azure Data Explorer

Product typeBook
Published inMar 2022
Reading LevelBeginner
PublisherPackt
ISBN-139781801078542
Edition1st Edition
Languages
Concepts
Right arrow
Author (1)
Jason Myerscough
Jason Myerscough
author image
Jason Myerscough

Jason Myerscough is a director of Site Reliability Engineering and cloud architect at Nuance Communications. He has been working with Azure daily since 2015. He has migrated his company's flagship product to Azure and designed the environment to be secure and scalable across 16 different Azure regions by applying cloud best practices and governance. He is currently certified as an Azure Administrator (AZ-103) and an Azure DevOps Expert (AZ-400). He holds a first-class bachelor's degree with honors in software engineering and a first class master’s degree in computing.
Read more about Jason Myerscough

Right arrow

Introducing KQL's management commands

Just like SQL has its Data Manipulation Language (DML) and Data Definition Language (DDL), KQL has them both, and they are referred to as the KQL management commands. The management commands allow us to manage our clusters, databases, and tables. For example, we can create, modify, and delete tables, get insights into our cluster configuration, and more. In this section, we will learn about some of the most useful management commands KQL provides. We will first look at cluster and database management commands and then we will learn about table management commands.

Cluster management

The first set of commands we will learn about are the cluster management commands. These commands provide cluster configuration and diagnostic information, which is helpful when troubleshooting issues.

The first command we will look at is .show cluster. The .show cluster management command returns a list of all nodes in the ADX cluster. As shown in Figure...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Scalable Data Analytics with Azure Data Explorer
Published in: Mar 2022Publisher: PacktISBN-13: 9781801078542

Author (1)

author image
Jason Myerscough

Jason Myerscough is a director of Site Reliability Engineering and cloud architect at Nuance Communications. He has been working with Azure daily since 2015. He has migrated his company's flagship product to Azure and designed the environment to be secure and scalable across 16 different Azure regions by applying cloud best practices and governance. He is currently certified as an Azure Administrator (AZ-103) and an Azure DevOps Expert (AZ-400). He holds a first-class bachelor's degree with honors in software engineering and a first class master’s degree in computing.
Read more about Jason Myerscough