Data virtualization is good if you don't want to copy data around... not sure how that works with Elastic search though... u can read about data virtualization here :
I think some companies like Presto are doing it but not sure they support Elastic...I heard Gemini Data does you can check out their website it could point you in the right way: https://www.geminidata.com/
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.