README.rst

Kqlmagic: Microsoft Azure Monitor magic extension to Jupyter notebook

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).

Example

Install latest version of package
In [1]: !pip install Kqlmagic --no-cache-dir --upgrade

Add Kqlmagic to notebook magics
In [2]: %reload_ext Kqlmagic

Connect to database at cluster
In [3]: %kql kusto://code;cluster='help';database='Samples'

Query database@cluster and render result set to a pie chart
In [4]: %kql Samples@help StormEvents | summarize count() by State | sort by count_ | limit 10 | render piechart title='my apple pie'

Get Started Notebooks

• Get Started with Kqlmagic for Kusto notebook.
• Get Started with Kqlmagic for Application Insights notebook.
• Get Started with Kqlmagic for Log Analytics notebook.
• Parametrize your Kqlmagic query with Python notebook.
• Choose colors palette for your Kqlmagic query chart result notebook.

Links

• How to install the package.
• How to install the package on a Secure Access Workstation (SAW).
• How to load the magic extension.
• GitHub Repository.