Run Inline Query API Call - Row Limit

[n_davis]

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.

[Justine_L · Accepted 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?

[Justine_L · Accepted 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?

[n_davis]

Hi @Justine_L, yes we did see that post. The 5,000 inline query API results weren't limited before 24.2. So, a call with no limit previously returned all data. After 24.2 was released we ran into the issue with the limit in the API calls. 

[Justine_L · Accepted solution]

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