Import JSON String data as a Flat table

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

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).

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

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

What does an event look like on stdout?

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>"}

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