Alphabetical Index

!=

Operator

Alias for operator <>.

%

Operator

Returns the remainder of the left argument divided by the right argument.

*

Operator

Multiplies the arguments.

+

Operator

Adds the right argument to the left argument.

-

Operator

Subtracts the right argument from the left argument.

/

Operator

Divides the left argument by the right argument.

::

Operator

Casts the data type to the specified data type.

<

Operator

Checks that the left argument is less than the right argument.

<>

Operator

Checks that the left argument is not equal to the right argument.

=

Operator

Checks that the left argument is equal to the right argument.

==

Operator

Alias for operator =.

>

Operator

Checks that the left argument is greater than the right argument.

>=

Operator

Checks that the left argument is greater than or equal to the right argument.

<=

Operator

Checks that the left argument is less than or equal to the right argument.

^

Operator

Elevates the left argument to the degree given by the right argument.

abs

Function

Calculates the modulus of a number.

acos

Function

Calculates the arccosine of a number.

acosh

Function

Calculates the hyperbolic arccosine of a number.

add

Function

Adds numbers.

aggregate

Function

Alias for function list_aggregate.

ALTER <USER | ROLE> SET API TOKEN MAX DURATION

SQL expression

Alter token max duration.

ALTER API TOKEN

SQL expression

Alter token.

ALTER ROLE

SQL expression

Change role attributes.

ALTER SCHEMA

SQL expression

Change schema attributes.

ALTER TABLE

SQL expression

Change table attributes.

ALTER USER

SQL expression

Change user attributes.

ALTER WORKER POOL

SQL expression

Changing the attributes of a worker pool.

ALTER WORKER POOL SET DEFAULT

SQL expression

Set default attributes of the worker pool.

any_value

Function

Returns the first value from argument other than NULL.

approx_count_distinct

Function

Calculates the approximate number of unique values.

approx_quantile

Function

Calculates an approximate quantile.

approx_top_k

Function

Calculates an approximate list of the k most frequently occurring values.

arg_max

Function

Finds the row with the maximum value in one column and returns the value of the other column in that row.

arg_max_null

Function

Finds the row with the maximum value in one column and returns the value of the other column in that row (even if it is empty).

arg_min

Function

Finds the row with the minimum value in one column and returns the value of the other column in that row.

arg_min_null

Function

Finds the row with the minimum value in one column and returns the value of the other column in that row (even if it is empty).

argmax

Function

Alias for function arg_max.

argmin

Function

Alias for function arg_min.

array_agg

Function

Returns a list containing all the values of a column.

array_aggr

Function

Alias for function list_aggregate.

array_aggregate

Function

Alias for function list_aggregate.

array_cat

Function

Alias for function [list_cat].

array_concat

Function

Alias for function [list_cat].

array_extract

Function

Extracts a character from the specified string or an item from the specified list.

array_grade_up

Function

Alias for function list_grade_up.

array_has_all

Function

Alias for function list_has_all.

array_has_any

Function

Alias for function list_has_any.

array_indexof

Function

Alias for function list_position.

array_length

Function

Returns the length of the list.

array_position

Function

Alias for function list_position.

array_resize

Function

Alias for function list_resize.

array_reverse_sort

Function

Alias for function list_reverse_sort.

array_slice

Function

Extracts a substring from the specified string or a list from the specified list.

array_sort

Function

Alias for function list_sort.

array_to_json

Function

Alias for function to_json.

array_unique

Function

Alias for function list_unique.

array_where

Function

Alias for function list_where.

array_zip

Function

Alias for function list_zip.

AS

SQL expression

SELECT query element.

ascii

Function

Alias for function unicode.

asin

Function

Calculates the arcsine of a number.

asinh

Function

Calculates the hyperbolic arcsine of a number.

atan

Function

Calculates the arctangent of a number.

atan2

Function

Calculates the arctangent from the coordinates.

atanh

Function

Calculates the hyperbolic arctangent of a number.

avg

Function

Calculates the average of all non-empty values in a group.

bar

Function

Draws a bar at the height of the string.

base64

Function

Alias for function to_base64.

BETWEEN

Operator

Checks that the first argument lies in the interval between the second and third arguments inclusive.

BIGINT

Data type

Integers.

BIGINT[]

Data type

Arrays of integers.

