title: Create a kibana dashboard with data from 50 tables in database
body: <p>I have 50 tables that have data related to each other. 
  Usually if there are only 2-3 tables, we create SP to join all tables and use the output to create a single index for elastic search and then kibana.</p>
  
  <p>But with 50 tables, that will mean hundreds of columns for the SP output (and each table has 10,000-1,000,000 rows), SP doesn't seem a good way.</p>
  
  <p>I tried to create 50 index with similar name, and then use index pattern. But when creating dashboard form index pattern, it seems that there is actually no 'join' feature there. </p>
  
  <p>Here are 2 sample table structures:</p>
  
  <p>Table1 has: Departmentid, department address, deparment name
  Table2 has: employeename, Departmentid, employeeage</p>
  
  <p>So expecting these 2 tables to join together with 'Departmentid' as the key. Remember that we have 50 tables, and lots of data from each table.</p>
  
  <p>Any suggestions?
  Ella</p>