I did some tests with the jdbc_static plugin, and it is working fine, however it is not 100% clear to me how to use it in my pipelines.
Adding the jdbc_static block with loaders, local_db_objects and local_lookups in the configuration that will consume the lookup data, will not it load the memory every time a log/message arrives? That would be bad.
I'm assuming that the plugin is smart enough to load the data into memory when the first log/message is sent to the pipeline, and the following logs/messages won't load again, just consuming from memory. When the configured loader_schedule time is reached, then it will l load the data.
Is that right?