bin

Function

Converts each character of a string to its binary representation.

bit_and

Function

Returns the bitwise AND of all bits in the group.

bit_count

Function

Returns the number of bits set in the binary representation of a number.

bit_length

Function

Returns the number of bits the string occupies in memory.

bit_or

Function

Returns a bitwise OR for all bits in the group.

bit_xor

Function

Returns the bitwise XOR for all bits in the group.

bitstring_agg

Function

Returns a bit string whose length corresponds to the range of non-zero (integer) values.

BLOB

Data type

Binary objects.

BOOL

Data type

Boolean values.

BOOL[]

Data type

Arrays of Boolean values.

bool_and

Function

Returns TRUE if all non-empty values in the group are true; otherwise, FALSE.

bool_or

Function

Returns TRUE if at least one value in the group is true, otherwise FALSE.

BOOLEAN

Data type

Alias for data type BOOL.

BOOLEAN[]

Data type

Alias for data type BOOL[].

BPCHAR

Data type

Alias for data type VARCHAR.

BPCHAR[]

Data type

Alias for data type VARCHAR[].

BYTEA

Data type

Alias for data type BLOB.

CASE

SQL expression

SELECT query element.

cast

Function

Casts the data type to the specified data type.

cbrt

Function

Calculates the cube root.

ceil

Function

Rounds a number to the higher side.

ceiling

Function

Alias for function ceil.

CHAR

Data type

Alias for data type VARCHAR.

CHAR[]

Data type

Alias for data type VARCHAR[].

char_length

Function

Alias for function length.

character_length

Function

Alias for function length.

chr

Function

Returns the character corresponding to the value of the code ASCII or code Unicode, given in argument.

coalesce

Function

Returns the first value other than NULL from the list of argument values.

concat

Function

Concatenates multiple strings, arrays or binary values.

concat_ws

Function

Concatenates strings over a separator.

contains

Function

Returns true if the specified string string contains the searched substring search_string.

corr

Function

Calculates the correlation coefficient.

cos

Function

Calculates the cosine of an angle given in radians.

cot

Function

Calculates the cotangent of an angle given in radians.

count

Function

Counts the number of rows in a group.

count(argument)

Function

Counts the number of non-empty values in a group.

count_if

Function

Returns the number of records that satisfy the condition, or NULL if no records satisfy the condition.

countif

Function

Alias for function count_if.

covar_pop

Function

Calculates the population covariance (does not include bias correction).

covar_samp

Function

Calculates the sample covariance, including the Bessel bias correction.

CREATE API TOKEN

SQL expression

Create token.

CREATE ROLE

SQL expression

Create a new role.

CREATE SCHEMA

SQL expression

Create a new schema.

CREATE TABLE

SQL expression

Create a new table.

CREATE USER

SQL expression

Create a new user.

CREATE VIEW

SQL expression

Create a new view.

CREATE WORKER POOL

SQL expression

Create a worker pool.

cume_dist

Function

Cumulative allocation.

current_date

Function

Returns the current date as a value of type DATE.

current_localtimestamp

Function

Returns the current time and date as a value of type TIMESTAMP.

current_time

Function

Returns the current time as a value of type TIME.

DATE

Data type

Dates.

date_diff

Function

Returns the number of time units between two points in time as a value of type BIGINT.

date_part

Function

Alias for function datepart.

date_trunc

Function

Reduces a moment in time to the specified precision.

datediff

Function

Alias for function date_diff.

datepart

Function

Returns the specified part of the date or time value as a value of type BIGINT.

dayname

Function

Returns the English name of the day of the week for a date.

dayofmonth

Function

Returns the number of the month for the given date.

dayofweek

Function

Returns the day of the week number for a date starting on Sunday.

dayofyear

Function

Returns the day number of the year for a date.

DECIMAL

Data type

Alias for data type NUMERIC.

degrees

Function

Converts radians to degrees.

DELETE

SQL expression

SELECT query element.

dense_rank

Function

The rank of the current string within the group without skips.

DESCRIBE TABLE

SQL expression

Display information about the table.

DESCRIBE USER

SQL expression

Output information about the user.

DESCRIBE VIEW

SQL expression

Display information about the view.

divide

Function

Returns the result of division as an integer.

DOUBLE

Data type

Real numbers with variable precision.

