# How to make changing parameters in jdbc input?

**URL:** <https://discuss.elastic.co/t/how-to-make-changing-parameters-in-jdbc-input/93857>\
**Category:** Logstash\
**Created:** [July 20, 2017, 2:56am UTC](https://discuss.elastic.co/t/how-to-make-changing-parameters-in-jdbc-input/93857 "2017-07-20T02:56:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TaurusD](https://avatars.discourse-cdn.com/v4/letter/t/a88e4f/32.png) [@TaurusD](https://discuss.elastic.co/u/TaurusD)\
**Post date:** [July 20, 2017, 2:56am UTC](https://discuss.elastic.co/t/how-to-make-changing-parameters-in-jdbc-input/93857/1 "2017-07-20T02:56:19Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 17, 2017, 2:56am UTC](https://discuss.elastic.co/t/how-to-make-changing-parameters-in-jdbc-input/93857/2 "2017-08-17T02:56:30Z")

</div>

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