How to create dimension from an array/struct in your table?

[natesam]

Hi all, I am relatively new to looker and have been learning my way on how to best utilise this platform. I currently have a requirement that needs me to extract a field from within a struct and an array. 
So, it is my understanding that you can extract a field by defining its path within the sql parameter of a dimension. 
For eg.

dimension: example {

type: string

sql: ${TABLE}.example[1].B ;; -- to extract a field within the array

}

At the moment, the only way I can think of doing this is by creating a derived table that unnests the array and join it to my explore to access the fields in question. 

I would like to know if there is a way that I can use in order to achieve this using the sql parameter of a dimension.

Thanks in advance.

-Nate

[Dawid · Accepted solution]

Have a look at this article. It should help: https://help.looker.com/hc/en-us/articles/360023638874-Nested-Data-in-BigQuery-Repeated-Records-