DROP ALL API TOKENS

SQL expression

Drop all tokens for user.

DROP API TOKEN

SQL expression

Drop token.

DROP ROLE

SQL expression

Reset a role.

DROP SCHEMA

SQL expression

Delete a schema.

DROP TABLE

SQL expression

Delete a table.

DROP USER

SQL expression

Reset user.

DROP VIEW

SQL expression

Delete a view.

DROP WORKER POOL

SQL expression

Reset a worker pool.

ends_with

Function

Returns true if the string ends with the searched string.

entropy

Function

Calculates the log-2 entropy.

epoch

Function

Calculates the number of seconds since the start of an epoch at the given point in time.

era

Function

Returns the era number for the given date.

even

Function

Rounds to the nearest even number away from zero.

EXCEPT

SQL expression

SELECT query element.

exp

Function

Calculates the exponent of a number.

EXPLAIN

SQL expression

Output SELECT query plan.

factorial

Function

Calculates the factorial of a number.

favg

Function

Calculates the average using the Kahan Sum algorithm.

fdiv

Function

Performs integer division and returns the result as DOUBLE.

fill

Function

Returns the value calculated using the specified expression for the first row of the group.

first

Function

Returns the first value from a group.

flatten

Function

Takes a nested list and returns a list flattened by one level of nesting.

FLOAT

Data type

Alias for data type DOUBLE.

floor

Function

Rounds a number to the smaller side.

fmod

Function

Returns the remainder of dividing the first argument by the second argument.

format

Function

Formats a string using the fmt syntax.

format_bytes

Function

Alias for function formatReadableSize.

formatReadableDecimalSize

Function

Forms a text representation from a number of bytes in 1000 increments.

formatReadableSize

Function

Forms a text representation from a number of bytes in 1024 increments.

FROM

SQL expression

SELECT query element.

from_base64

Function

Converts a Base64 encoded string into a character string (BLOB).

from_binary

Function

Alias for function unbin.

from_hex

Function

Alias for function unhex.

from_json

Function

Alias for function json_transform.

from_json_strict

Function

Alias for function json_transform_strict.

fsum

Function

Calculates the sum of non-empty values in a group using the Kahan Sum algorithm.

gamma

Function

Calculates the value of the Gamma function.

gcd

Function

Calculates the greatest common divisor of two numbers.

gen_random_uuid

Function

Alias for function uuid.

generate_series

Function

Generates a list of values in the range between start and stop.

geomean

Function

Alias for function geometric_mean.

geometric_mean

Function

Calculates the geometric mean of non-empty values in a group.

GEOMETRY

Data type

Geospatial data.

get_current_time

Function

Alias for function current_time.

grade_up

Function

Alias for function list_grade_up.

GRANT

SQL expression

Grant privileges.

GRANT ROLE

SQL expression

Assign roles to users.

greatest

Function

Returns the largest of the specified arguments.

greatest_common_divisor

Function

Alias for function gcd.

GROUP BY

SQL expression

SELECT query element.

group_concat

Function

Alias for function string_agg.

hash

Function

Returns a hash of the data from argument as a number.

HAVING

SQL expression

SELECT query element.

hex

Function

Converts a string to hexadecimal representation.

histogram

Function

Returns a dictionary of unique non-empty values in a group, along with the number of times each occurs.

histogram_exact

Function

Returns a dictionary of the specified values in the group, along with the number of occurrences of each.

ILIKE

SQL expression

SELECT query element.

ilike_escape

Function

Checks if a string matches a case-insensitive pattern.

INSERT

SQL expression

SELECT query element.

instr

Function

Returns the position of the searched string in the string.

INTEGER

Data type

Alias for data type BIGINT.

INTEGER[]

Data type

Alias for data type BIGINT[].

INTERSECT

SQL expression

SELECT query element.

isfinite

Function

Checks whether a number is finite.

isinf

Function

Checks whether a number is infinite.

isnan

Function

Checks if the argument has the value NaN (Not a Number).

isodow

Function

Returns the day of the week number for a date starting on Monday.

isoyear

Function

Returns the year number for an ISO standard date.

JOIN

SQL expression

SELECT query element.

JSON

Data type

Data in JSON.

json

Function

Shortens the JSON structure record (removes spaces and line breaks).

json_array

