Link Search Menu Expand Document

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