Elastic/Kibana data exportaion (over 1b hits)

Elastic Stack Elasticsearch
2

Hi @yzaritskyi,

Welcome back. There is a 10MB limit by default for exporting from Kibana. It can be configured via the xpack.reporting.csv.maxSizeBytes setting in kibana.yml for your cluster as per this thread . But I would tread carefully there as it can impact performance if set too high.

This thread gives a couple of options that you could try, including:

  1. Writing a script using a language client and a CSV utility, such as Python. There is a StackOverflow thread here that shares that example.
  2. Using Logstash with an Elasticsearch filter processor and the CSV output plugin .
  3. Split your query into multiple to export the records across multiple CSV files.

Let us know if any of those options work for you.

1 Like