Function

Creates a JSON list from passed arguments.

json_array_length

Function

Returns the number of elements in the array at the specified path in JSON, or 0 if the specified path is not an array.

json_contains

Function

Checks if the JSON structure contains the JSON substructure specified in the second argument.

json_each

Function

traverses the JSON structure and returns all parameters of the top-level structure element.

json_exists

Function

Checks if the JSON structure contains the specified path.

json_extract

Function

Extracts data from a JSON structure at the specified path. Returns the data as JSON.

json_extract_path

Function

Alias for function json_extract.

json_extract_string

Function

Extracts data from a JSON structure at the specified path. Returns the data in VARCHAR form.

json_extract_string_path

Function

Alias for function json_extract_string.

json_group_array

Function

Returns a JSON list containing all the values of a column.

json_group_object

Function

Returns a JSON structure containing all key-value pairs from the columns specified in the arguments.

json_keys

Function

Returns all keys from the specified JSON structure as VARCHAR[].

json_merge_patch

Function

Merges multiple JSON structures into one.

json_object

Function

Creates a JSON structure from key and value pairs passed as a list of arguments.

json_quote

Function

Alias for function to_json.

json_structure

Function

Returns a description of the JSON structure.

json_transform

Function

Transforms the JSON structure according to the specified structure.

json_transform_strict

Function

Transforms a JSON structure to match the specified structure. Issues an error if structures or types do not match.

json_tree

Function

traverses a JSON structure and returns all parameters of each element of the structure.

json_type

Function

Returns the data type of a field in a JSON structure.

json_valid

Function

Checks if the argument is a valid JSON structure.

json_value

Function

Retrieves values from a JSON structure at the specified path.

julian

Function

Returns the Julian date using the given date.

kahan_sum

Function

Alias for function fsum.

kurtosis

Function

Calculates kurtosis (as defined by Fisher) with bias correction according to the sample size..

kurtosis_pop

Function

Calculates kurtosis (as defined by Fisher) without bias correction.

lag

Function

Returns the value calculated for the string shifted by offset rows from the current to the beginning of the group.

last

Function

Returns the last value from a group.

last_value

Function

Returns the value calculated by the specified expression for the last row of the group.

lcase

Function

Alias for function lower.

lcm

Function

Calculates the least common multiple of two numbers.

lead

Function

Returns the value calculated for the row shifted by offset rows from the current row to the end of the group.

least

Function

Returns the smallest of the specified arguments.

least_common_multiple

Function

Alias for function lcm.

left

Function

Extracts a substring of the given length from the string, starting from the left edge.

left_grapheme

Function

Extracts a substring of the given length from a string, starting from the left edge and counting by grapheme clusters.

len

Function

Alias for function length.

length

Function

Returns the number of characters in a string.

length_grapheme

Function

Returns the number of grapheme clusters in the string.

lgamma

Function

Calculates the logarithm of the gamma function.

LIKE

SQL expression

SELECT query element.

like_escape

Function

Checks if a string matches a case-sensitive pattern.

LIMIT

SQL expression

SELECT query element.

list

Function

Alias for function array_agg.

list_aggr

Function

Alias for function list_aggregate.

list_aggregate

Function

Applies a specified aggregate function to a given list.

list_cat

Function

Alias for function t[list_cat].

list_concat

Function

Concatenates several lists into one.

list_contains

Function

Checks whether an element is present in a list.

list_cosine_distance

Function

Calculates the cosine distance between two lists (numeric vectors).

list_cosine_similarity

Function

Calculates the cosine similarity between two lists (numeric vectors).

list_distance

Function

Calculates the Euclidean distance between two points, the coordinates of which are specified as lists.

list_distinct

Function

Removes all duplicates and empty values from a list.

list_dot_product

Function

Alias for function list_inner_product.

list_element

Function

Alias for function list_extract.

list_extract

Function

Returns an element from a list by index.

list_grade_up

Function

Returns a sorted list of the original indices of the list elements.

list_has_all

Function

Checks that all elements of the second list are contained in the first list.

list_has_any

Function

Checks whether the two lists have at least one element in common.

list_indexof

Function

Alias for function list_position.

list_inner_product

Function

Calculates the scalar product of two numerical vectors of equal length.

list_negative_dot_product

Function

