Manual Computing pools Create a worker pool Reset a worker pool Changing the attributes of a worker pool Set default attributes of the worker pool Display a list of all worker pools Display the current worker pool Set the current compute pool User and rights management Operations with users Create a new user Change user attributes Reset user Outputs information about the user Outputs a list of all users Operations with roles Create a new role Change role attributes Reset a role Outputs a list of all roles Set the active role Operations with privileges Grant privileges Revoke privileges Data Description (DDL) Operations with tables Create a new table Delete a table Outputs a list of all tables Operations with schemes Create a new schema Change schema attributes Deleting a schema Operations with views Create a new view Deleting a view Data query syntax SELECT WITH FROM JOIN UNION INTERSECT EXCEPT WHERE CASE GROUP BY HAVING QUALIFY ORDER BY LIMIT OFFSET BETWEEN LIKE ILIKE SIMILAR TO AS DELETE UPDATE EXPLAIN Functions Aggregate functions Numerical functions Text functions Functions for regular expressions Functions for date and time Functions for JSON Functions for binary data Functions for geodata Window functions Utilities Python module tngri functions Tengri’s own syntax Keyword cell_output Cross-language variables Data types Numeric types Text type Types for date and time JSON type Types for arrays Binary type Logical type Type for geodata TPC-DS Computing pools
