TRANSFORM_U
All functions > ARRAY_OF_ROWS > TRANSFORM_U
Transforms an array of rows using UNNEST with full SQL query capabilities
Syntax
TRANSFORM_U(from, raw_query, by, imports)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
from | ARRAYROW | Yes | Array of rows to transform |
raw_query | QUERY | Yes | Raw query representation for unnest query |
by | FEATURE | Yes | Optional explicit aggregation key feature for grouping results |
imports | ARRAYFEATURE | Yes | Optional array of features to import into the transform scope |
Returns
ARRAY[ROW] - Transformed array of rows
Notes
- Uses UNNEST to flatten array into table rows
- Supports full SQL query operations
- Most flexible transformation approach
- Can join with other data sources
- Default TRANSFORM alias points to this implementation
- When data comes from BIND_VALUES or similar (no clear INPUT key in dependencies), the BY clause is required to specify the aggregation key explicitly
- Syntax: TRANSFORM(array BY key_feature USING (query))
Aliases
TRANSFORM