EXTEND

All functions > ARRAY OF ROWS > EXTEND

Adds computed feature fields to a base row or array of rows with field bindings

Signatures

Returns: Base with additional computed fields

EXTEND(base: ROW or ARRAY<ROW>, features: ARRAY<FEATURE>, as_fields: ARRAY<FIELD>, binding_fields: ARRAY<FIELD>, binding_features: ARRAY<FEATURE>) → ROW or ARRAY[ROW]

sql

Parameter	Type	Required	Description
`base`	`ROW or ARRAY<ROW>`	Yes	Base row or array of rows to add fields to
`features`	`ARRAY<FEATURE>`	Yes	Array of features to compute and add as fields
`as_fields`	`ARRAY<FIELD>`	Yes	Array of field names for the new features
`binding_fields`	`ARRAY<FIELD>`	Yes	Array of field names from base to bind to features
`binding_features`	`ARRAY<FEATURE>`	Yes	Array of feature names to bind the fields to

Notes

Allows adding computed features as new fields to existing rows
BINDING clause maps base fields to feature inputs
Features are computed using the bound field values
Works with both single rows and arrays of rows
New field names must not conflict with existing fields

Suggest changes to this page

Last update at: 2026/03/03 16:47:38

On this page

Signatures Notes