ODBC guide

Read compressed JSON file

Reads a compressed JSON file (Zip or Gzip) from a SharePoint document library without downloading it to disk.

SELECT * from get_json_file
WITH(
	  DriveId='b!0zqXLXXJh0uUMzl-JXAd9Ztngc-5utVDqRyD2lKpD2535-11HLQTR5z4hOzmA7Q0'
	, FileId='root:/MyFolder/dump.json.zip:'
	--, FileId='01R65QTTRARZ42C4BN6FF2WOH3AONX4GUW' -- by ID (preferred)
  , Filter='$.store.books[*]' --or just blank (see help file for more filter examples)
  , FileCompressionType='Zip' --None, GZip, Zip
)