I'm new to logstash and using the latest version. I have a config file now where I've defined my input/output and it pulls data from a single SQL Server table successfully and populates my index in elasticsearch. Now I want to pull in some child records and I'm a bit confused on how to setup the config file(s)
If I want to pull in child records can I do this in the same config file or do I need to create an additional config file that pulls the child records and then in that config setup the reference to the parent? I guess I'm trying to determine can this all be done in a single config or do I need to first load the parent records in one config file, and then in another config file load all child records and at that point map them in logstash config to the parent field?