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
Last activity: Jan 7, 2024, 07:00 AM