Insert data to index via xpack SQL || elasticsearch

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.

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.

1 Like

Thanks For the reply. It helps a lot.