How to export elasticsearch raw data to csv

elasticsearch kibana elasticsearch-5 kibana-5 kibana-6
kumar picture kumar · Apr 18, 2018 · Viewed 7.2k times · Source

I recently started using elasticsearch database and kibana 5.6.9. I was able to export the visualization data to csv using kibana, but not the raw data.

Am in search of a method, where I should be able to export the raw data from Elasticsearch to a CSV file. Can I get some help regarding this. Thanks in advance.

Answer

cloudvyzor picture cloudvyzor · Mar 11, 2020

This is the possible way to export data from ElasticSearch to CSV:

  1. Make a snapshot (if doesn’t exist yet)
  2. Use esbackupexporter to convert the snapshot to zipped JSON files.
  3. Use lodpad to search (filter) the events you really need from these zipped JSONs.
  4. Then export to csv from logpad.

Related questions

How to retrieve unique count of a field using Kibana + Elastic Search

Is it possible to query for a distinct/unique count of a field using Kibana? I am using elastic search as my backend to Kibana. If so, what is the syntax of the query? Heres a link to the Kibana …

Read More
How to know elastic search installed version from kibana?

Currently I am getting these alerts: Upgrade Required Your version of Elasticsearch is too old. Kibana requires Elasticsearch 0.90.9 or above. Can someone tell me if there is a way I can find the exact installed version of ELS?

Read More
Logstash date parsing as timestamp using the date filter

Well, after looking around quite a lot, I could not find a solution to my problem, as it "should" work, but obviously doesn't. I'm using on a Ubuntu 14.04 LTS machine Logstash 1.4.2-1-2-2c0f5a1, and I am …

Read More