import a json file into sql using the wizard code example

Example 1: sql server import json

SELECT *
FROM OPENJSON (@JSON, '$.data.assets.parcels') 
WITH (id VARCHAR(7), 
		x INT,
		y INT,
		price INT '$.auction_price') -- new column name
)

Example 2: sql server import json

SELECT ISJSON(@JSON)