Alias for function list_negative_inner_product.

list_negative_inner_product

Function

Calculates the scalar product of two numerical vectors of equal length, multiplied by -1.

list_pack

Function

Alias for function list_value.

list_position

Function

Returns the index of an element in a list.

list_resize

Function

Resizes the list to the specified size.

list_reverse_sort

Function

Sorts the list in descending order.

list_select

Function

Returns a list of elements from the source list based on their indices.

list_slice

Function

Alias for function array_slice.

list_sort

Function

Sorts the list.

list_unique

Function

Calculates the number of unique elements in a list.

list_value

Function

Creates a list from the arguments passed.

list_where

Function

Filters a list using a list of logical flags.

list_zip

Function

Combines lists into a new list whose length is equal to the length of the longest list.

listagg

Function

Alias for function string_agg.

ln

Function

Calculates the natural logarithm of a number.

log

Function

Calculates the logarithm of a number on base 10.

log10

Function

Alias for function log.

log2

Function

Calculates the logarithm of a number on base 2.

lower

Function

Converts a string to lower case.

lpad

Function

Adds characters up to the given length to the string on the left.

ltrim

Function

Removes all occurrences of any of the specified characters at the beginning of a string.

mad

Function

Calculates the median absolute deviation.

max

Function

Returns the maximum value in the group.

max_by

Function

Alias for function arg_max.

md5

Function

Returns a hash MD5 of data from argument as a string (VARCHAR).

md5_number_lower

Function

Returns the low-order (rightmost) 64-bit MD5 hash segment of a string as a number.

md5_number_upper

Function

Returns the upper (left) 64-bit MD5 hash segment of a string as a number.

mean

Function

Alias for function avg.

median

Function

Returns the median of all non-empty values in the group.

min

Function

Returns the minimum value in the group.

min_by

Function

Alias for function arg_min.

mode

Function

Returns the most frequent value in a group.

monthname

Function

Returns the English name of the month for a date.

multiply

Function

Multiplies two numbers.

nextafter

Function

Returns the next value with variable precision (of type DOUBLE) after the first number towards the second number.

nextval_tngri

Function

Returns the next integer in the sequence given in argument.

nfc_normalize

Function

Converts a string to a normalised Unicode NFC string.

not_ilike_escape

Function

Checks if a string does not match a pattern without regard to character case.

not_like_escape

Function

Checks if a string does not match a case-sensitive pattern.

now

Function

Returns the current time as a value of type TIMESTAMPTZ.

nth_value

Function

Returns the value calculated for the nth row within a group (counting from 1).

ntile

Function

Splits each group into num subgroups of equal (as large as possible) size and returns the subgroup number.

NUMERIC

Data type

Real numbers with specified precision.

OFFSET

SQL expression

SELECT query element.

ord

Function

Alias for function unicode.

ORDER BY

SQL expression

SELECT query element.

parse_dirname

Function

Returns the root directory name from the specified path.

parse_dirpath

Function

Returns the full path to the last separator.

parse_filename

Function

Returns the name of the file at the specified path.

parse_path

Function

Returns a list of elements of the specified path.

percent_rank

Function

Calculates the relative rank of the current row within a group.

pg_size_pretty

Function

Alias for function formatReadableSize.

pi

Function

Returns the value of the number π.

position

Function

Returns the position of the searched string in the string.

pow

Function

Exposes the first argument to the degree given by the second argument.

power

Function

Alias for function pow.

prefix

Function

Checks if the string being searched is a prefix of another string.

printf

Function

Formats a string using the printf syntax.

product

Function

Multiplies the non-empty values in a group.

QUALIFY

SQL expression

SELECT query element.

quantile_cont

Function

Calculates an interpolated positive quantile.

quantile_disc

Function

Calculates a discrete positive quantile.

radians

Function

Converts degrees to radians.

random

Function

Returns an arbitrary number (of type DOUBLE) between 0 and 1.

range

Function

Generates a list of consecutive numbers within a specified range.

rank

Function

Returns the rank (with skips) of the current row within a group.

rank_dense

Function

Alias for function dense_rank.

read_csv

Function

Reads the .csv file and outputs the read data as a table.

read_json

Function

Reads a .json file and returns the read data as a table.

read_json_auto

Function

Alias for function read_json.

read_json_objects

