"Unlimited Download" not possible in UI for unstreamable results

Knowledge Drop

Last tested: Dec 9, 2020

To reduce the amount of user initiated instance crashes, the ability for users to download unlimited unstreamable results has been removed from the UI since version 4.14.

Things you can do for the UI:

  • Make the query streamable (i.e turn table calculations into measures and remove pivots - check the streaming section on the What are all the Row Limits in Looker? article)
  • Select up to 100,000 rows in the custom download limit
  • Developer can set a custom maximum on the command line with --max-unstreamed-limit startup option.