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 User operations Create a new user Change user attributes Reset user Display information about the user Display a list of all users Role operations Create a new role Change role attributes Reset a role Display a list of all roles Set the active role Grant attributes to roles Privilege operations Grant privileges Revoke privileges Data Description (DDL) Operations with tables Create a new table Deleting a table Display 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 WHERE GROUP BY HAVING QUALIFY ORDER BY LIMIT OFFSET LIKE ILIKE SIMILAR TO AS 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 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