Can we perform joins between two indicis of elasticsearch in kibana?

Elastic Stack Kibana
1

I have 500 indecis in elasticsearch and 1 indecis that is created from postgres datasource data. Now I want to perform analytics in kibana on this data. Analytics data will be created once we will perform join between 500 indecis with 1 indecies of postgres data. I mean i want to perform join of 500 indecis with postgres data contained 1 indecis and want the updated column in 500 indices so that i can use newly updated 500 indecis in analytics in kibana.

2

Hello,

You need to look at https://www.elastic.co/what-is/elasticsearch-sql to see if it works out for you.

In Kibana - you can plugin the data source with SQL query in Canvas. https://www.elastic.co/blog/preview-of-sql-in-canvas-with-rashid-creator-of-kibana

Thanks,
Bhavya

3

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