All Functions This page contains a comprehensive list of all available functions organized by category. Each function links to its detailed documentation page with syntax, examples, and test cases.
Function Categories
Function Description ENTITY Returns a reference to an entity. INPUT Returns a reference to an input.
Function Description BIND_VALUE Binds the given value to the given feature. BIND_VALUES Binds the given array of values to the given feature or features. BIND_COLUMNS Binds columns from a table to the given features.
Function Description RELATED Joins a feature or an aggregation using a key as base UNNEST Unnests an array of rows into a table of rows
Function Description CAST Returns the given expression casted to the given type, or raise an exception if the conversion... UNSAFE_CAST Returns the given expression casted to the given type, or raise an exception if the conversion... TRY_CAST Returns the given expression casted to the given type, or NULL if the cast fails. NULL Returns a NULL value of the given type. EMPTY Returns a NULL value of type EMPTY.
Function Description VARIANT Returns a reference to a variant of the given feature with the given replacements in its... MACRO Returns a reference to a macro of the given feature with the given inputs. UDF Returns a reference to a UDF (user-defined function).
Function Description IF Returns one value if a condition is true, another if false CASE WHEN Returns the result of the first condition that evaluates to true CASE WHEN VALUE Returns the result corresponding to the first matching value in a simple case expression COALESCE Returns the first non-NULL value from a list of values
Function Description AND Returns TRUE if both arguments are true. OR Returns TRUE if at least one argument is true. NOT Returns TRUE if the argument is false.
Function Description EQUALS Returns TRUE if the first value equals the second value NOT_EQUALS Returns TRUE if the first value does not equal the second value IS_NULL Returns TRUE if the expression evaluates to NULL. IS_NOT_NULL Returns TRUE if the expression does NOT evaluate to NULL. DISPLAYS_AS Returns TRUE if two values are not distinct, treating NULL values as comparable. NOT_DISPLAYS_AS Returns TRUE if two values are distinct, treating NULL values as comparable.
Function Description LESS_THAN Returns TRUE if the first value is strictly less than the second value LESS_THAN_OR_EQUALS Returns TRUE if the first value is less than or equal to the second value GREATER_THAN Returns TRUE if the first value is strictly greater than the second value GREATER_THAN_OR_EQUALS Returns TRUE if the first value is greater than or equal to the second value BETWEEN Returns TRUE if a value is within a specified range (inclusive) NOT_BETWEEN Returns TRUE if a value is NOT within a specified range (inclusive). LEAST Returns the least (minimum) value from a list of arguments. GREATEST Returns the greatest (maximum) value from a list of arguments.
Function Description LIKE Returns TRUE if a string matches a specified pattern with wildcards. NOT_LIKE Returns TRUE if a string does NOT match a specified pattern with wildcards.
Function Description IN_LIST Returns TRUE if a value exists in a list of values. NOT_IN_LIST Returns TRUE if a value does NOT exist in a list of values.
Function Description ADD Returns the sum of two quantities, numbers, dates/timestamps or intervals. SUBTRACT Returns the result of the subtraction of the second number from the first. MULTIPLY Returns the product of two numbers. DIVIDE Returns the result of the division of the first number by the second as a double. TRY_DIVIDE Returns the result of the division of the first number by the second as a double. Returns NULL if... DIVIDE_TYPE Returns the result of the division of the first number by the second, preserving the type of the... TRY_DIVIDE_TYPE Returns the result of the division of the first number by the second, preserving the type of the... MODULO Returns the remainder after dividing the first number by the second (modulo operation).
Function Description ROUND Returns the number rounded to the nearest integer or to a specified number of decimal places. TRUNCATE Returns the integer part of a number by truncating the fractional part. FLOOR Rounds a number down to the nearest integer (floor function). CEIL Returns the number rounded up to the nearest integer (ceiling function).
Function Description ABS Returns the absolute value of a number. SIGN Returns the sign of a number: -1 for negative, 0 for zero, and 1 for positive.
Function Description POW Returns the value of a number raised to the power of another number. SQRT Returns the square root of a number. CBRT Returns the cube root of a number. EXP Returns e raised to the power of the given number (exponential function). LN Returns the natural logarithm (base e) of a number. LOG Returns the logarithm of a number to a specified base.
Function Description COS Returns the cosine of an angle in radians. SIN Returns the sine of an angle in radians. TAN Returns the tangent of an angle in radians. ACOS Returns the arccosine (inverse cosine) of a number in radians. ASIN Returns the arcsine (inverse sine) of a number in radians. ATAN Returns the arctangent (inverse tangent) of a number in radians. ATAN2 Returns the arctangent of y/x, using the signs to determine the quadrant.
Function Description COSH Returns the hyperbolic cosine of a number. SINH Returns the hyperbolic sine of a number. TANH Returns the hyperbolic tangent of a number.
Function Description DEGREES Returns the angle in degrees for the given angle in radians. RADIANS Returns the angle in radians for the given angle in degrees.
Function Description FROM_BASE Returns the decimal (base 10) equivalent of a number from a specified base. TO_BASE Returns the string representation of a decimal number in a specified base.
Function Description E Returns the mathematical constant e (Euler's number). PI Returns the mathematical constant π (pi). INFINITY Returns the floating-point representation of positive infinity. NAN Returns the floating-point representation of NaN (Not a Number).
Function Description IS_FINITE Returns TRUE if a number is finite (not infinite and not NaN). IS_INFINITE Returns TRUE if a number is infinite (positive or negative infinity). IS_NAN Returns TRUE if a value is NaN (Not a Number).
Function Description WIDTH_BUCKET_REGULAR Returns the bucket number for a value in equally-spaced buckets within a range. WIDTH_BUCKET Returns the bucket number for a value in a histogram with custom bin boundaries.
Function Description LOWER Returns the string with all characters converted to lowercase. UPPER Returns the string with all characters converted to uppercase.
Function Description TRIM Returns the string with whitespace from both ends removed. LTRIM Returns the string with whitespace from the left (beginning) removed. RTRIM Returns the string with whitespace from the right (end) removed. LPAD Returns the string padded on the left to a specified length with a padding string. RPAD Returns the string padded on the right to a specified length with a padding string.
Function Description STARTS_WITH Returns TRUE if a string starts with a specified prefix. ENDS_WITH Returns TRUE if a string ends with a specified suffix. POSITION Returns the position of the first occurrence of a substring within a string. STRPOS Returns the position of a substring within a string, optionally finding the N-th occurrence.
Function Description SUBSTR Returns a substring from a string starting at a specified position. SPLIT Returns an array of substrings from a string split by a delimiter. SPLIT_PART Returns a specific part of a string after splitting by a delimiter.
Function Description REVERSE Returns the string with all characters in reverse order. REPLACE Returns the string with all occurrences of a substring replaced with another substring. TRANSLATE Returns a string with character-level replacements applied based on character-to-character mappings.
Function Description CONCAT Returns a single concatenated string from a list of strings. CONCAT_WS Returns a concatenated string from a list of strings with a separator between each element.
Function Description LENGTH Returns the number of characters in a string. CHR Returns the character corresponding to the given Unicode code point. CODEPOINT Returns the Unicode code point of the first character in a string.
Function Description HAMMING_DISTANCE Returns the Hamming distance between two strings of equal length. LEVENSHTEIN_DISTANCE Returns the Levenshtein (edit) distance between two strings.
Function Description WORD_STEM Returns the stem (root form) of a word using language-specific stemming rules. SOUNDEX Returns a four-character Soundex code representing the phonetic sound of a string.
Function Description LUHN_CHECK Returns TRUE if a string passes the Luhn algorithm (modulus 10 checksum).
Function Description MD5 Returns the MD5 hash of a string as a 32-character hexadecimal string. SHA1 Returns the SHA-1 hash of a string as a 40-character hexadecimal string. SHA256 Returns the SHA-256 hash of a string as a 64-character hexadecimal string.
Function Description REGEX_CONTAINS Returns TRUE if a string contains a match for a regular expression pattern. REGEX_EXTRACT_FIRST Returns the first substring matching a regular expression pattern, optionally extracting a specific... REGEX_EXTRACT_ALL Returns an array of all substrings matching a regular expression pattern. REGEX_REPLACE_FIRST Returns the string with the first occurrence of a regular expression pattern replaced. REGEX_REPLACE_ALL Returns the string with all occurrences of a regular expression pattern replaced.
Function Description ADD Returns the date/timestamp after adding a given interval to the given date/timestamp. SUBTRACT Returns difference between two dates or date and interval. DATE_ADD Returns the date/timestamp after adding a given number of a given units to the given date/timestamp. DATE_DIFF Returns the difference between the two given timestamps in the given unit.
Function Description EXTRACT_FROM_DATE Returns the part of the given timestamp in the given unit.
Function Description DATE_TRUNC Returns the given timestamp truncated to the given unit. DATE_FORMAT Returns a string from the given timestamp and format. TO_ISO8601 Returns an ISO 8601 string from the given timestamp.
Function Description FROM_UNIXTIME Returns a timestamp from the given unix timestamp (BIGINT representation of the number of seconds... TO_UNIXTIME Returns a unix timestamp (BIGINT representation of the number of seconds since 1970-01-01 00:00:00...
Function Description HUMAN_READABLE_SECONDS Returns a human readable string from the given number of seconds. PARSE_DURATION Returns an interval from the given duration string. TO_MILLISECONDS Returns the truncated number of milliseconds in the given interval.
Function Description JSON_PARSE Returns the given string as a JSON expression. JSON_PARSE_AS Returns the value of a JSON expression represented as a string in the given type. JSON_EXTRACT Returns the value of the given JSON path in the given JSON expression. JSON_EXTRACT_SCALAR Returns the scalar value of the given JSON path in the given JSON expression. JSON_FORMAT Returns the given JSON expression as a string.
Function Description ELEMENT_AT_POS Returns the element at the specified position in an array. ELEMENTS_AT_POS Returns the elements at multiple specified positions in an array. SLICE Returns a slice of an array using start:length:step semantics. SLICE_END Returns the elements at multiple specified positions in an array.
Function Description CONTAINS Returns TRUE if the array contains the specified element. CONTAINS_SEQUENCE Returns TRUE if the array contains the specified sequence as a contiguous subsequence. ARRAY_POSITION Returns the 1-based position of the first occurrence of an element in an array. ARRAY_LOOKUP Returns the value corresponding to a lookup key using parallel key-value arrays.
Function Description ARRAY_SORT Returns the sorted version of an array. ARRAY_REVERSE Returns the reverse of an array. ARRAY_DISTINCT Returns an array with distinct elements, sorted in ascending order. ARRAY_REMOVE Returns an array with all occurrences of the specified element removed. FLATTEN Flattens a nested array structure into a single-level array.
Function Description ARRAY_UNION Returns the union of two arrays, eliminating duplicate elements. ARRAY_INTERSECT Returns the intersection of two arrays using set semantics. ARRAY_EXCEPT Returns the difference of two arrays using set semantics. ARRAYS_OVERLAP Returns TRUE if any elements are common between the two arrays.
Function Description ARRAY_LENGTH Returns the number of elements in an array. ARRAY_SUM Returns the sum of all numeric elements in an array. ARRAY_AVG Returns the arithmetic mean (average) of all numeric elements in an array. ARRAY_MIN Returns the smallest value in an array using natural ordering. ARRAY_MAX Returns the largest value in an array using natural ordering. ARRAY_HISTOGRAM Returns a frequency histogram of values in an array as an array of value-count pairs.
Function Description ALL Returns TRUE if all elements in the boolean array are true. ANY Returns TRUE if any element in the boolean array is true. NONE Returns TRUE if no elements in the boolean array are true. ARRAY_NOT Returns an array with inverted boolean values (logical NOT applied to each element).
Function Description ARRAY_CONCAT Concatenates multiple arrays into a single combined array with optional deduplication.
Function Description REPEAT Creates an array by repeating an element a specified number of times. SEQUENCE Generates an array containing a sequence of numbers from start to stop with optional step.
Function Description ARRAY_JOIN Joins the elements of an array into a single string using a specified delimiter.
Function Description COSINE_SIMILARITY Calculates the cosine similarity between two arrays. DOT_PRODUCT Calculates the dot product of two arrays. EUCLIDEAN_DISTANCE Calculates the Euclidean distance between two arrays. NORMALIZE Normalizes a numeric array by dividing each element by the sum of all elements.
Function Description MERGE Merges multiple row structures into a single row with combined fields
Function Description INDEX_UNIQUE Returns an index unique computed from the given array and key. INDEX_MULTI Returns an index multi computed from the given array and key. ELEMENT_AT_KEY Returns one element at the given key from the given index, array or array of rows. ELEMENTS_AT_KEY Returns multiple elements at the given key from the given index, array or array of rows.
Function Description EXTRACT Returns the extracted fields from the given expression. UNWRAP Returns the first field values from an array of single-field rows as a simple array. UNWRAP_ONE Returns the value of the first field of the first element in an array of single-field rows. ZIP Combines multiple arrays into a single array of structured rows with named fields. ARRAY_MERGE Merges multiple arrays of rows element-wise into a single array of combined rows, with optional... EXTEND Adds computed feature fields to a base row or array of rows with field bindings TRANSFORM_U Transforms an array of rows using UNNEST with full SQL query capabilities
Function Description BOOL_AND() OVER ... Returns TRUE if all boolean values in the window frame are true. BOOL_OR() OVER ... Returns TRUE if any boolean value in the window frame is true.
Function Description ROW_NUMBER() OVER ... Returns a unique sequential number for each row within its partition, starting at 1. RANK() OVER ... Returns the rank of the current row within its partition, with gaps. Rows with equal values for the... DENSE_RANK() OVER ... Returns the rank of the current row within its partition, without gaps. Similar to RANK but... NTILE() OVER ... Returns the bucket number (1 to n) for each row in a partition, where n is the number of buckets. PERCENT_RANK() OVER ... Returns the relative rank of the current row: (rank - 1) / (total rows - 1). CUME_DIST() OVER ... Returns the cumulative distribution: (number of rows <= current row) / (total rows).
Function Description ANY_VALUE() OVER ... Returns an arbitrary non-null value from the window frame, if one exists. ARRAY_AGG() OVER ... Returns an array of all values in the window frame. MIN_BY() OVER ... Returns the value of the first expression corresponding to the minimum value of the second... MAX_BY() OVER ... Returns the value of the first expression corresponding to the maximum value of the second...
Function Description IS_DOWNSTREAM_OF Returns TRUE if the current feature is dependent of the given feature in the dependency DAG IS_UPSTREAM_OF Returns TRUE if the current feature is a dependency of the given feature in the dependency DAG DEPTH_RELATIVE_TO Returns the depth of the current feature relative to the given feature in the dependency DAG
Function Description KEYSET Returns a reference to a keyset. PREPARED_STATEMENT Returns a reference to a prepared statement of the given feature with the given inputs. TYPEOF Returns the type of the given expression in FeatureQL. SQLTYPEOF Returns the type of the given expression in the target database. VERSION Returns the version of the featuremesh registry.
Function Description SCD_AT_TIME Returns the state of an SCD (slowly changing dimension) value at the given point in time. ACCUMULATION_AT_TIME Returns the state of an accumulation of events at the given point in time.
Function Description TO_ACTIVITY_BITS Returns the activity bits for the given array of activity dates and date reference. FROM_ACTIVITY_BITS Returns the activity dates for the given activity bits and date reference. BINARY_REPRESENTATION Returns the binary representation as a string of the given activity bits UPDATE_ACTIVITY_BIT Returns the activity bits for the given activity bits and whether the current day is active. IS_ACTIVE Returns whether the given activity bits is active for the given time period ACTIVITY_STATUS Returns the activity status between two time periods for the given activity bits COUNT_ACTIVE Returns the number of active days for the given activity bits and time period RECENCY Returns the number of days since the last active day for the given activity bits
Function Description HASH01 Returns a value between 0 and 1 based on the given hashing key. GRADUAL_ROLLOUT Returns the exposure to a new version based on the given hashing key and rollout parameters.
Function Description SAMPLE_UNIFORM Returns a value uniformly chosen between two bounds based on the given hashing key. SAMPLE_GAUSSIAN Returns a value chosen from a normal distribution between two bounds based on the given hashing key. SAMPLE_VALUE Returns a value from the given array of values and proportions based on the given hashing key. SAMPLE_BOOL Returns the discrete event (true or false) with the given probability based on the given hashing...
Function Description EXTERNAL_COLUMNS Mapping of source columns to features. EXTERNAL_REDIS Returns the value of the given key and field (optionally) from the given Redis source EXTERNAL_HTTP Returns the JSON response from a HTTP call
Function Description SOURCE_HTTP Creates a HTTP connection to the given URI SOURCE_JDBC Creates a JDBC connection to the given DSN SOURCE_REDIS Creates a Redis connection to the given URI
Function Description BIT_AND Returns the bitwise AND of two bitstrings. BIT_OR Returns the bitwise OR of two bitstrings. BIT_XOR Returns the bitwise XOR (exclusive OR) of two bitstrings. BIT_NOT Returns the bitwise NOT (complement) of a bitstring, flipping every bit. BIT_SHIFT_LEFT Returns the bitstring shifted left by N positions, filling with zeros on the right. BIT_SHIFT_RIGHT Returns the bitstring shifted right by N positions, filling with zeros on the left.
Function Description CURRENT_TIMESTAMP Returns the current date and time. RANDOM Returns a random number in the range 0.0 <= x < 1.0
Function Description EVAL_CONST Returns the result of evaluating a constant formula as a literal.
Summary
Total Functions: 282Total Categories: 18This documentation is automatically generated from the FeatureMesh registry.