Name: kibana-relational-filter
Owner: CERN Operations
Description: Kibana Relational Filter
Created: 2017-03-01 13:22:37.0
Updated: 2018-04-24 08:27:10.0
Pushed: 2018-04-24 08:29:47.0
Size: 71
Language: JavaScript
GitHub Committers
User | Most Recent Commit | # Commits |
---|
Other Committers
User | Most Recent Commit | # Commits |
---|
This is a kibana plugin to create filters based on different indices. It creates a new visualization, the relational-filter, which can be included in dashboards. The visualization comes with three display options: a standard table, a drop-down menu or a multiple select.
Imagine any of the following scenarios:
All these scenarios are quite easy to solve with relational databases. The current approach to solve them with elasticsearch and kibana is to denormalize the data: create a single document type with the replication of all the information that might be needed. Elasticsearch does offer parent-child relation (see https://www.elastic.co/guide/en/elasticsearch/reference/5.2/mapping-parent-field.html), with the restrictions that both document types have to be on the same index. At the time of writting this plugin, Kibana does not support it.
This plugin offers a different alternative to do all these relational queries. The approach is to keep the two types of documents separate, even on different indices, and then create a visualization that will do the select on the first type of document, and apply the filter to the second.
Coming back to the examples, this would be the approach:a
And here you have a couple of screen shots of the first use cases:
This is the very first draft of the plugin. There are quite a lot of possible improvements, like: