Incorrect syntax near 'BLOB_STORAGE'.

Rahul Kumar 0

Hello,

I had created a Credential using the following Query. The credential got added successfully.

-- CREATE DATABASE SCOPED CREDENTIAL TradeGeekBlobCredential
-- WITH IDENTITY = 'SHARED ACCESS SIGNATURE',  
-- SECRET = 'MYSECRET';

Later, I am trying to add an external source to the Scope but it is giving me the a syntax error. How can i fix this? I am using SQL server-less pool with user defined database 'main'.

User's image

Vinodh247 28,386 Reputation points MVP

2025-02-26T13:37:42.11+00:00

can you try this and let me know?

CREATE EXTERNAL DATA SOURCE [tradegeek] WITH ( TYPE = HADOOP, LOCATION = 'https://tradegeek.blob.core.windows.net', CREDENTIAL = TradeGeekBlobCredential );
Erland Sommarskog 117.8K Reputation points MVP

2025-02-26T22:39:19.7433333+00:00
What product are you using? You have labelled the question Azure SQL Database, and when I test, I am able to run:

CREATE EXTERNAL DATA SOURCE [tradegeek] WITH ( TYPE = BLOB_STORAGE, LOCATION = 'http://tradegeek.blob.core.windows.net', CREDENTIAL = sture)

without any syntax error. (Since the credential does not exist, that gives me an error, but this means that the syntax is correct.)

From your screenshot, I would rather guess you are using Azure Synapse Analytics, where this syntax may not be supported.
Sai Raghunadh M 2,720 Reputation points Microsoft Vendor

2025-02-27T17:23:17.5566667+00:00

Hi @Rahul Kumar

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Incorrect syntax near 'BLOB_STORAGE'.

Your answer