TRANSFORM

Transforms an array of rows using a internal subquery

Signatures

Returns: Transformed array of rows

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

sql

Parameter	Type	Required	Description
`from`	`ARRAY<ROW>`	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`	`ARRAY<FEATURE>`	Yes	Optional array of features to import into the transform scope

FeatureQL

SELECT 1 as fake;

Result

fake BIGINT
1

Suggest changes to this page

Last update at: 2026/03/18 16:18:57

On this page