Skip to main content

Microsoft Kusto access via IPython

Project description

# ipython-kusto - Run Microsoft Kusto queries in IPython notebooks

This extension borrows extensively from Catherine Devlin’s ipython-sql extension. https://github.com/catherinedevlin/ipython-sql

It provides two magics:

  • %kqlset - a line magic to set the default cluster and database

  • %kql/%%kql - a line or cell magic to execute Kusto Query Language queries and return the results as a Pandas dataframe. The dataframe will be assigned to a variable ‘kqlresult’ (can be overridden with –set argument)

If you run either of these followed by a ‘?’ you will get additional help.

When running a query, you may be redirected to a browser page to sign in if a token is needed.

See the example notebook in the examples/ directory for more details.

0.0.5

Added a flag to inhibit variable substitution in case that is problematic in some query.

0.0.4

Better error reporting. Use –error to get the old raw error.

0.0.3

Updated URL to point to Github repo.

0.0.2

A typo crept in to 0.0.1 release; that has been fixed. Added a –quiet option to not display the dataframe.

0.01. Initial release

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

ipython-kusto-0.0.5.tar.gz (5.0 kB view details)

Uploaded Source

Built Distribution

ipython_kusto-0.0.5-py3.8.egg (8.9 kB view details)

Uploaded Source

File details

Details for the file ipython-kusto-0.0.5.tar.gz.

File metadata

  • Download URL: ipython-kusto-0.0.5.tar.gz
  • Upload date:
  • Size: 5.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/47.1.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for ipython-kusto-0.0.5.tar.gz
Algorithm Hash digest
SHA256 848f13cd707b3ad1ec3289c3cf594a9245f0fd3c5c0dca040ceb3a5af777540e
MD5 6ad74f35416328050d3f45ea60ecb4ce
BLAKE2b-256 bd90c1c3e46e36e40882b511d71cf5913b324e00bea93c9d2285f0dfb5fa60b6

See more details on using hashes here.

File details

Details for the file ipython_kusto-0.0.5-py3.8.egg.

File metadata

  • Download URL: ipython_kusto-0.0.5-py3.8.egg
  • Upload date:
  • Size: 8.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/47.1.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for ipython_kusto-0.0.5-py3.8.egg
Algorithm Hash digest
SHA256 40ebd2d65359b4d880f4d0c96df53020205b17abd8936af5486a5d12e60e4a6b
MD5 39b7a1ab2c7e9bd86e077f8579ec846b
BLAKE2b-256 91a3db3b4fa99f73ff309ff44b60e10b248f2339878c453622cc6479cf7dc478

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page