ODBC guide

Read compressed CSV file

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

SELECT * from get_csv_file
WITH(
	  DriveId='b!0zqXLXXJh0uUMzl-JXAd9Ztngc-5utVDqRyD2lKpD2535-11HLQTR5z4hOzmA7Q0'
	, FileId='root:/MyFolder/dump.csv.zip:'
	--, FileId='01R65QTTRARZ42C4BN6FF2WOH3AONX4GUW' -- by ID (preferred)
	
	--, ColumnDelimiter=',' --{LF}, {TAB}, | , \x0009 ... default is comma (",")
	--, HasColumnHeaderRow=0 --set for header less file
	--, FileId='root:/MyFolder/dump.csv.gz:'
	, FileCompressionType='Zip' --None, GZip, Zip
)