英文:
Issue with Polybase-from synapse analytics DW on S3
问题
我正在尝试从Azure Synapse DW创建一个外部数据源到S3兼容的存储桶/存储空间。但是我收到了一个关于不支持的URI的错误。根据Microsoft的文档，Synapse Analytics支持S3兼容性。在成功创建了范围凭据之后，我尝试执行以下命令：
CREATE EXTERNAL DATA SOURCE s3_DSWITH( LOCATION = 's3://cloudstorage.com:443/', CREDENTIAL = S3_ECS);
错误消息 105007，级别 16，状态 1，第 6 行：不支持输入URI的方案。请修订以下方案并重试：'s3'。
英文:
I am trying to create an external data source from azure synapse DW to S3 compatible bucket/storage. But I am getting an error about the unsupported URI. As per the Microsoft documents, S3 is compatible from synapse analytics. After creating the scoped credential which was successful. I am trying to execute below command.
CREATE EXTERNAL DATA SOURCE s3_DSWITH( LOCATION = 's3://cloudstorage.com:443/', CREDENTIAL = S3_ECS);
Msg 105007, Level 16, State 1, Line 6Scheme of the input URI is not supported. Please revise the following scheme and try again: 's3'
答案1
得分: 0
我认为您正在提到这个链接，我正确吗？
https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-s3-compatible
它表示在SQL Server 2022本地版本中可用，但在Azure Synapse Analytics中不可用。
英文:
I think you're referring to this link, am I correct?
https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-s3-compatible
It says it is available in SQL Server 2022 on-premises, it is not available in Azure Synapse Analytics.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论