Consider a BQ table with the following schema

```
name
day
day.purchase  

```

And values

```
name     day              day.purchase
John    [1,2]  [ ['Coke', 'Fanta'], ['Pepsi', 'Fanta', 'Water'] ]

```

How to unnest both levels so I get the full table?

```
John 1 'Coke'
John 1 'Fanta'
John 2 'Pepsi'
John 2 'Fanta'
John 2 'Water'

```