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.3.0.tar.gz
(24.3 kB
view hashes)
Built Distribution
Close
Hashes for kusto_tool-0.3.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a37d85a25cd6df49e54677a0de88dd3fbeec341c89e75e1cddfdc41a876a22df |
|
MD5 | 00ed5cdaded0b412fcdaf7cbd9666319 |
|
BLAKE2b-256 | 39f6dc35b650a6e076b502812f8925c66b0b1ab552e262e77592c90858cf1a4b |