Skip to content

Instantly share code, notes, and snippets.

@wriglz

wriglz/bigquery_cross_join_unnest.sql

Created July 16, 2024 09:21
Show Gist options
  • Save wriglz/b48609a72ab2cb32a748bbb3a1acc39d to your computer and use it in GitHub Desktop.
Save wriglz/b48609a72ab2cb32a748bbb3a1acc39d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bigquery_cross_join_unnest.sql
WITH Sequences AS
(SELECT 1 AS id, [0, 1, 1, 2, 3, 5] AS some_numbers
UNION ALL SELECT 2 AS id, [2, 4, 8, 16, 32] AS some_numbers
UNION ALL SELECT 3 AS id, [5, 10] AS some_numbers)
SELECT id, flattened_numbers
FROM Sequences
CROSS JOIN UNNEST(Sequences.some_numbers) AS flattened_numbers;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment