JDBC Input Plugin use different input in one single SQL query

Elastic Stack Logstash
1

Hello,

I have data in two different databases. In database 1 there is products details and in database2 there is metrics related to these products.

Is it possible with the JDBC input plugin to have as the output a single Document with information from database1 with information from database1 injected into it ?

product {
id: 1
name: "test",
metric: {
product_id: 1
{all the metrics for product_id 1}
}
}

2

You might be able to read from one database using a JDBC input filter and the enrich using either a jdbc static or jdbc streaming plugin against the other database. This is discussed in this webinar.

3

Nice, jdbc streaming is what I needed, thank you