Hi all, currently we have a JSON with thousands of objects as following:
We tried to use the PostgreSQL - Bulk Load, snap to load data into our database. I would like to ask that do we need to do any transformation before, or only the JSON Splitter is engouh?
Besides, if the “id” value, which is a unique constraint already existed, how to skip the insertion?
Thank you in advanced.