Pay attention to this when UNNESTING in BigQuery
Here's a common confusion that I encounter while working with ARRAYs in BigQuery. This can lead to wrong queries in some situations. Consider the following two snippets:
FROM table,
UNNEST(repeated_column) AS single_item
versus
FROM table
LEFT JOIN...
datawise.dev2 min read