A Visual Studio Codeextension that provides the ability to run Kusto queries in Notebooks as well as plain text files.
Features
Run Kusto Queries
Graphs & Data Viewer
Code Completion
Syntax highlighting
Code refactoring
Code formatting
Kusto panel with access to Clusters, Databases, Tables, etc
Run Kusto queries in Plain text files, Notebooks or in an Interactive Window
Getting Started
Open a *.kql|*.csl file and start typing to get code completion.
Open a *.kql|*.csl file and click on the Run Query code lense
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 for a .
With notebooks, select the cluster and database from via the Kernel Picker (or Notebook: Select Notebook Kernel command).
Chat:
Configure Connection:
Interactive Window:
Notebooks:
Schema View:
Works with Jupyter Notebooks as well (when using kqlmagic)
This extension augments Jupyter Notebooks with Kusto language features, when using the Jupyter extension.
The extension will automatically detect the cluster and database from cells containing the connection information kql AzureDataExplorer://code;cluster='help';database='Samples'.
Difference between Kusto Notebooks & Jupyter Notebooks (with kqlmagic)
Kusto Notebooks, there are no additional dependencies.
Authentication against Azure is handled by VS Code.
With Jupyter Notebooks, you'll need to install Python and the kqlmagic package.
