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

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.5+10",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.5",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.5+10",
    "os.name": "Linux",
    "os.version": "4.14.158-101.185.amzn1.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "sqlserver"
    ],
    "hosting-env": "elastic-beanstalk",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.5"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-02-25",
      "tag": "v0.34.3",
      "branch": "release-0.34.x",
      "hash": "1a83edb"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

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.

1 Like

Is there any other option other than creating own version?

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

Thank you so much @flamber. :grinning:

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
image

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

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

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?

@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

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?

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

Yeah that’s what I mean :slight_smile:

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

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

Ok Let me check on this . In this below screen,
image
In ‘Previwe Pane’
image
I can see dowload option preview,
image

Could you please tell me what else pending?

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

@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

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

@turker.tunali Pretty sure this is the one: