BigQuery is a scalable and highly efficient data warehouse solution. As we move more and more existing databases into BigQuery with existing structure, some data types are little difficult to query and manipulate, such as “struct” data type.
For example, we may get a data row that may look like this.
In order to query and filter records based on Field, we can use a query similar to below –
SELECT * FROM TABLE_NAME WHERE (SELECT c.value FROM UNNEST(Field) AS c WHERE c.key='key1') = 'value1'