Google Cloud billing export to BigQuery

Google Cloud has the ability to export billing data to BigQuery. The schema has some columns named with a “.” which seems to confuse Metabase.

“project.id” and “project.name” are strings. and “project” is of the type “record”. Metabase only lists the field “project” which cannot be used in queries and returns “Field project from table is not a leaf field.”

It’s possible to write manual sql to query the field.

Any tips?

Relise that this might be what’s the issue here: How can I use BiqQuery’s nested fields