# How Data scientist can use data stored in elasticsearch

**URL:** <https://discuss.elastic.co/t/how-data-scientist-can-use-data-stored-in-elasticsearch/241244>\
**Category:** Elasticsearch\
**Created:** [July 15, 2020, 7:50am UTC](https://discuss.elastic.co/t/how-data-scientist-can-use-data-stored-in-elasticsearch/241244 "2020-07-15T07:50:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![vero](https://avatars.discourse-cdn.com/v4/letter/v/e19b73/32.png) [@vero](https://discuss.elastic.co/u/vero)\
**Post date:** [July 15, 2020, 7:50am UTC](https://discuss.elastic.co/t/how-data-scientist-can-use-data-stored-in-elasticsearch/241244/1 "2020-07-15T07:50:53Z")

</div>

Hi,

I have a new project to do an IA project ( predictive maintenace). I'm looking for an architecture to store the data for the Data scientist. We hesitate between PostgreSQL or Elasticsearch.  
My proposititon currently is to use Elastcisearch as a Database. As my information, elasticsearch store data in a documents using indexes.  
My question, is a data scientist can use this data ? And how he can access on it ?  
I asked this question because usually I use PostgreSQL as a database, so a data scientist can access on a data because are stored in a tables. I would like to use Elasticsearch because it have many services like logstash to filter data, kibana to do a dashboards.  
So I'm looking for this subject, if I use elastcisearch as a database, how a data scientist can access on a data.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![defalt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/defalt/32/71379_2.png) [@defalt](https://discuss.elastic.co/u/defalt)\
**Post date:** [July 15, 2020, 7:57am UTC](https://discuss.elastic.co/t/how-data-scientist-can-use-data-stored-in-elasticsearch/241244/2 "2020-07-15T07:57:14Z")

</div>

Hi,  
you can access your data in many ways. Basically all the data is stored across the nodes. If you want to get data out you will have to run a query. You can run queries in Kibana, Postman, in your own programms and web applications. You will access elasticsearch over its IP and port. In the query you can define what you are looking for. You can search for timestamps, values, words, scentences, whatever. In the result you will get back all the data that matches the query.  
Links:  
[https://www.elastic.co/guide/en/elasticsearch/reference/current/elasticsearch-intro.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/elasticsearch-intro.html)  
[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-your-data.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-your-data.html)  
[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-search.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-search.html)

Cheers,  
defalt.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [July 16, 2020, 2:02am UTC](https://discuss.elastic.co/t/how-data-scientist-can-use-data-stored-in-elasticsearch/241244/3 "2020-07-16T02:02:40Z")

</div>

Elasticsearch has a SQL integration layer as well - [https://www.elastic.co/guide/en/elasticsearch/reference/current/xpack-sql.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/xpack-sql.html)

---

<div class="post-metadata">

**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\
**Post date:** [July 16, 2020, 8:32am UTC](https://discuss.elastic.co/t/how-data-scientist-can-use-data-stored-in-elasticsearch/241244/4 "2020-07-16T08:32:06Z")

</div>

This may be of interest too if Python is your thing

> **[Elasticsearch for Data Science just got way easier](https://towardsdatascience.com/elasticsearch-for-data-science-just-got-way-easier-95912d724636)**
>
> Eland is a brand new python module that bridges the gap between Elasticsearch and the data science ecosystem.

---

<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:** [August 13, 2020, 8:32am UTC](https://discuss.elastic.co/t/how-data-scientist-can-use-data-stored-in-elasticsearch/241244/5 "2020-08-13T08:32:08Z")

</div>

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