Is it possible to write the output data of an SQL query result back into a new index in Elasticsearch?
My use case
I have two indices in our Elasticsearch cluster and have to perform JOIN operations to denormalize it but after that I want to write the output to a new index to query it later. Is the sinking possible? Something on the lines of how you can write the output of a KSQL query on Kafka Streams back into a new topic in Kafka.