Tengri Data Platform Tengri Docs
Architecture Advantages Contacts
    • Tengri Documentation
    • Architecture
      • Ideology of use
      • Compute & Storage partitioning
      • Storage
      • Calculation
      • PostgreSQL dialect and protocols
      • Developed system of differentiation of rights
    • Test results
      • TPC-H, Comparison with Greenplum
      • TPC-DS
    • Manual
      • Computing pools
      • User and rights management
        • User operations
        • Role operations
        • Privilege operations
      • Data Description (DDL)
        • Operations with tables
        • Operations with schemes
        • Operations with views
      • Data query syntax
        • SELECT
        • WITH
        • FROM
        • JOIN
        • UNION
        • WHERE
        • CASE
        • GROUP BY
        • HAVING
        • QUALIFY
        • ORDER BY
        • LIMIT
        • OFFSET
        • LIKE
        • ILIKE
        • SIMILAR TO
        • AS
        • DELETE
        • UPDATE
        • 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
    • Administrator’s Manual
    • Scenarios
      • Initial system setup
      • Data loading
      • Automating data loading from multiple files
      • Accessing Iceberg storage directly using Python
      • Analytical scenarios
        • Analysing data from Instagram* posts
        • Analysing geodata from sports trackers
        • Analysing texts on the example of FineWeb dataset
    • Alphabetical Index
  • Tengri Documentation
  • Manual
Download to PDF
EN
RU

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

    • Delete 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

  • CASE

  • GROUP BY

  • HAVING

  • QUALIFY

  • ORDER BY

  • LIMIT

  • OFFSET

  • LIKE

  • ILIKE

  • SIMILAR TO

  • AS

  • DELETE

  • UPDATE

  • 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
Postgres Pro
VK
Youtube

© Postgres Pro
Legal Information
Tengri Data Platform is included in the Russian software registry.
Entry No. 31091 was made in the register on the basis of an order from the Ministry of Digital Development, Communications and Mass Media of the Russian Federation dated December 10, 2025.