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