A high-level API for querying Kusto.
Project description
kusto-tool
A high-level Python library and CLI to make it easier to use Azure Data Explorer (aka Kusto), especially for data scientists.
Experimental, work-in-progress, unstable API.
TODO
Database API
Table management
- .set-or-append table
- .set-or-replace table
- .drop table
- .append table
- .create table
- .create-merge table
Function management
- .create-or-alter function
- .drop function
Policy management
- retention policy
- sharding policy
Access management
- .show [table|database] principals
- .add [table|database] [users|admins]
Query expression API
- project
- where
- distinct
- summarize
- join
- parenthesize or/and expressions
- extend
- order by, sort
- asc, desc
- evaluate
- take, limit
- mv-expand
- Inspect columns from table by querying
- sample
- sample-distinct
- mv-apply
- datatable
- facet
- find
- fork
- getschema
- invoke
- lookup
- parse
- partition
- pivot
- range
- search
- serialize
- top, top-hitters
- Kusto prefix function translator class
- special types (datetime, timespan, dynamic)
- nice error messages when column not found in table etc.
Agg functions
- sumif
- countif
- dcountif
- binary_all_and
- binary_all_or
- binary_all_xor
- make_bag / make_set / make_list
- arg_max, arg_min, take_any, take_anyif
- avgif
- hll, hll_merge
- max, maxif, min, minif
- percentiles, percentiles_array, percentilesw
- stdev, stdevif
- tdigest, tdigest_merge
- variance, variancep, varianceif
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
Close
Hashes for kusto_tool-0.1.1-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d17af635d1473e45811e9013387c173a77617b9b9682f7ce60ffbe7b31f75da2 |
|
MD5 | 4675c9ab5f6557b84dbad193ecf93364 |
|
BLAKE2b-256 | 4f51d741c108d3a18af8f810cb169c1076f6b271e9f94b31fd380e6c4541e17c |