All Collections
FAQs
How to use 'STRUCT' field types in Lightdash.
How to use 'STRUCT' field types in Lightdash.

STRUCT or nested fields used in Lightdash.

Katie Hindson avatar
Written by Katie Hindson
Updated over a week ago

One of our community members uses dbt and Lightdash with BigQuery.

Some of the fields that they have in their project are STRUCT data type so they can define nested fields. They found a way to access nested fields of STRUCT on Lightdash using additional dimensions.

This article goes into more detail on how you can define dimensions in Lightdash for nested fields: https://yu-ishikawa.medium.com/unlocking-nested-fields-accessing-struct-data-in-bigquery-with-lightdashs-additional-dimensions-6593e139561b

Did this answer your question?