We have a pipeline with a SQL bulk upload snap in it.
Here is our input:
ID: 1
JSON : {"address: 1234 no where”}
We insert several hundred of these into a SQL DB into a table with
ID,JSON
Create SQL:
CREATE TABLE [dbo].[test_json_inc](
[id] [bigint] ...