On February 5, 2024, NRQL result limits increased from 2,000 to 5,000 results. This increase lets you pull even more data with the LIMIT
clause when you create NRQL queries, dashboards, and more.
- This change also affects the
LIMIT MAX
clause, increasing posted results from 2,000 to 5,000. - If you have an existing query that uses the
LIMIT MAX
clause, your results now reflect the 5,000 limit, assuming the underlying data is populous enough. - Some existing queries that successfully posted results with
LIMIT MAX
may fail. Larger limits can cause timeouts, or result in failure due to complexity. - You can use
LIMIT 2000
instead ofLIMIT MAX
to only display 2,000 results.
This change won't affect existing queries if they lack a LIMIT
clause, use default result limits, or specify an explicit result below 2,000.
What do you need to do?
Existing queries using LIMIT MAX may return more data than before. This could potentially slow down dashboards or reports that use those queries.
To avoid unintended changes, update any queries using LIMIT MAX
to specify LIMIT 2000
by February 5th. This will ensure they continue to behave as expected after the limit increase.