I just want to understand how it really works in deep.
In my case, I have a table where I have a datetime column last_modified_date.
I kept this as tracking column and I want to achieve:
- If the row is getting updated in SQL, tracking column will also updated. In such case the document should also update in elasticsearch if exists with the same ID. It will not create a duplicate document if the same ID already exists in elasticsearch.
Correct me if I am wrong.