See a full function glossary, or find functions based on type from the list below.
Aggregate array functions
Work on array-typed columns, but instead of being applied row by row, they combine the results of all the arrays belonging to each of the groups defined by the
Perform a calculation across a set of rows, returning a single value.
Used for manipulation and querying of
BYTEA-type data, such as encoding and decoding.
Conditional and miscellaneous functions
Include various methods for modifying data types and applying conditional operations.
Date and time functions
Manipulate date and time data types.
Extract and transform JSON into Firebolt native types, or JSON sub-objects. Used either during the ELT process or applied to columns storing JSON objects as plain
Manipulate data types including
DOUBLE PRECISION, and other numeric types
Manipulate string data types
Perform a calculation across a specified set of table rows