BIND_TABLE
All functions > BIND > BIND_TABLE
Binds the given array of values to the given feature or features.
Syntax
BIND_TABLE(array, features[, ordinality])sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
array | ARRAYROW | Yes | An array of row values to bind as a table |
ordinality | ARRAYFEATURE | No | Include row number column |
Returns
A table with the array values unnested into rows and columns
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