Export aggregated reports into Postgres

Elastic Stack Elasticsearch
1

Hello,

I am indexing data into an Elasticsearch cluster (of one node) based on events associated with different devices, each identified by an ID. Many events can occur during the day. At the end of each day, I would like to obtain a report, for example, indicating the number of documents per device ID.

I know how to perform this operation inside Elasticsearch, using terms and count aggregations. However, I want to save these daily 'reports' into a Postgresql database. My question is, Is there any way to compute this 'report' and send/export it to a Postgresql database? Or should I write a script?

I checked a connector between ES and Postgresql, however, it seems to be used for importing data from SQL instead of exporting data into it.

Thanks in advance,
Best regards,

2

Hi @tmslara.a

I don't think there is an out-of-the-box way to do this; I think a script in your favorite language / Python would probably be the best approach.

Yes that is correct.

3

Thank you. I'll write the script then.

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.