Loading Entire content of JSON file using OPENROWSET (BULK) table-valued function, SQL Server will read the entire content of the file and insert it into SQL Server (Total Execution time = Time spent on Reading the full content of file + Writing the document into the table)
In below example, Importing JSON file of size 3.50 MB
Loading JSON document with OPENROWSET (BULK) & CROSS APPLY OPENJSON()