Import JSON String data as a Flat table

Elastic Stack Logstash
1

Hi
I imported Data from SQL server into elastic using Logstash jdbc plugin. The data contains a Varchar(4000) element which contains Json string in it. Is there any way that I can take that data in JSON format and parse it as individual elements into an index using Logstash

2

I suggest a json filter.

If that does not work then please show us a reproducible example of data that gets a _jsonparsefailure (with element names and values sanitized as necessary).

3

So I did try a json filter and below is my conf file

image
image.png1155×571 62.1 KB

There were no errors when I ran the logstash conf . But when I see the index created I see that the target field was not created . WHat am I missing

4

What does an event look like on stdout?

5

Don't see much it just prints the json strings from the table and in the end
[INFO ] 2019-06-19 22:27:05.584 [[main]-pipeline-manager] pipeline - Pipeline has terminated {:pipeline_id=>"main", :thread=>"#<Thread:0x4a43b827 run>"}