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
Solved! Go to 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-
Have a look at this article. It should help: https://help.looker.com/hc/en-us/articles/360023638874-Nested-Data-in-BigQuery-Repeated-Records-