I have the ELK stack installed and all three are communicating correctly. I'm trying to get logstash to query a 'mysql' database. My query contains joins from multiple tables. Can we used joins using “statement” or “statement_filepath”?
If I have written my sql join query in one of the .sql file and provides that filepath to “statement_filepath”, will this work?
Thanks & Regards,