How can I use BiqQuery's nested fields

Hi.
In Google's BigQuery there is an option to nest fields (like json).
I can't see the leafs fields in metabase.
How is this kind of fields handled in Metabase?

I'm trying to do something like:

select parentField.childField, count(1) from table group by 1

Thanks

Hi @gluz, we don’t support using BigQuery’s nested fields from the GUI question builder yet, but you can always use the SQL interface to do anything supported by BigQuery.

We have a GitHub issue open to support BQ nested fields in the question builder: https://github.com/metabase/metabase/issues/2662

1 Like

Can you refer me to the documentation of the SQL interface?
I can find it.

Thanks

https://www.metabase.com/docs/latest/questions/native-editor/writing-sql

Any news on this? It would be awesome to query the nested fields on the GUI question builder.

@samuel.birocchi Go an upvote the issue by clicking :+1: on the first post:
https://github.com/metabase/metabase/issues/2662
We are looking into nested things in upcoming versions, but it's complicated and several months away.

The link is dead.

@KlodEckel https://www.metabase.com/docs/latest/questions/native-editor/writing-sql

1 Like