Azure Data Explorer (Kusto) using native Kusto Query Language (KQL) for fast, exploratory telemetry and log analytics.
Known Incompatibilities
SQLAlchemy 2.0
setup.py on the sqlalchemy-kusto main branch hard-pins sqlalchemy==1.4.*; no SQLAlchemy 2.0 work has started.
Last confirmed: 2026-07-28
Installation
Required packages: sqlalchemy-kusto
Connection String
kustokql+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}| Parameter | Description |
|---|---|
| cluster | Azure Data Explorer cluster name |
| database | Database name |
| client_id | Azure AD application (client) ID |
| client_secret | Azure AD application secret |
| tenant_id | Azure AD tenant ID |
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 40/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR