SQLTeam.com | Weblogs | Forums

Connect Polybase and S3

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...?