I have a large json file which is irregularly structured.
*All top level elements are unique names like this:

I tried this:
SELECT *
INTO Json1
FROM OPENROWSET (BULK 'D:\SomeData.json', SINGLE_CLOB) as j
but get the exception: "Attempting to grow LOB beyond maximum allowed size of 2147483647 bytes."
However, this would work if I could import each of the elements you see into it's own row. I think my code above it trying to insert all data into one row, one column.
Then once each element is in a separate row I think I can read the json from there to finish the processing. Below is a sample of what the data looks like:

Can someone please tell me what the sql syntax is to import this file into a table where each top level element lands in a new row?
Thank you.