I am planning to use some spatial quaries of postgis by importing my JSON format data into a database. It seems that postgres queries-related nodes are still under construction. So, I only want to use Knime to enter my JSON file into PostgreSQL database tables, so later I can use Pgadmin for spatial queries.
I am not sure how I should set the DB Insert node to not face errors in the below:
I have exactly set my nodes based on this topic, but it seems that the JSON file I have is causing issues with this setting.
If I run the flow with some data generator and table to JSON node, the flow is running, but I face this error when it read my JSON file.