Storing JSON in Database

Hi @nxfxcom,

Based on my experience, if you are dealing with large JSON files, it would be wise to consider MongoDB or DynamoDB instead of saving the whole thing into table cells. So, in case you need to access part of the JSON, you don’t need to call everything back and parse it locally, instead you just query for what you require. To work with MongoDB in KNIME, you could use the KNIME MongoDB Integration extension and for DynamoDB, we have KNIME Amazon DynamoDB Nodes.

Alternatively, PostgreSQL with JSONB type is also an efficient way of storing JSON.

3 Likes