KQL Series – some DevOps things: Provisioning using Powershell

If you have read any of my last few posts on provisioning Azure Data Explorer then you will probably be wondering…..

Will he write about Powershell?

Ok, I will.

Step 1: Install and configure Azure PowerShell To use PowerShell to provision Azure Data Explorer, you first need to install the Azure PowerShell module. You can install it using the following command:

Install-Module -Name Az -AllowClobber -Scope CurrentUser

Once the module is installed, you need to log in to Azure using the Connect-AzAccount command. This command will prompt you to enter your Azure credentials to authenticate with the Azure portal.

Step 2: Create an Azure Data Explorer cluster To create an ADX cluster, you can use the New-AzKustoCluster cmdlet.

Here’s an example command that creates an ADX cluster named “myadxcluster” in the “East US” region with a “D13_v2” SKU and two nodes:

New-AzKustoCluster -ResourceGroupName myResourceGroup -Name myadxcluster -Location EastUS -SkuName D13_v2 -Capacity 2

This command will create an ADX cluster with the specified name, location, SKU, and node capacity. You can customize these settings to fit your needs.

Step 3: Create an Azure Data Explorer database After creating an ADX cluster, you can create a database within the cluster using the New-AzKustoDatabase cmdlet. Here’s an example command that creates a database named “myadxdatabase” within the “myadxcluster” cluster:

New-AzKustoDatabase -ClusterName myadxcluster -Name myadxdatabase

This command will create a new database with the specified name within the ADX cluster.

Step 4: Configure data ingestion Once you have created a database, you can configure data ingestion using the Azure Data Explorer management portal or PowerShell. To use PowerShell, you can create a data ingestion rule using the New-AzKustoDataIngestionMapping cmdlet.

Here’s an example command that creates a data ingestion rule for a CSV file – we will use a file that Microsoft has provided for learning KQL and also Azure Data Explorer ( https://kustosamples.blob.core.windows.net/samplefiles/StormEvents.csv ):

$mapping = @"

New-AzKustoDataIngestionMapping -ClusterName myadxcluster -DatabaseName myadxdatabase -Name mydataingestionrule -Format csv -IgnoreFirstRecord $true -FlushImmediately $true -Mapping $mapping -DataSource @"

This command will create a data ingestion rule named “mydataingestionrule” for a CSV file named “StormEvents.csv” within the specified ADX cluster and database. The data ingestion rule specifies the file format, data mapping, and ingestion behavior.

Step 5: Verify your deployment.
Once you have completed the above steps, you can verify your Azure Data Explorer deployment by running queries and analyzing data in the ADX cluster. You can use tools like Azure Data Studio, which provides a graphical user interface for querying and analyzing data in ADX.

Using Powershell is fairly easy – personally I prefer terraform – but that’s only because I am a fully cloud person on all the clouds…

But that could be another blog post



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s