BIND_VALUES

All functions > CORE > BIND_VALUES

Binds the given array of values to the given feature or features.

Signatures

Returns: A table with the array values unnested into rows and columns

BIND_VALUES(array: ARRAY<ROW<T>>, [ordinality: BOOLEAN]) → TABLE<T>
sql
ParameterTypeRequiredDescription
arrayARRAY<ROW<T>>YesAn array of row values to bind as a table
ordinalityBOOLEANNoInclude row number column

Notes

  • Converts an array into a table structure for feature binding
  • Unnests array elements into individual rows
  • Can handle both simple arrays and arrays of row structures
  • Optional ordinality parameter adds row numbering
  • Supports mapping array elements to named features
  • Used in feature materialization from array data
  • Part of the FeatureMesh binding system
Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19