Skip to main content

Kusto Data Client

Project description

from azure.kusto.data import KustoClient, KustoConnectionStringBuilder

cluster = "<insert here your cluster name>"
client_id = "<insert here your AAD application id>"
client_secret = "<insert here your AAD application key>"
authority_id = "<insert here your AAD tenant id>"

kcsb = KustoConnectionStringBuilder.with_aad_application_key_authentication(cluster, client_id, client_secret, authority_id)
# It is a good practice to re-use the KustoClient instance, as it maintains a pool of connections to the Kusto service.
# This sample shows how to create a client and close it in the same scope, for demonstration purposes.
with KustoClient(kcsb) as client:
    db = "Samples"
    query = "StormEvents | take 10"

    response = client.execute(db, query)
    for row in response.primary_results[0]:
        print(row[0], " ", row["EventType"])

Kusto Python Client Library provides the capability to query Kusto clusters using Python. It is Python 3.x compatible and supports all data types through familiar Python DB API interface.

It’s possible to use the library, for instance, from Jupyter Notebooks. which are attached to Spark clusters, including, but not exclusively, Azure Databricks. instances.

Async Client

Kusto now provides an asynchronous client for queries.

To use the client, first install the package with the “aio” extra:

pip install azure-kusto-data[aio]

The async client uses exact same interface as the regular client, except that it lives in the azure.kusto.data.aio namespace, and it returns Futures you will need to await its

from azure.kusto.data import KustoConnectionStringBuilder
from azure.kusto.data.aio import KustoClient

cluster = "<insert here your cluster name>"
client_id = "<insert here your AAD application id>"
client_secret = "<insert here your AAD application key>"
authority_id = "<insert here your AAD tenant id>"


async def sample():
    kcsb = KustoConnectionStringBuilder.with_aad_application_key_authentication(cluster, client_id, client_secret, authority_id)
    async with KustoClient(kcsb) as client:
        db = "Samples"
        query = "StormEvents | take 10"

        response = await client.execute(db, query)
        for row in response.primary_results[0]:
            print(row[0], " ", row["EventType"])

Project details


Release history Release notifications | RSS feed

Download files

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

Source Distribution

azure-kusto-data-4.1.2.tar.gz (42.3 kB view details)

Uploaded Source

Built Distribution

azure_kusto_data-4.1.2-py2.py3-none-any.whl (52.9 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file azure-kusto-data-4.1.2.tar.gz.

File metadata

  • Download URL: azure-kusto-data-4.1.2.tar.gz
  • Upload date:
  • Size: 42.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.7.15

File hashes

Hashes for azure-kusto-data-4.1.2.tar.gz
Algorithm Hash digest
SHA256 e7b5e828ec9a282d3d91976b53b9b1f2c4e34ae3441d22235fb40e04825df6a8
MD5 26de665f94fbce77fb1814c740a86cac
BLAKE2b-256 5b02c57280f6f85dc200a9ade3eaa149c666475974c7bf85845fef0295e53952

See more details on using hashes here.

File details

Details for the file azure_kusto_data-4.1.2-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for azure_kusto_data-4.1.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 e573cee451df5c2a3f05344d5801b0d11b990c8f6a65839c6ff0972d269a3e83
MD5 5d384fb644f4dabee3f70237239d5bf3
BLAKE2b-256 d7410e44fbc8b110919a75f047cc2e033fd5c2a274c6746cbf2cd1194e6482fe

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