SQL functions

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 GROUP BY clause.

• Aggregation functions
  Perform a calculation across a set of rows, returning a single value.

• Array functions
  Used for the manipulation and querying of ARRAY-type data, such as transforming and filtering. Includes Lambda functions.

• Binary functions (Supported will be added in future release) 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.

• JSON functions
  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 TEXT

• Numeric functions
  Manipulate data types including INTEGER, BIGINT, DOUBLE PRECISION, and other numeric types

• String functions
  Manipulate string data types

• Window functions
  Perform a calculation across a specified set of table rows

---