Export aggregated reports into Postgres

[tmslara.a (Tomás Lara)]

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,

[stephenb (Stephen Brown)]

Hi @tmslara.a

@tmslara.a

Or should I write a script?

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.

@tmslara.a

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.

Yes that is correct.

[tmslara.a (Tomás Lara)]

Thank you. I'll write the script then.