TRANSFORM_U

All functions > ARRAY OF ROWS > TRANSFORM_U

Transforms an array of rows using UNNEST with full SQL query capabilities

Signatures

Returns: Transformed array of rows

TRANSFORM_U(from: ARRAY<ROW>, raw_query: QUERY, by: FEATURE, imports: ARRAY<FEATURE>) → ARRAY<ROW>

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

Examples

SELECT 1 as fake;