ODBC guide

Read CSV file

Reads a CSV file from a SharePoint document library without downloading it to disk (streaming approach).

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