This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 18%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
I am trying to create an external data source in SQL Server to an Azure Storage account. I have created the database scoped credential, but when I execute the CREATE EXTERNAL DATA SOURCE command, I get this:
Msg 105080, Level 16, State 1, Line 7
105080;CREATE EXTERNAL TABLE failed because the URI contains an unsupported path, fragment, user info, or query. Revise the URI and try again.
My create statement looks like this (obviously I have provided the correct container and account, just making it generic here for the sake of security):
CREATE EXTERNAL DATA SOURCE Blob_CSV
WITH
(
LOCATION = 'abs://<container>@<account>.blob.core.windows.net/',
CREDENTIAL = BlobStorageCredential
);
So I am not sure why I am getting the error. I have essentially followed the instructions here:
Thanks in advance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't 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.
Did you include the angle brackets in the URI? Those are only mark that the values are placeholders.
No, as I stated in my initial post, those brackets in my code above is because i removed the container and storage account name for security purposes. My actual code does not contain angle brackets.
I look the external data source I have set up, and it looks slightly different:
CREATE EXTERNAL DATA SOURCE [testelitest_container] WITH
(LOCATION = N'abs://MyResourceGroup.blob.core.windows.net/testelitest', CREDENTIAL = [testelitest])
So there is no @ in it. Then again, when I added a @ in the middle of it that worked. I should add that this is on SQL 2022. My Polybase on SQL 2019 is broken.
Hmmm, I tried that and got the same error. I am using 2019.
So, I got it working on SQL Server 2022. No code changes, just copy / paste from one environment to the other. So I wonder what it is about 2019.
I think there is a quite simple answer. The URL in your original question ends in sql-server-ver16, and SQL 16 is SQL 2022. And this page says that it applies to SQL 2022 with no mention of earlier versions. So the abs interface is simply not available on SQL 2019. It seems that you can use wasb for blob storage on SQL 2019, but you may not get the direct CSV support. See https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=sql-server-ver15&tabs=dedicated.