question

RakeshDhar-0664 avatar image
0 Votes"
RakeshDhar-0664 asked CarrinWu-MSFT commented

Connect S3 and polybase .

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

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RakeshDhar-0664, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

Hi .

I checked this ......This shows the connection with SQL Server .

i need to connect with S3

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT commented

Hi @RakeshDhar-0664,

Could you try this STEPS to connect S3 and polybase again?

If there has any other issues, please let us know.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Hi .

I checked this ......This shows the connection with SQL Server .

i need to connect with S3

0 Votes 0 ·

Hi @RakeshDhar-0664, sorry for the misunderstand. Is there an error message when you configured it? In addition, please check this link about how to connect S3 as an External Data Source using PolyBase

0 Votes 0 ·