You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Our use case is to have a predefined , parameterized, SQL script on clickhouse server side; and the only info we need from grafana is those variables. For some context, clickhouse has this predefined script capability [1]
As a simple example. on sever side we have
<query>
SELECT * FROM table
WHERE name IN ({param1:String}
</query>
and on grafana-clickhouse plugin side, we take grafana variables and plug in to data source url as params:
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Our use case is to have a predefined , parameterized, SQL script on clickhouse server side; and the only info we need from grafana is those variables. For some context, clickhouse has this predefined script capability [1]
As a simple example. on sever side we have
and on grafana-clickhouse plugin side, we take grafana variables and plug in to data source url as params:
[1] https://clickhouse.com/docs/en/interfaces/http#predefined_query_handler
Beta Was this translation helpful? Give feedback.
All reactions