Function

Reads a .json file and returns a list.

read_parquet

Function

Reads the .parquet file and outputs the read data as a table.

read_text

Function

Returns the content from the source as a table of read text.

read_xlsx

Function

Reads the .xlsx file and outputs the read data as a table.

regexp_escape

Function

Escapes special characters, converting the string into a regular expression.

regexp_extract

Function

Extracts a substring from a string using the given regular expression.

regexp_extract_all

Function

Extracts all non-overlapping substrings from a string using the given regular expression. Returns an array of substrings.

regexp_full_match

Function

Checks whether a regular expression overlaps a string completely.

regexp_matches

Function

Checks if a regular expression is contained within a string.

regexp_replace

Function

Replaces a substring covered by a regular expression with the specified string.

regexp_split_to_array

Function

Splits a string into parts, separated by a regular expression, and returns the parts as an array.

regexp_split_to_table

Function

Splits a string into parts separated by a regular expression, and returns the parts as strings.

regr_sxy

Function

Alias for function covar_samp.

repeat

Function

Forms a string from the given string repeated the given number of times.

replace

Function

Replaces all substrings with the specified string.

reservoir_quantile

Function

Calculates an approximate quantile using reservoir splatting.

reverse

Function

Reverses the order of characters in a string.

REVOKE

SQL expression

Revoke privileges.

REVOKE ROLE

SQL expression

Revoke roles from users.

right

Function

Extracts a substring of the given length from a string, starting at the right edge.

right_grapheme

Function

Extracts a substring of the given length from a string, starting at the right edge and counting by grapheme clusters.

round

Function

Rounds the number from the first argument to the precision specified in the second argument.

round_even

Function

Round the number from the first argument to the nearest even number with the precision specified in the second argument.

roundbankers

Function

Alias for function round_even.

row_number

Function

Returns the number of the current row in its group (counting from 1).

rpad

Function

Adds characters up to the given length to the string on the right.

rtrim

Function

Removes all occurrences of any of the specified characters at the end of a string.

SELECT

SQL expression

SELECT query.

sem

Function

Calculates the standard error of the mean.

SET SCHEMA

SQL expression

Set default schema.

setseed

Function

Fixes the initial value for the random() function.

sha1

Function

Returns a hash SHA-1 of the data from argument as a string (VARCHAR).

sha256

Function

Returns a hash SHA-256 of the data from argument as a string (VARCHAR).

SHOW API TOKENS

SQL expression

Output a list of all tokens.

SHOW COLUMNS

SQL expression

Output a list of all columns in all tables.

SHOW ROLES

SQL expression

Output a list of all roles.

SHOW SCHEMA

SQL expression

Output default schema.

SHOW SCHEMAS

SQL expression

Output a list of all schemas.

SHOW TABLES

SQL expression

Output a list of all tables.

SHOW USERS

SQL expression

Output a list of all users.

SHOW WORKER POOL

SQL expression

Show the current worker pool.

SHOW WORKER POOLS

SQL expression

Show the list of all worker pools.

sign

Function

Returns -1, 1 or 0 depending on the sign of the argument.

signbit

Function

Determines whether the sign bit of a real number is set.

sin

Function

Calculates the sine of an angle given in radians.

skewness

Function

Calculates the skewness coefficient.

split

Function

Splits a string into parts by the given separator.

split_part

Function

splits a string into parts at the given separator and returns the part at the given index.

sqrt

Function

Calculates the square root.

ST_Distance

Function

Calculates the distance between two points in the plane.

ST_Distance_Sphere

Function

Calculates the distance between two points on the sphere.

ST_Point

Function

Creates a point of type GEOMETRY.

starts_with

Function

Returns true if the string starts with the searched string.

stddev

Function

Alias for function stddev_samp.

stddev_pop

Function

Calculates the standard deviation of the population.

stddev_samp

Function

Calculates the sample standard deviation.

str_split

Function

Alias for function split.

str_split_regex

Function

Alias for function regexp_split_to_array.

STRING

Data type

Alias for data type VARCHAR.

STRING[]

Data type

Alias for data type VARCHAR[].

string_agg

Function

Concatenates values into a single text string using a specified separator.

string_split

Function

Alias for function split.

string_split_regex

Function

Alias for function regexp_split_to_array.

