My use case is:
- I need a timestamp from database A
- Then do a query on database B
- Then output the results of that Database B query
Which means a logstash file that (theoretically) would look something like:
input {
jdbc {
get the timestamp
}
jdbc {
Do the SQL that gets lots of data with the timestamp above
}
}
output {
elasticsearch {
spew the data from that second jdbc query
}
}
That doesn't work, of course, but it gives the idea of the use case. How can I make solve this scenario?