Im new in Elasticsearch.
I have a project to collect syslogs from some servers using custom grok filter.
I can write different logs to different indexes and works fine.
Kibana reporting is a great tool, but my goal is to use SQL for PowerBI as reporting.
My main issue is that using REST API only get 10000 rows.
Is that possible to use another DB engine with Lucene like MariaDB and export some data from ELK to MariaDB in the same server?
How i do that? Off course without the limit of rows, because at this time i have some issues with limit rows, i want all data from one day.