2

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
J. Mini
  • 1,161
  • 8
  • 32
MrTCS
  • 709
  • 4
  • 14

0 Answers0