Having trouble with Shopify nested tables

#1

I was trying to use Metabase with BigQuery only to find out that nested tables are a problem. I read this article: https://www.stitchdata.com/docs/data-structure/nested-data-structures-row-count-impact but it didn’t quite explain what the solution was.

Does anyone have experience in dealing with the nested tables in BigQuery so that Metabase can properly read the data?

#2

Hi Tanner. I wrote a blog post that might help you get started on the right path. I found the trick was to write SQL code to build the data I want, then specify a native query in Metabase and paste in the SQL code. The code uses the UNNEST operator on nested data structures.