Download without Row-limit

[sahithi_k]

How do we remove the custom row limit in the downloading limit. We tried this setting - 

We set the download_without_limits permissions on the groups that our uses have.

But this didn't work. Could you help us to resolve this?

[GavinW]

You cannot increase the custom row limit above 100k rows from the front end of Looker because doing so brings risks - when you download results with table calculations or merged results, or on certain databases (e.g. Teradata), Looker needs to bring the entire result set into memory to perform post-query processing before passing it on to the user. If users do this with massive result sets, they can slow the instance to a crawl or even crash it. So if you want to increase this limit, you would need to speak to Support and ask them to have the change made on the back end.

However, if your database supports streaming of results, and your queries don't have anything requiring post-processing (see details here) you should already be able to download unlimited numbers of rows for those users who have download_without_limits.