Hello I'm new to ELK. Question -
How do I use different index when importing tables from DB using logstash. I have used multiple JDBC input for different tables and separate output for each table in logstash. Logstash shows correct last timestamp for each table/input, but Kibana/Elasticsearch display all combined data for all tables.
Code is like this:
input {
jdbc {
table1
}
jdbc {
table2
}
filter {
mutate {table1_col}
mutate {table2_col}
}
output {
elasticsearch {
index => "table1"
}
elasticsearch {
index => "table2"
}
}