CSV file with JSON field where the JSON field is bigger than 32K characters

[Areksoo]

I have a CSV file which has a few fields like ID (PK), and other IDs (FKs), then a massive JSON field, then a few more fields after that.

My concern is how can I read that massive JSON field if it's over the 32,767 bytes limit?  The next step after reading it in is parsing the JSON field.

I am able to parse out the JSON when I don't read in the records over the limit.  It creates 19 tables!  

[Reeza]

Yeah, it's likely in a relational type format that you'll have to link but unfortunately JSON doesn't have defined structure. It's curse and benefit at the same time.