Hi all ,
i am trying to connect the Polybase with the S3 . I need to read the .csv files from the .csv .
I am trying to create the external data source in the polybase, but it is not connecting the same
CREATE EXTERNAL DATA SOURCE cdata_amazons3_source
WITH (
LOCATION = 's3://test-dummylocation\CyclePolybase.csv',
CONNECTION_OPTIONS = 'DSN=test_dsn',
-- PUSHDOWN = ON | OFF,
CREDENTIAL = amaz_Test
);
CREATE DATABASE SCOPED CREDENTIAL amaz_test
WITH IDENTITY = 'username', SECRET = 'password';
is this the correct way ..or something else i need to connect the S3 and polybase...?