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/9c/1d/fb7ca9a19767cfc4310bdfe17172595e9651dfb121d655ada210eece98d4/KqlmagicCustom-0.1.114.post24.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.post24",
"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": "435b94a39dfe26d027e9b0981ed0a2d1852313c1f1685ceba4cff8ec95f1c192",
"md5": "6dd11c94d9b1bb98f309971159f21cd7",
"sha256": "4a185011f01b74b125f5ceb5ca1f21ef82bb3e9f5eaf986e35e44bd006308069"
},
"downloads": -1,
"filename": "KqlmagicCustom-0.1.114.post24-py3-none-any.whl",
"has_sig": false,
"md5_digest": "6dd11c94d9b1bb98f309971159f21cd7",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6",
"size": 238952,
"upload_time": "2024-04-18T10:38:01",
"upload_time_iso_8601": "2024-04-18T10:38:01.865380Z",
"url": "https://files.pythonhosted.org/packages/43/5b/94a39dfe26d027e9b0981ed0a2d1852313c1f1685ceba4cff8ec95f1c192/KqlmagicCustom-0.1.114.post24-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "9c1dfb7ca9a19767cfc4310bdfe17172595e9651dfb121d655ada210eece98d4",
"md5": "5c53f770eca60e66a37de1d07702bb6b",
"sha256": "d0370495473dc5f36e075b6191028808b056ef760c8b22d436268a25cf7963e7"
},
"downloads": -1,
"filename": "KqlmagicCustom-0.1.114.post24.tar.gz",
"has_sig": false,
"md5_digest": "5c53f770eca60e66a37de1d07702bb6b",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 217501,
"upload_time": "2024-04-18T10:38:04",
"upload_time_iso_8601": "2024-04-18T10:38:04.603561Z",
"url": "https://files.pythonhosted.org/packages/9c/1d/fb7ca9a19767cfc4310bdfe17172595e9651dfb121d655ada210eece98d4/KqlmagicCustom-0.1.114.post24.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-04-18 10:38:04",
"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
