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
Query limit settings
- set notruncation etc.
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
Other functions and operators
- [start|end]of[day|week|month|year]
- between
- typecasting: real(), long(), datetime() etc.
- math functions: log, sin, cos etc.
- string functions: strlen etc.
- null
- date functions: getyear, getmonth etc.
- case / iff
- hash
- welch_test
- array_ functions
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
kusto-tool-0.4.2.tar.gz
(24.5 kB
view hashes)
Built Distribution
Close
Hashes for kusto_tool-0.4.2-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4074430456521254389f31cb3eefe38c2e45c15a4a5eaee7541447f9fc52013c |
|
MD5 | 4248582350ccbbbfdcb5679f05fa0d19 |
|
BLAKE2b-256 | c1bfe1c70ea6c8950c9e1350d37e539d0697d90726c10072073ed5f4b7ab2c57 |