Variables with more than a million rows

Grafana
1

Hi,

Grafana 6.4.1, MSSQL.
I’m new to Grafana and I’m having problems adding variables to my dashboard (the dropdown filter).

When I use a variable from my smaller table, it works fine. But when I try to add a variable from the table that exceeds a million rows, it shows this error:
“Templating
Template variables could not be initialized: query row limit exceeded, limit 1000000”

I’ve already tried turning the selection options on and off, but nothing changed. Also, I’m not using Regex. Am I doing something wrong or Grafana doesn’t really support variables with more than 1M rows?

1 Like
2

AFAIK no it doesn’t but it is a good feature request, lazy load and dynamic cursor handling in tables :wink:

1 Like
3

Don’t show me more than 500 rows, Where config this?

4

Hello Bruna!

I was also having the same problem and I came here to your post and after reading it came the idea of limiting the output, which in my case solves the default grafana limitation. I need to create 50 variables, so I limited the query to 100 and got the expected return!
Here’s the print:

image
image1402×945 84.5 KB

5

For any others searching about this limit of 1000000 rows, a new configuration values was added in 8.2.0 to allow modifying the limit.

Search for row_limit on this page: