Why does custom query have LIMIT 1048576?


I’m new to metabase, and also new to a company using it. I started to look at custom queries built by other analysts and found that they ended with LIMIT 1048576. The analyst concerned says they didn’t add the limit, so we’re trying to work out if Metabase would have added this automatically for some reason? We’re using BigQuery as the data warehouse if that’s relevant.



Hi @bnh
There’s a hardcoded limit of 1 million rows for downloads, and 10,000 aggregated rows, and 2,000 unaggregated rows.
https://github.com/metabase/metabase/issues/4564 - upvote by clicking :+1: on the first post
The Enterprise Edition will get options to modify several limits.