Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Lookr - Override 5000 row limit

  • 5 January 2017
  • 19 replies
  • 10184 views
D

Hi All,


When using the lookr R package, is it possible to override the 5000 row limit when using the run_inline_query function?


Thanks,

Dean.

19 replies

Morgan
Rank
Userlevel 3
Badge

Hey Dean!


To avoid the row limit, you can simply not specify a row limit parameter in the API call! This does require that you have the “download without limit” permission in your user settings. Let me know if you have any questions!


Morgan

A
Userlevel 2

This just made my day.


AK

D

Thanks Morgan.


I have searched for the ‘download without limit’ option but i am unable to find it.


Where would I find this option?


I am using version 3.54.


Regards,

Dean.

sam
Rank
Userlevel 5
Badge

Hey @deancarr, this is a permission for a user. You can find it in the Admin > Roles > Edit Role panel, where you’ll get options like this:



Let me know if this helps!

D

It is working!


Thank you Morgan & Sam.


Best Regards,

Dean.

B

Hi,


Is there a way to override the 5000 row limit when using the Looker UI? Not only for downloading the data, but in general for the data being displayed in Looks? I’d really like to sort on row totals, but am prevented by my data results returning more than 5000 rows.


Cheers!

William_Lane
Rank

@barend_l There isn’t a way presently to allow more then 5000 rows for UI explore queries. The Limit is there to protect the browser from memory pressure. I will highlight your use case to our product team though. If there’s any further information relating to your request, please do let us know by hopping on chat or emailing us here -> help.looker.com

B

Hi @William_Lane,


Thanks for the reply! Perhaps it is possible to have it optionally removed like with the API calls.


Cheers!

William_Lane
Rank

Thanks @barend_l I’ll chat to the product team for you on that one

H

HI Everyone…


Is this sorted out or resolved?


I am facing issues with this.


Thanks,

Harika.

brecht
Rank
Userlevel 4
Badge

Hi Harika,


For API calls without limit (ie. streaming), you can leave the parameter empty. From the UI, Looker supports a row limit of up to 5000 and recommends a column limit of 50 or less. If you need more than 5K rows, consider a csv or other type of download. Depending on your database (will it stream?), you can set it to ‘unlimited results’ or a custom row limit with a maximum of 100K rows.

H

Hi Brecht,


I didn’t get you can you please explain in breif,

I have below 2 queries:



  1. In table chart am able to see only 50 rows.

  2. When i create a look, the sql runner is limiting it to 5000 rows.

    Could you please help me out with this.


Regards,

Harika.

brecht
Rank
Userlevel 4
Badge

@Harika, Looker supports a row limit of up to 5000, the same goes for the table visualisation as well as results through SQL runner. This is to avoid browser performance issues with big result sets. If you need more than 5K rows, consider a csv or other type of download.

H

But my row limit is limited to only 50 rows in table report.

can i know the reason, If i download that to csv, am able to get only 50rows.


Regards,

Harika.

S
Rank

Hi @Harika, in order to debug what is happening in your case, we need more info on this. Could you please send an email to help.looker.com with more details on that specific query, or come to our chat support? From there we could help you more.

Morgan
Rank
Userlevel 3
Badge

Hey guys,


Just wanted to provide a correction here:

At this time, leaving the row limit blank in an api call will not give unlimited results. The best way to do this is to put a massively large row limit in the API call. Apologies for any confusion!

G

Is there a limit to how “massively large” this row limit can be? i.e. can I just make it 1,000,000,000?

chris.seymour
Rank
Userlevel 3

Hey @gabriel,


Yes, you could put in 1,000,000,000 for the row limit, but keep in mind that very large downloads may strain your instance’s resources. I would recommend testing with smaller row limits first to make sure that your instance can handle a download of this size.

K

Hi all!

 

any updates on that?

 

thanks!

Reply


Terms of Service