BigQuery: use UNNEST(x) as a WITH OFFSET as __row_num instead of row_number() over()

malloydata / malloy

Malloy is an experimental language for describing data relationships and transformations.

http://www.malloydata.dev

MIT License

1.96k stars 76 forks source link

BigQuery: use UNNEST(x) as a WITH OFFSET as __row_num instead of row_number() over() #1675

Open lloydtabb opened 6 months ago

lloydtabb commented 6 months ago

BigQuery has added UNNEST WITH OFFSET to compute the index of an unnested array. We should try and use it instead of row_number() over() as it is likely more efficient.