{ "info": { "author": "Microsoft Corporation", "author_email": "yomost@microsoft.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Topic :: Software Development" ], "description": "# Introduction \n_pykusto_ is an advanced Python SDK for Azure Data Explorer (a.k.a. Kusto). \nStarted as a project in the 2019 Microsoft Hackathon.\n\n[![PyPI version](https://badge.fury.io/py/pykusto.svg)](https://badge.fury.io/py/pykusto)\n[![Downloads](https://pepy.tech/badge/pykusto)](https://pepy.tech/project/pykusto)\n\n# Getting Started\n### Installation\n```bash\npip install pykusto\n```\n\n### Usage\n```python\nfrom datetime import timedelta\nfrom pykusto.client import PyKustoClient\nfrom pykusto.query import Query\nfrom pykusto.expressions import column_generator as col\n\n# Connect to cluster with AAD device authentication\nclient = PyKustoClient('https://help.kusto.windows.net')\n\n# Show databases\nprint(client.show_databases())\n\n# Show tables in 'Samples' database\nprint(client['Samples'].show_tables())\n\n# Connect to 'StormEvents' table\ntable = client['Samples']['StormEvents']\n\n# Build query\n(\n Query(table) \n # Access columns using 'col' global variable \n .project(col.StartTime, col.EndTime, col.EventType, col.Source)\n # Specify new column name using Python keyword argument \n .extend(Duration=col.EndTime - col.StartTime)\n # Python types are implicitly converted to Kusto types\n .where(col.Duration > timedelta(hours=1))\n .take(5)\n # Output to pandas dataframe\n .to_dataframe()\n) \n```\n\n# Contributing\n\nThis project welcomes contributions and suggestions. Most contributions require you to agree to a\nContributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us\nthe rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.\n\nWhen you submit a pull request, a CLA bot will automatically determine whether you need to provide\na CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions\nprovided by the bot. You will only need to do this once across all repos using our CLA.\n\nThis project has adopted the [Microsoft Open Source Code of Conduct](https://opensource.microsoft.com/codeofconduct/).\nFor more information see the [Code of Conduct FAQ](https://opensource.microsoft.com/codeofconduct/faq/) or\ncontact [opencode@microsoft.com](mailto:opencode@microsoft.com) with any additional questions or comments.\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/Azure/pykusto", "keywords": "kusto client library query", "license": "MIT License", "maintainer": "", "maintainer_email": "", "name": "pykusto", "package_url": "https://pypi.org/project/pykusto/", "platform": "", "project_url": "https://pypi.org/project/pykusto/", "project_urls": { "Homepage": "https://github.com/Azure/pykusto" }, "release_url": "https://pypi.org/project/pykusto/0.0.4/", "requires_dist": [ "azure-kusto-data (==0.0.31)" ], "requires_python": "", "summary": "Advanced python SDK for Azure Data Explorer", "version": "0.0.4" }, "last_serial": 5802504, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "5cdb38514d0f6e43566af025d0ca61b8", "sha256": "8f97edda05c5810e901294137cec74c4589894a9945a172e586f62d5c7350385" }, "downloads": -1, "filename": "pykusto-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "5cdb38514d0f6e43566af025d0ca61b8", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 15266, "upload_time": "2019-08-05T13:31:42", "url": "https://files.pythonhosted.org/packages/d4/5c/7dcd5a4f9d6eedfc1e42104a641bb496a02d2737473693c7d541834095bb/pykusto-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1194e2941befafe6af32ff6412d1302a", "sha256": "796a4b719b5eda09d993ee53497a9ef738f9f762d3ce42b831d1fafaed1d93b6" }, "downloads": -1, "filename": "pykusto-0.0.1.tar.gz", "has_sig": false, "md5_digest": "1194e2941befafe6af32ff6412d1302a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18508, "upload_time": "2019-08-05T13:31:44", "url": "https://files.pythonhosted.org/packages/bc/4d/a953837922ed948e755c4fdcc500a6c785d7657da37fe8db4c9d72c6b20c/pykusto-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "0d2f956c4b751622548c2de046b2ecf9", "sha256": "ffbda73a85462b8fd832ba74735c568e4f752e224616e799beab36f3f457e3f2" }, "downloads": -1, "filename": "pykusto-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "0d2f956c4b751622548c2de046b2ecf9", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 16255, "upload_time": "2019-08-05T13:53:16", "url": "https://files.pythonhosted.org/packages/e5/c8/2f5116430d0a7bc66402bfb99b555ffed8993903d8508f9bdb4b1da0d92e/pykusto-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "71e7c002a78af91c4079b90ce006e45c", "sha256": "4a2b0345cf4002427923d8ad1c39896124283e20401b7cb8ae7f9d38a17a68ba" }, "downloads": -1, "filename": "pykusto-0.0.2.tar.gz", "has_sig": false, "md5_digest": "71e7c002a78af91c4079b90ce006e45c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 19729, "upload_time": "2019-08-05T13:53:18", "url": "https://files.pythonhosted.org/packages/52/b6/1c2689054e30c65a2304198f948b2ef7193d2e7d91dac0f0e7ac56a73bb9/pykusto-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "ec9ac80e3004a9ac00db72805bd919e2", "sha256": "840cbf274fc241d90c6502c1196db2e6c4a1f33d258bcaecbb7435cd2b7c6b25" }, "downloads": -1, "filename": "pykusto-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "ec9ac80e3004a9ac00db72805bd919e2", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 16133, "upload_time": "2019-08-07T08:58:38", "url": "https://files.pythonhosted.org/packages/19/66/a7b8ec373e50f8c4dc1048856f29aa0bed1a4b9bf04855e2eb145a4ae794/pykusto-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a46fb91dfd603479d5b91c00cfa57dcc", "sha256": "73e7f6012c108c0c5aae3738e30acabb205f5736fcb7ab7e54ad9701441f49a4" }, "downloads": -1, "filename": "pykusto-0.0.3.tar.gz", "has_sig": false, "md5_digest": "a46fb91dfd603479d5b91c00cfa57dcc", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 19472, "upload_time": "2019-08-07T08:58:39", "url": "https://files.pythonhosted.org/packages/7d/e8/267a00adff93e842b0c63204807e0665b1b1126132d02d4b5e4b09c899f6/pykusto-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "ae42977c4de7d3d35aa418895e89ff9a", "sha256": "a9c3f8af8246c19ad6850b72159f5586a5c0e2f5f10f50ee91140bc3c67e5c6e" }, "downloads": -1, "filename": "pykusto-0.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "ae42977c4de7d3d35aa418895e89ff9a", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 16793, "upload_time": "2019-09-09T08:46:42", "url": "https://files.pythonhosted.org/packages/52/c6/33ba06e46427762572c2f034b350fb029c37a77fc3310961ebe6c8831056/pykusto-0.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7cbd83f0260b5987918601763756db1c", "sha256": "01dd1f89db11661209270ad4eb708c75fb6902b9e7968eb89f10cb6d4af6e703" }, "downloads": -1, "filename": "pykusto-0.0.4.tar.gz", "has_sig": false, "md5_digest": "7cbd83f0260b5987918601763756db1c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 20988, "upload_time": "2019-09-09T08:46:44", "url": "https://files.pythonhosted.org/packages/60/cd/ec8a96ec001d6ba508c1b9657e0df519739f087c8634846e02b8f6433e9b/pykusto-0.0.4.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "ae42977c4de7d3d35aa418895e89ff9a", "sha256": "a9c3f8af8246c19ad6850b72159f5586a5c0e2f5f10f50ee91140bc3c67e5c6e" }, "downloads": -1, "filename": "pykusto-0.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "ae42977c4de7d3d35aa418895e89ff9a", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 16793, "upload_time": "2019-09-09T08:46:42", "url": "https://files.pythonhosted.org/packages/52/c6/33ba06e46427762572c2f034b350fb029c37a77fc3310961ebe6c8831056/pykusto-0.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7cbd83f0260b5987918601763756db1c", "sha256": "01dd1f89db11661209270ad4eb708c75fb6902b9e7968eb89f10cb6d4af6e703" }, "downloads": -1, "filename": "pykusto-0.0.4.tar.gz", "has_sig": false, "md5_digest": "7cbd83f0260b5987918601763756db1c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 20988, "upload_time": "2019-09-09T08:46:44", "url": "https://files.pythonhosted.org/packages/60/cd/ec8a96ec001d6ba508c1b9657e0df519739f087c8634846e02b8f6433e9b/pykusto-0.0.4.tar.gz" } ] }