I want to use the Variable as filter, My targer Database is Redshift while appling it to pannel quary its giving error of quarry limit exceeding 100kb How to resolve this also any alternate
Variable Quarry
SELECTDISTINCT serial_number
FROM charger_uptime_summary
WHERE provisioning_status ='PROVISIONED’AND network_status =‘INSTALLED’
AND serial_number LIKE ‘%search_term%’
This is not something you can control in grafana:
you could consider breaking your query up into ranges of serial numbers, and then combining them ?
Serial numbers are in count 40k making variables in chunks considering ranges then variables counts will be much more … any nested variable supported in grafana ?
|
Harsh Sharma |
|
Assistant Manager NOC |
|
|
|
C: (657) 999.6495 |
What do you get when you run that query outside of grafana, in a red shift query tool
