AdxUtilities 2024.2.6.56

Azure Data Explorer Utilities

This is a command line application which is intended to provide a useful set of utilities for working with Azure Data Explorer. Mostly to make things easier where some tasks are not supported by the Azure CLI or are needed to work in a way to support other activities.

Installation

You can install the utility as a dotnet global tool using the published package available at nuget.org.

> dotnet tool install --global AdxUtilities

Authentication

The app can currently use either Client Secret Key authentication, or Azure CLI authentication. Using CLI authentication allows the application to make use of the existing sign-in information from the Azure CLI tool.

Export

This is the first of the utilities developed which automates the generation of a CSL script for a given database. The script contains the commands needed to re-create the tables and functions, along with mapping information. It also supports renaming of tables and the ability to copy data using an .set-or-replace command with datatable operator. The generated output is intended to work with the Azure DevOps Task for Data Explorer where the commands are split based on empty lines and executed individually against the target database. The generated script can just as easily be executed directly by using an .execute database script.

An example usage of the command is

> adxutils -c https://myinstance.region.kusto.windows.net/
           -d my-database
           --ignore Table3
           --function folder3/,function1
           --export Table1,Table2
           --rename Table4=Table5
           --update table=Table1 columnType=Type columnToAdd=Column1 columnToDrop=Column2
           --use-cli