# Insert data to index via xpack SQL || elasticsearch

**URL:** <https://discuss.elastic.co/t/insert-data-to-index-via-xpack-sql-elasticsearch/185170>\
**Category:** Elasticsearch\
**Created:** [June 11, 2019, 11:05am UTC](https://discuss.elastic.co/t/insert-data-to-index-via-xpack-sql-elasticsearch/185170 "2019-06-11T11:05:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![suryadeep\_tiwari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/suryadeep_tiwari/32/44535_2.png) [@suryadeep\_tiwari](https://discuss.elastic.co/u/suryadeep_tiwari)\
**Post date:** [June 11, 2019, 11:05am UTC](https://discuss.elastic.co/t/insert-data-to-index-via-xpack-sql-elasticsearch/185170/1 "2019-06-11T11:05:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [June 13, 2019, 8:24am UTC](https://discuss.elastic.co/t/insert-data-to-index-via-xpack-sql-elasticsearch/185170/2 "2019-06-13T08:24:13Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![suryadeep\_tiwari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/suryadeep_tiwari/32/44535_2.png) [@suryadeep\_tiwari](https://discuss.elastic.co/u/suryadeep_tiwari)\
**Post date:** [June 13, 2019, 11:08am UTC](https://discuss.elastic.co/t/insert-data-to-index-via-xpack-sql-elasticsearch/185170/3 "2019-06-13T11:08:15Z")

</div>

Thanks For the reply. It helps a lot.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 11, 2019, 11:08am UTC](https://discuss.elastic.co/t/insert-data-to-index-via-xpack-sql-elasticsearch/185170/4 "2019-07-11T11:08:25Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.