Kusto in Notebooks & Interactive Window

October 9, 2025 · View on GitHub

A Visual Studio Code extension that provides the ability to run Kusto queries in Notebooks as well as plain text files.

Features

The extension attempts authentication methods in the following order, proceeding to the next if one fails:

Azure CLI Authentication
- Uses existing Azure CLI credentials
- Requires az login to be completed
VS Code Azure Authentication
- Uses VS Code's built-in Azure authentication
- No additional tools required
Device Code Authentication
- Interactive device code flow
- Enter code at microsoft.com/devicelogin
Access Token Authentication
- Manual access token input
- Useful for CI/CD scenarios

The authentication process will try each method in sequence until successful authentication is achieved.

Note: For local development, Azure CLI or VS Code authentication is recommended.

Open a *.kql|*.csl file and start typing to get code completion
Open a *.kql|*.csl file and click on the Run Query code lens
Open a *.kql|*.csl file as a notebook
Create a file with extension *.knb (or use the command Create Kusto Notebook)
With text file (*.kql, *.csl) use the command Configure Kusto Connection to configure the Kusto connection
With notebooks, select the cluster and database from via the Kernel Picker (or Notebook: Select Notebook Kernel command)

Chat Demo

This extension works with Jupyter Notebooks when using kqlmagic:

Augments Jupyter Notebooks with Kusto language features when using the Jupyter extension
Automatically detects cluster and database from cells containing connection information kql AzureDataExplorer://code;cluster='help';database='Samples'

Kusto Notebooks:

Jupyter Notebooks with kqlmagic:

MIT