Unnesting RECORD arrays in BigQuery SQL 

Thank you for This series God bless you

I think conceptually you misunderstood something. It's not that you can't reference 3 levels deep. It's about unnesting is for arrays. What you did @4:54 with referencing into the second level is because that's actually a struct. You can see that in the schema. REPEATED means Array, RECORD means struct. In general what happens though that you have an array of structs. I think that's why you came up with the idea that the 3rd level needs to be unnested. I'm just leaning big query as well. So correct me if I'm wrong :)

Awesome video! Thanks for the good work!

I have a question. Why didn't you unnest Totals. It's also a record. Why unnest only hits. What's the difference?

Hey can you write unnest query that will flatten nested array or array inside array as well.

I want to hug you. Thank you.

Hello Thank you for the course, i wanted to unnest traffic but the error message said it need to be a string. I wanted to know the difference between hits and traffic is because hits is repeated not nullable?

What's the difference between CROSS JOIN and ","? It'll get different results? Or it is just another way to do the same thing?

how to handle this error. new to bigquery. please help. error : Column name name is ambiguous at [2:1]

No need to perform a join on nested data, you can just select from unnest.