I'd like to set up a parameterized query. I configured my logstash.conf to query my Oracle database. My table has a
REF_DATE field valued with a date
I need to make the following query:
`SELECT COUNT (*) FROM MY_TABLE WHERE REF_DATE = <TODAY_DATE>`
This query will be executed one or more time every day and
<TODAY_DATE> will be change every day.
I tried to use the
:sql_last_value parameter but I did not reach my goal.
Is it possibile to configure
<TODAY_DATE> into logstash.conf or sending this parameter from kibana tool?
Could you help me please?