I cannot export the whole database into a csv file.
Open to any method. I've tried using the python tool: https://github.com/taraslayshchuk/es2csv/blob/master/README.rst
but I get: elasticsearch.exceptions.ImproperlyConfigured: Root certificates are missing for certificate validation. Either pass them in using the ca_certs parameter or install certifi to use it automatically.
I also have Kibana, but I don't think they support exporting the entire database.