Hi All,
I can able to get avro schema from json.
It could be look like below.
{
"type" : "array",
"items" : {
"type" : "record",
"name" : "AvroSchema",
"fields" : [
{
"name" : "Name",
"type" : "String",
"doc" : "Type inferred from 'S'"
},
{ "name" : "Age",
"type" : "int", "doc" : "Type inferred from '23'"
}
}
}
With help of that, i should extract fields(name & type) and create table in
DB from that schema.
Can any one suggest me the best way to create table in SQL Server from NiFi
based on avro schema?