ODBC guide

Read compressed CSV file (Zip/Gzip, streaming)

Gets a compressed CSV file (Zip or Gzip) without downloading to disk. Set FileCompressionType to Zip or GZip and supply FileId (path to the .zip or .gz file).

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

)