How to export Kibana search query results to CSV file with more than one million records

[fymaterials (ATTN: Feng Yi)]

I used Kibana to query the index, and use export under resource tab to export query results. How can I export query results if there are million records?

[matw (Matthias Wilhelm)]

Hi

In Kibana you can export your data in Discover to CSV, what's the resource tab you're referring to?

Thx and best,
Matthias

[fymaterials (ATTN: Feng Yi)]

Yes, in discover, Click Share -> Click Export to CSV
But if the results has millions of records and resulting big csv file, it is over the discover export limit. Any solution to this?

Feng

[hocho]

Hello,

From what I know Kibana have a byte limit and is not based on number of documents.
I believe this can help you =>

Reporting settings in Kibana | Kibana Guide [8.11] | Elastic

Kibana Document download limit at 10,000

In advanced settings , there is no option to select the number of rows to be downloaded. By default , when i save a search and download it is still 10,000 documents.