Hello,
Scenario :
I have a database in mysql below is the structure :
JOBID | Wokflow | Ingest | Formula | Load | modification_time | insertion_time |
---|---|---|---|---|---|---|
1 | Pipeline1 | Completed | Completed | Completed | 2020-07-18 17:12:35 | 2020-07-18 16:01:08 |
2 | Pipeline2 | Completed | Completed | Ready | 2020-07-18 17:14:32 | 2020-07-18 16:01:09 |
3 | Pipeline3 | Completed | Completed | Completed | 2020-07-18 16:01:09 | 2020-07-18 16:01:09 |
4 | Pipeline4 | Completed | Completed | Completed | 2020-07-18 16:01:09 | 2020-07-18 16:01:09 |
5 | Pipeline5 | Completed | Completed | Ready | 2020-07-18 16:40:17 | 2020-07-18 16:01:09 |
Output:-
I want to create an exact replica of the above table using Kibana Data Visualization
Also if the Ingest/ Formula/Load Field Status changes it should Reflect
Approach what i have applied is :
Similarly for other fields created top Hit which gives me updated data visualized but the desired output scenario(described above) is not achieved.
Below is my logstash file
Need an immediate help on it.
Thanks in Advance !