string_to_array

Function

Alias for function split.

strip_accents

Function

Removes diacritical marks from characters in a string.

strlen

Function

Returns the number of bytes in the string.

strpos

Function

Alias for function instr.

strptime

Function

Converts text to a point in time using the specified format.

substr

Function

Alias for function substring.

substring

Function

Extracts a substring from a string.

substring_grapheme

Function

Extracts a substring from a string by grapheme clusters.

subtract

Function

Subtracts the second argument from the first argument.

suffix

Function

Alias for function ends_with.

sum

Function

Calculates the sum of all non-empty values in a group.

sumkahan

Function

Alias for function fsum.

tan

Function

Calculates the tangent of an angle given in radians.

TEXT

Data type

Alias for data type VARCHAR.

TEXT[]

Data type

Alias for data type VARCHAR[].

TIME

Data type

Time.

TIMESTAMP

Data type

Time stamps.

TIMESTAMPTZ

Data type

Time stamps with time zone.

timezone_hour

Function

Returns the time zone offset of the given time instant from 0.

tngri.create_table

Python function

Creates a table and populates it with data from a DataFrame.

tngri.delete_file

Python function

Deletes a file at the specified path.

tngri.list_files

Python function

Lists files at the specified path.

tngri.run_notebook

Python function

Runs the specified notebook from another notebook.

tngri.sql

Python function

Executes the specified SQL query within a Python cell.

tngri.upload_df

Python function

Uploads data from DataFrame to Tengri.

tngri.upload_file

Python function

Uploads data from a file to Tengri.

tngri.upload_s3

Python function

Uploads a file from the specified bucket S3 to Tengri.

to_base

Function

Translates an integer into the given number system and returns as a string.

to_base64

Function

Encodes binary data into a Base64 text string.

to_binary

Function

Alias for function bin.

to_hex

Function

Alias for function hex.

to_json

Function

Creates a JSON structure from an argument of any type.

to_timestamp

Function

Converts seconds from the beginning of an epoch to a moment in time.

today

Function

Alias for function current_date.

translate

Function

Performs character-by-character replacement in a string according to the given character sets.

trim

Function

Removes all occurrences of any of the specified characters on both sides of the string.

trunc

Function

Discards all characters after the decimal separator.

TRUNCATE TABLE

SQL expression

Remove all rows from a table.

try_cast

Function

Casts the data type to the specified data type.

ucase

Function

Alias for function upper.

unbin

Function

Converts a value from a binary representation to a binary object (BLOB).

unhex

Function

Converts a value from a hexadecimal representation to a binary object (BLOB).

unicode

Function

Returns the code Unicode of the first character of a string as an integer.

UNION

SQL expression

SELECT query element.

unnest

Function

Expands lists or structures from argument into a set of distinct values.

UPDATE

SQL expression

SELECT query element.

upper

Function

Converts a string to uppercase.

url_decode

Function

Decodes a URL from the Percent-Encoding.

url_encode

Function

Encodes the URL into a Percent-Encoding.

USE ROLE

SQL expression

Set the active role.

USE WORKER POOL

SQL expression

Set the current compute pool.

uuid

Function

Returns a random v4 UUID.

uuid_extract_timestamp

Function

Extracts a timestamp from a v7 UUID.

uuid_extract_version

Function

Extracts the version from the UUID.

uuidv4

Function

Alias for function uuid.

uuidv7

Function

Returns a random v7 UUID.

var_pop

Function

Calculates the variance of the population without bias correction.

var_samp

Function

Calculates the sample variance, including the Bessel correction for bias.

VARCHAR

Data type

Text strings.

VARCHAR[]

Data type

Arrays of text strings.

variance

Function

Alias for function var_samp.

wavg

Function

Alias for function weighted_avg.

weekday

Function

Alias for function dayofweek.

weekofyear

Function

Returns the week number of the ISO standard year.

weighted_avg

Function

Calculates the weighted average of all non-empty values in a group.

WHERE

SQL expression

SELECT query element.

WITH

SQL expression

SELECT query element.

xor

Function

Computes a bitwise exclusive OR.

yearweek

Function

Returns the year and week number of the ISO standard as a number.

||

Operator

Concatenates multiple strings, arrays or binary values.

~

Operator

Checks if the regular expression covers the string completely.