Having trouble with Shopify nested tables


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?


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.