How can I change default row limits (currently it's 2000)?

flamber · June 29, 2020, 2:39pm

Hi @Timple
You would have to build your own version. The limits for 2,000 unaggregated, 10,000 aggregated and 1 million rows are currently hardcoded.

Timple · June 29, 2020, 2:42pm

Is there any other option other than creating own version?

flamber · June 29, 2020, 2:44pm

@Timple Currently no, but the Enterprise Edition will likely get options to change hardcoded limits.

Timple · June 29, 2020, 3:10pm

Thank you so much @flamber.

Timple · June 30, 2020, 7:33am

Hi @flamber. Built own version.

How to change this default limit in 'Admin Panel'. I couldn't find any option. I'm using v0.34.3

I don't want to use this pick limit option. Is there any other way?

flamber · June 30, 2020, 9:18am

@Timple Latest release is 0.34.4
You need to change the hardcoded values and build you own version.

github.com

metabase/metabase/blob/1befabcfb274031385b4c1e8b53035c82757078c/src/metabase/query_processor/middleware/constraints.clj#L5-L11


(def ^:private max-results-bare-rows
  "Maximum number of rows to return specifically on :rows type queries via the API."
  2000)


(def ^:private max-results
  "General maximum number of rows to return from an API query."
  10000)

Timple · June 30, 2020, 9:28am

You mean that, before building a new version, I’ve to change the default row limits. If so, Is there any other way to do after build?

flamber · June 30, 2020, 9:34am

@Timple Yes, change the source before building your own version. No, there’s no other way to change the limits, but the Enterprise Edition will get environment variables to change limits on multiple things - most likely from 1.36.0

Timple · June 30, 2020, 10:15am

Thanks for your help!

Need one more info

As you mentioned, I have modified my simple dashboard into Embedded dashboard but I couldn't find any download option with in dashboard but I can able to download with in question.

Did I missed anything?

flamber · June 30, 2020, 10:18am

@Timple There’s no download button for the dashboard, but for each card on the dashboard, when using embedding.

Timple · June 30, 2020, 10:19am

Yeah that’s what I mean

I didn’t see any download option for each card.

flamber · June 30, 2020, 10:21am

@Timple Then you’re likely not using Embedding, but Public Sharing or regular view of the dashboard.

Timple · June 30, 2020, 10:42am

Ok Let me check on this . In this below screen,

In 'Previwe Pane'

I can see dowload option preview,

Could you please tell me what else pending?

When I open that dashboard, I couldn't find any option like this.

flamber · June 30, 2020, 12:05pm

@Timple How are you opening that dashboard, when it’s not showing. I think you’re missing the point of what Embedding is:
https://www.metabase.com/docs/latest/administration-guide/13-embedding.html

turker.tunali · July 5, 2020, 3:46pm

Hello @flamber, where is the setting for 1 million row limit in the source?

flamber · July 5, 2020, 4:36pm

@turker.tunali Pretty sure this is the one:

github.com

metabase/metabase/blob/1899ad3e864f3cc38c83774114346b0d42f2de93/src/metabase/query_processor/interface.clj#L7-L12


(def absolute-max-results
  "Maximum number of rows the QP should ever return.


   This is coming directly from the max rows allowed by Excel for now ...
   https://support.office.com/en-nz/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3"
  1048576)

sanjeev · September 29, 2020, 2:06pm

Currently using Metabase enterprise edition v1.36.4. Is there any way to increase the row limits?

flamber · September 29, 2020, 2:16pm

@sanjeev Please use the support email, when using the Enterprise Edition. As of right now, no, there’s no way to configure this.

zoove · September 10, 2021, 8:21am

I'm evaluating Metabase for the purposes of some technical analyses within our team and we do see some use cases where it would be very useful to have more data visible.

Are there any considerations that need to be taken before preparing a custom build with limits changed? What is the rationale for this limit to exist at the level of 2000? I suspect it is because the graphing tool used by the front-end does not cope well with more data, and not because of some limitations of the back-end?

Thank you!

flamber · September 10, 2021, 8:48am

@zoove Everything will become slower if you raise the level. If you set it to 100k, then that will cause more load on the database and the network transfers too, besides how the user's browser will handle the many thousands of extra DOM objects.

If you have "infinite" database resource, network speed and unlimited browser memory+CPU, then you could likely set it to 1 million. But that's not the case in the real world.

It would be more interesting to figure out where you are hitting this limitation. Can you give examples?