# Creating Mappings for Index Interconnections in ElasticSearch: How to Establish Relationships Between Tables?

**URL:** <https://discuss.elastic.co/t/creating-mappings-for-index-interconnections-in-elasticsearch-how-to-establish-relationships-between-tables/350751>\
**Category:** Kibana\
**Created:** [January 10, 2024, 12:48pm UTC](https://discuss.elastic.co/t/creating-mappings-for-index-interconnections-in-elasticsearch-how-to-establish-relationships-between-tables/350751 "2024-01-10T12:48:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Neelesh\_Gupta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neelesh_gupta/32/130683_2.png) [@Neelesh\_Gupta](https://discuss.elastic.co/u/Neelesh_Gupta)\
**Post date:** [January 10, 2024, 12:48pm UTC](https://discuss.elastic.co/t/creating-mappings-for-index-interconnections-in-elasticsearch-how-to-establish-relationships-between-tables/350751/1 "2024-01-10T12:48:04Z")

</div>

I've uploaded 10 CSV tables to Elasticsearch to create a Kibana dashboard. However, since these tables are interlinked with foreign keys, they have been transformed into JSON (NoSQL) format. I'm now looking for guidance on how to establish mappings for relationships, such as one-to-many and one-to-one, similar to what we do in relational databases. What are the recommended approaches to achieve this in Elasticsearch?

main goal is to create Dashboard with Kibana

---

<div class="post-metadata">

**Author:** ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)\
**Post date:** [January 10, 2024, 5:12pm UTC](https://discuss.elastic.co/t/creating-mappings-for-index-interconnections-in-elasticsearch-how-to-establish-relationships-between-tables/350751/2 "2024-01-10T17:12:53Z")

</div>

Hello @Neelesh_Gupta,

You can explore [nested](https://www.elastic.co/guide/en/elasticsearch/reference/current/nested.html) and [parent/child](https://www.elastic.co/guide/en/elasticsearch/reference/current/parent-join.html) relation concepts, but there isn't a perfect way to handle this in Elasticsearch and it is expected that after uploading these files, you will have non-relational data because Elasticsearch is not a relational database. If your goal is only to create a dashboard with visualizations containing data from multiple indices “tables”, I would recommend creating a [data view](https://www.elastic.co/guide/en/kibana/current/data-views.html) (index pattern) that matches all these sources, comma-separated: index1, index2, index3…

Note: Elasticsearch has [different terms](https://www.elastic.co/guide/en/elasticsearch/reference/current/_mapping_concepts_across_sql_and_elasticsearch.html) for the way the data is organized.

I hope this helps!

---

<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:** [February 7, 2024, 5:13pm UTC](https://discuss.elastic.co/t/creating-mappings-for-index-interconnections-in-elasticsearch-how-to-establish-relationships-between-tables/350751/3 "2024-02-07T17:13:09Z")

</div>

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