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).
|version| |python| |license|
|downloads| |monthDownloads| |weekDownloads|
Example
--------
.. code-block:: python
Install latest version of package
In [1]: !pip install Kqlmagic --no-cache-dir --upgrade
.. code-block:: python
Add Kqlmagic to notebook magics
In [2]: %reload_ext Kqlmagic
.. code-block:: python
Connect to database at cluster
In [3]: %kql kusto://code;cluster='help';database='Samples'
.. code-block:: python
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 <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FQuickStart.ipynb>`_.
* `Get Started with Kqlmagic for Application Insights notebook <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FQuickStartAI.ipynb>`_.
* `Get Started with Kqlmagic for Log Analytics notebook <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FQuickStartLA.ipynb>`_.
* `Parametrize your Kqlmagic query with Python notebook <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FParametrizeYourQuery.ipynb>`_.
* `Choose colors palette for your Kqlmagic query chart result notebook <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FColorYourCharts.ipynb>`_.
Links
-----
* `How to install the package <https://github.com/Microsoft/jupyter-Kqlmagic#install>`_.
* `How to install the package on a Secure Access Workstation (SAW) <https://github.com/Microsoft/jupyter-Kqlmagic#Install%20on%20Secure%20Access%20Workstation%20(SAW)>`_.
* `How to load the magic extension <https://github.com/Microsoft/jupyter-Kqlmagic#load>`_.
* `GitHub Repository <https://github.com/Microsoft/jupyter-Kqlmagic/tree/master>`_.
.. |downloads| image:: https://pepy.tech/badge/kqlmagic
:target: https://pepy.tech/project/kqlmagic
.. |monthDownloads| image:: https://pepy.tech/badge/kqlmagic/month
:target: https://pepy.tech/project/kqlmagic
.. |weekDownloads| image:: https://pepy.tech/badge/kqlmagic/week
:target: https://pepy.tech/project/kqlmagic
.. |version| image:: https://img.shields.io/pypi/v/Kqlmagic.svg?style=flat-square
:target: https://pypi.org/project/Kqlmagic/
.. |python| image:: https://img.shields.io/pypi/pyversions/Kqlmagic.svg?style=flat-square
:target: https://github.com/Microsoft/jupyter-Kqlmagic/blob/master/setup.py
.. |license| image:: https://img.shields.io/pypi/l/Kqlmagic.svg?style=flat-square
:target: https://github.com/Microsoft/jupyter-Kqlmagic/blob/master/LICENSE.TXT
Raw data
{
"_id": null,
"home_page": "https://github.com/Microsoft/jupyter-Kqlmagic",
"name": "Kqlmagic",
"maintainer": "Michael Binshtock",
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": "michabin@microsoft.com",
"keywords": "database ipython jupyter jupyterlab jupyter-notebook nteract azureml query language kql adx azure-data-explorer kusto loganalytics applicationinsights aria",
"author": "Michael Binshtock",
"author_email": "michabin@microsoft.com",
"download_url": "https://files.pythonhosted.org/packages/de/58/99bf6f03350fbddbc9e61e273b141924863f11c6b79b07a78cb76ca700d4/Kqlmagic-0.1.114.post26.tar.gz",
"platform": null,
"description": "Kqlmagic: Microsoft Azure Monitor magic extension to Jupyter notebook\r\n=====================================================================\r\nEnables notebook experience, exploring Microsoft Azure Monitor data: Azure Data Explorer (Kusto),\r\nApplicationInsights, and LogAnalytics data, from Jupyter notebook (Python3 kernel), using kql (Kusto Query language).\r\n\r\n\r\n\r\n\r\n|version| |python| |license| \r\n\r\n|downloads| |monthDownloads| |weekDownloads|\r\n\r\n\r\n\r\n\r\nExample\r\n--------\r\n\r\n\r\n.. code-block:: python\r\n\r\n Install latest version of package\r\n In [1]: !pip install Kqlmagic --no-cache-dir --upgrade\r\n\r\n.. code-block:: python\r\n\r\n Add Kqlmagic to notebook magics\r\n In [2]: %reload_ext Kqlmagic\r\n\r\n.. code-block:: python\r\n\r\n Connect to database at cluster\r\n In [3]: %kql kusto://code;cluster='help';database='Samples'\r\n\r\n.. code-block:: python\r\n\r\n Query database@cluster and render result set to a pie chart\r\n In [4]: %kql Samples@help StormEvents | summarize count() by State | sort by count_ | limit 10 | render piechart title='my apple pie'\r\n\r\n\r\n\r\nGet Started Notebooks\r\n---------------------\r\n\r\n* `Get Started with Kqlmagic for Kusto notebook <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FQuickStart.ipynb>`_.\r\n\r\n* `Get Started with Kqlmagic for Application Insights notebook <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FQuickStartAI.ipynb>`_.\r\n\r\n* `Get Started with Kqlmagic for Log Analytics notebook <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FQuickStartLA.ipynb>`_.\r\n\r\n\r\n* `Parametrize your Kqlmagic query with Python notebook <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FParametrizeYourQuery.ipynb>`_.\r\n\r\n* `Choose colors palette for your Kqlmagic query chart result notebook <https://mybinder.org/v2/gh/Microsoft/jupyter-Kqlmagic/master?filepath=notebooks%2FColorYourCharts.ipynb>`_.\r\n\r\n\r\nLinks\r\n-----\r\n\r\n* `How to install the package <https://github.com/Microsoft/jupyter-Kqlmagic#install>`_.\r\n* `How to install the package on a Secure Access Workstation (SAW) <https://github.com/Microsoft/jupyter-Kqlmagic#Install%20on%20Secure%20Access%20Workstation%20(SAW)>`_.\r\n* `How to load the magic extension <https://github.com/Microsoft/jupyter-Kqlmagic#load>`_.\r\n* `GitHub Repository <https://github.com/Microsoft/jupyter-Kqlmagic/tree/master>`_.\r\n\r\n\r\n\r\n\r\n\r\n\r\n.. |downloads| image:: https://pepy.tech/badge/kqlmagic\r\n :target: https://pepy.tech/project/kqlmagic\r\n\r\n.. |monthDownloads| image:: https://pepy.tech/badge/kqlmagic/month\r\n :target: https://pepy.tech/project/kqlmagic\r\n\r\n.. |weekDownloads| image:: https://pepy.tech/badge/kqlmagic/week\r\n :target: https://pepy.tech/project/kqlmagic\r\n\r\n.. |version| image:: https://img.shields.io/pypi/v/Kqlmagic.svg?style=flat-square\r\n :target: https://pypi.org/project/Kqlmagic/\r\n\r\n.. |python| image:: https://img.shields.io/pypi/pyversions/Kqlmagic.svg?style=flat-square\r\n :target: https://github.com/Microsoft/jupyter-Kqlmagic/blob/master/setup.py\r\n\r\n.. |license| image:: https://img.shields.io/pypi/l/Kqlmagic.svg?style=flat-square\r\n :target: https://github.com/Microsoft/jupyter-Kqlmagic/blob/master/LICENSE.TXT\r\n\r\n\r\n",
"bugtrack_url": null,
"license": "MIT License",
"summary": "Kqlmagic: Microsoft Azure Monitor magic extension to Jupyter notebook",
"version": "0.1.114.post26",
"project_urls": {
"Documentation": "https://github.com/microsoft/jupyter-Kqlmagic/blob/master/README.md",
"Homepage": "https://github.com/Microsoft/jupyter-Kqlmagic",
"Source": "https://github.com/microsoft/jupyter-Kqlmagic"
},
"split_keywords": [
"database",
"ipython",
"jupyter",
"jupyterlab",
"jupyter-notebook",
"nteract",
"azureml",
"query",
"language",
"kql",
"adx",
"azure-data-explorer",
"kusto",
"loganalytics",
"applicationinsights",
"aria"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "0dc06f66e55e1ef2e28ab155c3332f44002beeff7659126a8e33c95823ec14c4",
"md5": "b3e213465f0aa73942f7ad4e7f5e8679",
"sha256": "b3e641feda63e6aceb16e695a4a718bba66d4428293a2422f94e2785bcdb0a24"
},
"downloads": -1,
"filename": "Kqlmagic-0.1.114.post26-py3-none-any.whl",
"has_sig": false,
"md5_digest": "b3e213465f0aa73942f7ad4e7f5e8679",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6",
"size": 238433,
"upload_time": "2024-09-09T19:36:26",
"upload_time_iso_8601": "2024-09-09T19:36:26.150808Z",
"url": "https://files.pythonhosted.org/packages/0d/c0/6f66e55e1ef2e28ab155c3332f44002beeff7659126a8e33c95823ec14c4/Kqlmagic-0.1.114.post26-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "de5899bf6f03350fbddbc9e61e273b141924863f11c6b79b07a78cb76ca700d4",
"md5": "43da4162312f26448d74d9002d95edcd",
"sha256": "11452ee6ca48b0d028ff630ba1033859eefc30b647f1334ddf303b5a69d7820a"
},
"downloads": -1,
"filename": "Kqlmagic-0.1.114.post26.tar.gz",
"has_sig": false,
"md5_digest": "43da4162312f26448d74d9002d95edcd",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 217691,
"upload_time": "2024-09-09T19:36:28",
"upload_time_iso_8601": "2024-09-09T19:36:28.455260Z",
"url": "https://files.pythonhosted.org/packages/de/58/99bf6f03350fbddbc9e61e273b141924863f11c6b79b07a78cb76ca700d4/Kqlmagic-0.1.114.post26.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-09 19:36:28",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "Microsoft",
"github_project": "jupyter-Kqlmagic",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "kqlmagic"
}
JSON
