View the original community article here
Last tested: Oct 1, 2019
Queries that don't pass the streaming test can't be downloaded with an unlimited row limit.
There was a legacy feature that allowed this but it was completely removed in 5.4
You can read more about how this legacy feature worked prior to 5.4 here: https://community.looker.com/general-looker-administration-35/legacy-feature-allowing-unlimited-downloads-looker-4-14-4987