Azure Data Explorer

https://azure.microsoft.com/en-us/products/data-explorer/

Azure Data Explorer (Kusto) is a fast, fully managed data analytics service from Microsoft Azure. Query data using SQL or native KQL syntax.

Installation

Required packages: sqlalchemy-kusto

Drivers

SQL Interface (Recommended)Recommended

KQL (Kusto Query Language)

PyPI Package: sqlalchemy-kusto

kustosql+https://{cluster}.kusto.windows.net/{database}?msi=False&azure_ad_client_id={client_id}&azure_ad_client_secret={client_secret}&azure_ad_tenant_id={tenant_id}

Use familiar SQL syntax to query Azure Data Explorer.

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Help improve this documentation by editing the engine spec:

Edit kusto.py