tablename as parameter

[Tedigom]

Hi, I'm facing an issue using parameters

I want to use parameter after FROM clause in my query ( using tablename as a parameter),
and I got an Error "invalid table name".

ERROR - query-exporter - query "kafka_unpublished[params0]" on database "oracle" failed: (cx_Oracle.DatabaseError) ORA-00903: invalid table name

Is there any method allowed me to use parameter after FROM clause?

Installation details
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
query-exporter 2.8.0 ( docker )

my config is

queries:
  kafka_unpublished:
    databases: [oracle]
    metrics:
      - kafka_unpublished
    sql: |
            SELECT COUNT(*) AS kafka_unpublished, 'Topic01' AS topictest FROM :param1 GROUP BY del_yn
    parameters:
      - param1: TABLE01

[albertodonato]

It's currently not possible to specify the table name as parameter. Parameters can only be used where literal values are allowed

[chrisulbrich]

This would be a useful feature for me, too.
I've got many tables on which I want to execute the same query.

[hypePG]

+1

any chance we could implement that in a coming release? i could offer my help aswell :)