# BigQuery Tip: The UNNEST Function

DevFeed: [BigQuery Tip: The UNNEST Function](<https://devfeed.tech/articles/bigquery-tip-the-unnest-function-16178.md>)

Original publisher: [Read original article](<https://firebase.blog/posts/2017/03/bigquery-tip-unnest-function>)

Author: Todd Kerpelman

Published: 2017-03-22T00:00:00Z

Content type: tutorial

Language: en

Sources: [Firebase Blog](<https://devfeed.tech/sources/firebase-blog.md>)

Topics: [BigQuery](<https://devfeed.tech/topics/bigquery.md>), [Firebase](<https://devfeed.tech/topics/firebase.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Data structures](<https://devfeed.tech/topics/data-structures.md>)

Tags: [arrays](<https://devfeed.tech/tags/arrays.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [firebase](<https://devfeed.tech/tags/firebase.md>), [google-analytics](<https://devfeed.tech/tags/google-analytics.md>), [sql](<https://devfeed.tech/tags/sql.md>), [structure](<https://devfeed.tech/tags/structure.md>), [tutorials](<https://devfeed.tech/tags/tutorials.md>)

## AI overview

A Firebase tutorial explaining how Firebase Analytics data exported to BigQuery is organized in nested arrays and structs. It introduces standard SQL and the UNNEST function for querying event data and event parameters without joining separate tables.

## Source excerpt

News, tutorials, and updates from the Firebase team.