my task is to put our (in this case MySQL) tables into elastics search.
I made a config for one table and it worked really well. The problem is, that I have not one or two tables, but over 100.
So my idea is to index all and schedule them with only one config file using the statement_filepath to go over all statements for each table.
To get the output right, I thought I can use the metadata from each table to generate the index, document_type and document_id. For Example:
index => " TABLENAME + 's' "
document_type => " TABLENAME "
document_id => "TABLE PRIMARY KEY"
Is this even possible or is there even a better solution to put all of my data in ES?
Thanks for your help!