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": "KqlmagicCustom",
"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/ed/6c/f40764340e228a2a08e3b621af31cec83674b3da4c5b3b0f19ced53ee506/KqlmagicCustom-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 (Custom Dependencies)",
"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": "0f4945a20d050d1b4410a562b528d5fda3f3d35b4c481f90a6ddc64b95ed39b2",
"md5": "d6229724a5d8b749fe8cb63a4b0cd4d0",
"sha256": "049d801b0426916c23e55e46da786e5f61ea50e15b9513f42d89fe45cc4b90f3"
},
"downloads": -1,
"filename": "KqlmagicCustom-0.1.114.post26-py3-none-any.whl",
"has_sig": false,
"md5_digest": "d6229724a5d8b749fe8cb63a4b0cd4d0",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6",
"size": 239696,
"upload_time": "2024-09-09T19:36:37",
"upload_time_iso_8601": "2024-09-09T19:36:37.874555Z",
"url": "https://files.pythonhosted.org/packages/0f/49/45a20d050d1b4410a562b528d5fda3f3d35b4c481f90a6ddc64b95ed39b2/KqlmagicCustom-0.1.114.post26-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "ed6cf40764340e228a2a08e3b621af31cec83674b3da4c5b3b0f19ced53ee506",
"md5": "6cee55f0b581ab78eb4b3dbb8a12947a",
"sha256": "d740d867f46e4d03fd48d3a9f083be87e33022eb9f91ca1ca5613a51b0118862"
},
"downloads": -1,
"filename": "KqlmagicCustom-0.1.114.post26.tar.gz",
"has_sig": false,
"md5_digest": "6cee55f0b581ab78eb4b3dbb8a12947a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 218439,
"upload_time": "2024-09-09T19:36:39",
"upload_time_iso_8601": "2024-09-09T19:36:39.947856Z",
"url": "https://files.pythonhosted.org/packages/ed/6c/f40764340e228a2a08e3b621af31cec83674b3da4c5b3b0f19ced53ee506/KqlmagicCustom-0.1.114.post26.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-09 19:36:39",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "Microsoft",
"github_project": "jupyter-Kqlmagic",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "kqlmagiccustom"
}
JSON
