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/93/9d/8fcdcc8b51aa99736a204c28fc971b333e788e02d2b3abf44f390fc001d0/Kqlmagic-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",
"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": "090ff3ee491be6b871465967ea144ca3c1b2d22ddfff5d7d5e150eba5cb71d74",
"md5": "eb42a08de713e6e985e2c40a5092f67b",
"sha256": "a327e1421039c2090e85dfe0423a3a589e8b596f6602751079264b94ccb1be96"
},
"downloads": -1,
"filename": "Kqlmagic-0.1.114.post24-py3-none-any.whl",
"has_sig": false,
"md5_digest": "eb42a08de713e6e985e2c40a5092f67b",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6",
"size": 237706,
"upload_time": "2024-04-18T10:37:48",
"upload_time_iso_8601": "2024-04-18T10:37:48.850659Z",
"url": "https://files.pythonhosted.org/packages/09/0f/f3ee491be6b871465967ea144ca3c1b2d22ddfff5d7d5e150eba5cb71d74/Kqlmagic-0.1.114.post24-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "939d8fcdcc8b51aa99736a204c28fc971b333e788e02d2b3abf44f390fc001d0",
"md5": "51f306a106823453b650c98e93ddb74a",
"sha256": "de585a62ba2f4e079dedfe0a818d4b7dc7f8c4af2981fe0dcfb281122899c175"
},
"downloads": -1,
"filename": "Kqlmagic-0.1.114.post24.tar.gz",
"has_sig": false,
"md5_digest": "51f306a106823453b650c98e93ddb74a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 216808,
"upload_time": "2024-04-18T10:37:51",
"upload_time_iso_8601": "2024-04-18T10:37:51.614489Z",
"url": "https://files.pythonhosted.org/packages/93/9d/8fcdcc8b51aa99736a204c28fc971b333e788e02d2b3abf44f390fc001d0/Kqlmagic-0.1.114.post24.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-04-18 10:37:51",
"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
