Cheet-Sheet

Commands

Command	Description	Example Usage
where	searches for the word we specify in the field we specify in the table we specify	Table Name | where {field name} == '{what we are searching for}'
take	takes the specified amount of rows and displays them	Table Name | take 10
limit	Same as 'take' command
contains
has
startswith
endswith
distinct
count
sort
order	Same as 'sort' command
project
project-reorder

Operators

Operator	Desc	Example
==
!=
=~
>
>=
<
<=
and
or

renaming fields