How to make changing parameters in jdbc input?

Hi, I'm using jdbc input plugin to import tables from SQLServer 2012 to ELK.
In my SQLServer DB, it will automatically generate a new table every minute with name XXXX_yyyyMMddHHmm (e.g. Blablabla_201707201023).

Now I hope to import one table every minute correspondingly using logstash automatically. I'm trying to add a parameter into my query statement to change the query table name according to time, like

statement => "SELECT * FROM :parameter"
parameters => { "parameter" => "blablabla_%{yyyyMMddHHmm}" }

well, something like that...

Is there anyone can help me point out what is the correct way to do that?

Thank you!

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.