Hi, I use metabase v0.38.2 with BigQuery. I can´t find the answer here but it seems there is a limit of rows. When I unpivot my table it definitely does not show all rows and when I then group them back together I am loosing data.
Any ideas how I can solve that? right now I use UNNEST(fhoffa.x.unpivot()) to unpivot the table, but there might be better ways to do that?
Thanks 
Hi @EvaS
There's a hardcoded limit of 2,000, 10,000 and 1 million rows, depending on if you are viewing a unaggregated (or SQL) question, an aggregated question, or exporting results.
See this issue and all the referenced issues:
https://github.com/metabase/metabase/issues/4564 - upvote by clicking 
on the (related) issue
1 Like