How to keep Bigquery Structs

[carlosavendano]

Hi everyone,

I have some tables in BigQuery with Structs (nested data); for example, I may have 5 rows with the same ID but with some columns with different values, so I consolidate to have all the info for the same ID within the same row, having some columns as nested, keeping the 5 different values in the nested columns.

It works fine in BQ, but when I try to create views in Looker from these tables, I see that it makes an unnest of the data, so I get to the original point where I have 5 different rows instead that just 1 nested row. I have checked the doc and it seems like the proper behaviour: https://cloud.google.com/looker/docs/best-practices/how-to-model-nested-bigquery-data-in-looker

So Im wondering: is there a way to keep the table with structs, as we have in Bigquery? Since I dont want to unnest it and have different rows with same ID, but to have just one row per ID but each row containing as many nested rows with that ID as exist.

Is it possible, do you know of any workaround?

Thanks in advance