Indexing PostgreSQL Database,schemas, tables and rows in Elasticsearch


(Kaushal Shriyan) #1

Hi,

I have a question regarding indexing PostgreSQL DB data. I am still finding it hard to understand the concepts of ES indexing, type, and document terminologies.

https://www.elastic.co/guide/en/elasticsearch/reference/current/glossary.html#glossary-text

In Postgresql DB the data is normalized. We have Database,schemas, tables and rows. I am not sure about ES terminologies to be applied to PostgreSQL DB data structure.

My question is which PostgreSQL DB data structure (Database, schemas, columns or rows) to be indexed for searching data in ES Sink. I am confused to correlate with the PostgreSQL DB data.

Any sample examples if you can provide me to help me understand the application of Elasticsearch indexing and document IDs?

Thanks in Advance.

Best Regards,

Kaushal