Analytics Engineering, Bigquery, Sql, Data Engineering, Editors Pick.
Histories Next, we perform a union between the two history tables like this: To understand this query, imagine that price_history is like a mini-table contained inside the top-level row. Then “SELECT … FROM UNNEST(price_history)” is a way to query this mini-table while staying inside the top-level