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.
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.