Skip to content
Extension (Magic) to Jupyter notebook and Jupyter lab, that enable notebook experience working with Kusto, ApplicationInsights, and LogAnalytics data.
Python Jupyter Notebook HTML Other
Branch: master
Clone or download
Type Name Latest commit message Commit time
Failed to load latest commit information.
.vs fix missing module dependency in; created… Mar 24, 2019
.vscode Added to submit override_vars parameter; + PR55 Feb 16, 2020
azure add to submit override_options parameter; update ParameterizeYourQuer… Feb 17, 2020
binder add to submit override_options parameter; update ParameterizeYourQuer… Feb 17, 2020
data/images Version 0.1.14 Aug 7, 2018
notebooks add to submit override_options parameter; update ParameterizeYourQuer… Feb 17, 2020
.gitignore fix tests import; add to setup QtPy and PyQt5 Feb 17, 2020
.markdownlint.json Added copyright file header to all files, version 0.1.34 Sep 19, 2018 support alt schema names; simplify code; improve connection inheritan… Oct 15, 2018
FAQ.html Adde request tags; FAQ; improved version management to support dev, p… Oct 3, 2019 Version 0.1.108, Added Help for Logging and bug fixes Dec 11, 2019
HISTORY.rst Version 102 - Added option: 'show_query' (abbreviation 'sq', default … Aug 27, 2019
KqlMagic.pyproj restructure local files Oct 18, 2018
KqlMagic.sln Version 0.1.14 Aug 7, 2018
LICENSE.TXT bump version 0.1.31 Sep 19, 2018
NEWS.txt updated README, and setup Oct 17, 2018
NOTICE.TXT Version 0.1.14 Aug 7, 2018 Fix README mentioned min required Python version Aug 8, 2019
README.rst version 01.88, added --schema command Jan 16, 2019
TODO.txt fixed #14, adjusted setup to Azure notebooks, added dev dependencies … Jun 9, 2019 bump version 0.1.31 Sep 19, 2018 changes state from 1-alpha to 3-beta; published in PyPI; modified not… Oct 16, 2018
dev_requirements.txt support partial result, add command concept, added commands, 0.1.66 Oct 25, 2018 changes state from 1-alpha to 3-beta; published in PyPI; modified not… Oct 16, 2018
run_pytest.bat adding another test in basics Jun 3, 2019
run_upgrade.bat added run_upgrade.bat; enhanced run_tests.bat Dec 24, 2018 setup fix for tests, 0.1.108.post4 Feb 17, 2020

Kqlmagic: Microsoft Azure Monitor magic extension to Jupyter notebook.

PyPi Version Python Versions License

PyPI link:, PePy download information:

Downloads Downloads Downloads

Kqlmagic magic extension enables notebook experience, exploring Microsoft Azure Monitor data: Azure Data Explorer (Kusto), ApplicationInsights, and LogAnalytics data, from Jupyter notebook (Python3 kernel), using kql (Kusto Query language).


Option 1: Via PyPi

To install via the Python Package Index (PyPI), type:

pip install Kqlmagic

Option 2: Source Via Git

To get the source code of the SDK via git just type:

git clone git://
cd ./jupyter-Kqlmagic
python install

Option 3: Source Zip

Download a zip of the code via GitHub or PyPI. Then follow the same instructions as in option 2.

Minimum Requirements

  • Python 3.6+
  • See for dependencies


To load the Kqlmagic extension, run in notebook cell:

In [ ]: %reload_ext Kqlmagic

Authentication methods:

  • AAD Username/password - Provide your AAD username and password.
  • AAD application - Provide your AAD tenant ID, AAD app ID and app secret.
  • AAD code - Provide only your AAD username, and authenticate yourself using a code, generated by ADAL.
  • certificate - Provide your AAD tenant ID, AAD app ID, certificate and certificate-thumbprint (supported only with Azure Data Explorer)
  • appid/appkey - Provide you application insight appid, and appkey (supported only with Application Insights)

Get Started Notebooks:

Need Support?

  • Have a feature request for Kqlmagic? Please post it on User Voice to help us prioritize
  • Have a technical question? Ask on Stack Overflow with tag "Kqlmagic"
  • Need Support? Every customer with an active Azure subscription has access to support with guaranteed response time. Consider submitting a ticket and get assistance from Microsoft support team
  • Found a bug? Please help us fix it by thoroughly documenting it and filing an issue.


We gladly accept community contributions.

  • Issues: Please report bugs using the Issues section of GitHub
  • Forums: Interact with the development teams on StackOverflow or the Microsoft Azure Forums
  • Source Code Contributions: If you would like to become an active contributor to this project please follow the instructions provided in

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact with any additional questions or comments.

For general suggestions about Microsoft Azure please use our UserVoice forum.

You can’t perform that action at this time.