>The SQL server is always going to be our source of truth, probably.
ES is not supposed to be your source of truth.
ES is not supposed to be your source of truth.
https://discuss.elastic.co/t/elasticsearch-as-a-primary-data...
Any changes to the schema, such as switching fields between indexed/not indexed/stored/not stored, requires reimporting the data to populate those fields, data which you're not likely to have if it was your primary store.
1. https://www.elastic.co/guide/en/elasticsearch/reference/curr...
2. https://www.elastic.co/guide/en/elasticsearch/reference/curr...