05-25-2022 01:01 AM
Hi all, currently we have a JSON with thousands of objects as following:
{[
{id:1,
Name: a},
{id:2,
Name:b},
{id:3,
Name:c}…
]}
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.