Logstash jdbc string column value in sql. how to split individual field and value

Elastic Stack Logstash
1

sql column value concatenated in {"ID":"P0001","Name":"sam","Createdby:124","Createdtime":"157312334321"}
In the above line is my sample data in one clolumn value of sql table

how to split this column to individual field in logstash and i
like individualy ID ,Name,Createdby,Createdtime in discover dashboard in kibana

Help me,
Saravanan R

2

Use a json filter.

3

Iam use it bro but it cant work in oracledata to logstash
kv {
source => "value"
field_split => ":"

4

A kv filter is not a json filter.

5

im beginner so can you please give that code for filter