Insert data to index via xpack SQL || elasticsearch

Elastic Stack Elasticsearch
1

Hi Team,

I am trying to create an index in Elastic using the output of the following

  1. Elastic SQL i.e. using Xpack

  2. Elasticsearch aggregation (through the translate option in Xpack SQL)

I searched a lot but couldn't find a breakthrough can you please guide and help me with the options available for solving this issue.

Thanking you in anticipation.
Regards
Suryadeep

2

Hi @suryadeep_tiwari,
I don't think I understand the issue you have.

Judging by the title of your post, the answer is "no" - you cannot use ES SQL to insert data into Elasticsearch. ES SQL is only for querying/searching data.

3

Thanks For the reply. It helps a lot.