Problem with Polybase Setup Between Azure Synapse Analytics DW and S3 Storage

Kyle1245 420 Reputation points
2024-12-08T04:41:23.4966667+00:00

I'm trying to configure an external data source in Azure Synapse Analytics Data Warehouse to connect to an S3-compatible bucket/storage. However, I’m running into an error related to an unsupported URI scheme. According to the Microsoft documentation, Synapse should support connections to S3, so I followed the steps and created the scoped credential successfully. When executing the following command, I get the error: Has anyone encountered this issue before or know how to fix it?

Msg 105007, Level 16, State 1, Line 6  
CREATE EXTERNAL DATA SOURCE s3_DSWITH( LOCATION = 's3://cloudstorage.com:443/', CREDENTIAL = S3_ECS); 
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
{count} votes

Accepted answer
  1. Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator
    2024-12-08T05:02:38.43+00:00

    Based on my understanding, S3 support for polybase is only for SQL server 2022 and not in synapse.

    Can you plz share the documentation which you are referring?


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.