/vscode-kusto

Kusto Notebooks

Primary LanguageJavaScriptMIT LicenseMIT

Kusto in Notebooks

A Visual Studio Code extension that provides the ability to run Kusto queries in Notebooks.

Features

  • Run Kusto Queries
  • Graphs & Data Viewer
  • Code Completion
  • Syntax highlighting
  • Code refactoring
  • Code formatting
  • Kusto panel with access to Clusters, Databases, Tables, etc

Getting Started

  • Create a file with extension *.knb (or use the command Create Kusto Notebook)
  • Use the command Configure Kusto Connection to configure the Kusto connection.

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.
    • You can use Python to further analyze the data.

Roadmap

  • Support for more charts
  • Support for plain text files (.csl/.kql)
  • & more...

Thanks to the contributors

Joyce Er, SteVen Batten, Peng Lyu, Tanha Kabir

License

MIT