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.
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.
Hi all!
any updates on that?
thanks!
Hey
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.
Is there a limit to how “massively large” this row limit can be? i.e. can I just make it 1,000,000,000?
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!
Hi
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.
Hi Brecht,
I didn’t get you can you please explain in breif,
I have below 2 queries:
Regards,
Harika.
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.
HI Everyone…
Is this sorted out or resolved?
I am facing issues with this.
Thanks,
Harika.
Hi
Thanks for the reply! Perhaps it is possible to have it optionally removed like with the API calls.
Cheers!
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!
It is working!
Thank you Morgan & Sam.
Best Regards,
Dean.
Hey
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.
This just made my day.
AK
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.