We're thinking to add elastic to our product stack and we want to use it as a full text search solution and aggregations.
The problem is our data is very sensitive and our main data store is AWS MySQL RDS with encryption at rest.
We need to add to the elasticsearch only the non-sensitive columns including the main text column which is very sensitive, so I just want to index this column without storing the REAL data there. Only to have a pointer (id) to the real record in MySQL RDS.
I saw there are some discussions on using the _source = false feature. But, does it ensure that the original column data will not be saved in elasticsearch and will be never retrievable?
Any other solution?