Has anyone else noticed a change with the row limit for the API for run inline queries? We used to be able to return all results with a null row limit, now it is auto generating a 5,000 row limit for a query. This worked up until 24.2 by leaving the row limit null, but I wasn't sure if anyone else noticed the change? This is a big change to not have any notice about. Tried reaching out to support but haven't had much luck in an answer.
Solved! Go to Solution.
Hey there. Have you seen this post? https://cloud.google.com/looker/docs/best-practices/row-limits-in-looker. The all results options relies on Looker's ability to stream results as well as some nuances in the document. Can you check if you run into any of those limitations?
Ah gotcha - the official way to do it (returning unlimited results) is using -1. Can you try this?
https://cloud.google.com/looker/docs/best-practices/row-limits-in-looker#api