PostgreSQL foreign data wrapper for Elasticsearch
esfdw is a PostgreSQL foreign data wrapper for Elasticsearch.
Elasticsearch is widely used for document and log data storage, in particular as part of the ELK stack. esfdw allows PostgreSQL to be used as a query engine for data stored in Elasticsearch. Use cases include:
- Writing SQL JOIN queries against Elasticsearch documents and letting the PostgreSQL engine do the heavy lifting
- Running window functions on data stored in Elasticsearch
- Applying PostgreSQL aggregations that do not currently have a native Elasticsearch equivalent
esfdw depends on Multicorn, a PostgreSQL extension for writing foreign data wrappers in Python.