I've successfully uploaded 10 CSV file as 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 in elastic. 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?
my main goal is to make reports or dashboard with Kibana
Elasticsearch is not a relational database.
Have a look at Join field type | Elasticsearch Guide [8.11] | Elastic
We don’t recommend using multiple levels of relations to replicate a relational model. Each level of relation adds an overhead at query time in terms of memory and computation. For better search performance, denormalize your data instead.
That's indeed the best option.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.