Building a request using schema name selected in a variable

Grafana PostgreSQL
1

  • With Grafana 9.4

  • I use a variable to select the schema name for my request

  • trieed this

select * from $_schema.mv_test_one

or

select * from ${schema:sqlstring}.mv_test_one

  • it is not working

  • I was expecting the request was able to use the variable

2

Welcome

What is the datasource?

3

Well, at the moment this post is in the topic PostgreSQL, what is your guess?

1 Like
4

I would go with dynamic sqlnwith exec statement

5

Ha, waste too much time on it…

It is as simple as:

select * from ${schema}.mv_test_one

where schema is the variable name.

1 Like