Some databases (postgres, sql server, others) support native json columns. With postgres, there's a native jsonb type, with sql server it's a string type, that you can treat as json.
In any event, once you have the json in the database, one can then query it, e.g.: SELECT id,product_name, JSON_VALUE(attributes, '$.material') AS material FROM jsontest; So, here's my question: If you have a flow file that contains json, whats the best way to insert that into a database? The only thing I've thought of so far is if you have the json string {"material" : "plastic"} You then use a TEXT processor to turn that into {"attributes": {'{"material" : "plastic"}'} And then use a PutDatabaseRecord to actually write the entry. Is there a better, or more efficient way to do it?