ARRAY OF ROWS Functions

All functions > ARRAY OF ROWS

All functions in the ARRAY OF ROWS category.

FunctionDescription
EXTRACT Returns the extracted fields from the given expression.
INDEX_MULTI Returns an index multi computed from the given array and key.
INDEX_UNIQUE Returns an index unique computed from the given array and key.
TRANSFORM_C Transforms an array of rows using a correlated subquery
TRANSFORM_U Transforms an array of rows using UNNEST with full SQL query capabilities
UNNEST Unnests an array of rows into a table of rows
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_FUNC Combines multiple arrays into a single array of structured rows with named fields.

Summary

  • Functions in ARRAY OF ROWS: 9

This documentation is automatically generated from the FeatureMesh registry.

Last update at: 2025/10/13 10:23:46