BigQuery row limit?

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 :slight_smile:

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: - upvote by clicking :+1: on the (related) issue

1 Like

thanks @flamber! will have a look!