Hello everyone,
I am trying to execute a query thru jdbc input plugin and I need to generate a unique ID to pass in my stored procedure to identify my "flight", my single execution.
Is it possible?
The parameters passed by the jdbc input will be static, they cannot change for each execution.
If you want the SQL query to be run on a schedule and have a parameter change for each execution then you may be able to do it using a heartbeat input to set the schedule, then a ruby filter to generate the unique id and store in a field under [@metadata], then use a jdbc_streaming filter to run the SQL query.