I know that it’s important to have indices. But, is it possible to set up Graylog not to create new indices? I want it to stop creating new indices. My goal here is to forward the Elasticsearch log to SQL server. Using only 1 table makes it easier to do that.
My advice would be to not make to large indices because this is the only option to drop data and handling big indices is more painfull than having small one.
Elasticsearch is better for store and search logs. Why would like to forward it to SQL?
Graylog won’t delete logs from elasticsearch, so if you want only one index you need to keep all logs for forever.
You also can search in ES without the index name, so I think it couldn’t be a limit of your goal.
Thanks for the input. I needed to forward it to SQL so I can create a good report using Power BI. Power BI supports Elasticsearch but not with the refresh. We want it to continuously refresh so that latest data will be available.