I am curious if anyone has used the
jdbc_static (or streaming) filter plugin to query and cache Elasticsearch data?
I am aware of the
elasticsearch filter plugin, but that plugin does not cache data. We store some (mostly) static data in Elastic for lookups, but don't want to have to query for each and every document. The
jdbc_static plugin caches the results, but requires a jdbc connection string.
I know Elastic supports SQL queries at the REST endpoint, but the jdbc jars require a Platinum license?
Seems real strange that you need a platinum license to utilize a feature built-in on the basic license if you just hit a different endpoint...
We are trying to stay away from Translate and file-based dictionaries. Any other ideas?