When downloading queries, some queries could require large amounts of memory.
When downloading all results for some types of queries, the amount of memory required could cause performance issues, even crashing an instance. The All Results option is disabled for users with download_with_limit permissions but other users could download all results even for queries that have memory-intensive characteristics.
Starting in Looker 4.14, you can prevent these queries by turning off the Allow unlimited downloads that might crash Looker legacy feature. When the legacy feature is off, the All Results option is disabled for queries returning more than 50,000 rows in situations where the rows need to be stored in memory. This includes queries returning more than 50,000 rows with one of these memory-intensive characteristics:
If All Results is unavailable for a query, users can still select the Custom Limits option with a limit of up to 50,000 rows. Starting in Looker 4.14.13+, the download UI limit has been increased to 100,000 rows (which applies whether or not the legacy feature is enabled). If you know that your instance has been provisioned to be able to export more than 100,000 rows of unstreamed results, you can further increase that limit with the
--max-unstreamed-limit startup option.