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-down...
This content is subject to limited support.