Sample Header Ad - 728x90

PolyBase to CSV File

2 votes
0 answers
800 views
I'm trying to see if it's possible to create a PolyBase connection to a .CSV file. I'm using the Microsoft Access Text Driver and have set up a system DSN to the folder where the csv file is located. I'm able to query the file using OPENROWSET and the DSN, but when I try creating the external table, I'm getting the following generic error. Msg 105082, Level 16, State 1, Line 108 105082;Generic ODBC error: [Microsoft][ODBC Text Driver]Optional feature not implemented The file is just a simple one I created with three columns and two rows. Would it be possible to create a PolyBase connection to a .csv file? CREATE DATABASE SCOPED CREDENTIAL CSVFile WITH IDENTITY ='ident',SECRET='pass' CREATE EXTERNAL DATA SOURCE CSV WITH ( LOCATION = 'odbc://localhost' ,CONNECTION_OPTIONS = 'Driver={Microsoft Access Text Driver (*.txt; *.csv)};DSN=CSVs' ,CREDENTIAL = CSVFile ); CREATE EXTERNAL TABLE TestCSV ( Col1 VARCHAR(255) NULL ,Col2 VARCHAR(255) NULL ,Col3 VARCHAR(255) NULL ) WITH ( LOCATION = N'Test.csv', DATA_SOURCE = CSV ) GO
Asked by MrTCS (709 rep)
Nov 14, 2019, 05:16 PM
Last activity: Jan 7, 2024, 07:00 AM