URL suffix not allowed for a query executed in a Synapse serverless SQL pool

Question

Hi,

I've a Synapse Analytics workspace and an ADLS gen2 storage account.

In the ADLS gen2 I've created a container, an inner directory and in the related path I've uploaded a csv file. My user has the Storage Blob data contributor for the ADLS gen2 and the Synapse Administratore role for the Synapse ws.

When I try to query the uploaded csv file I obtain the following error (Path ... has URL suffix which is not allowed):

In another Azure subscription, resource group, ADLS gen2 and Synapse ws I can run this query without any problems.

Any suggests to solve this issue, please? Many thanks

Answer 1

Hi pmscorca,

Thanks for reaching out to Microsoft Q&A.

The error, "URL suffix which is not allowed," occurs when the file path or the URL provided in the OPENROWSET function does not conform to the expected format in synapse serverless SQL pool. Since you are able to run the same query in another env without issues, this might be a configuration issue in your current env, possibly related to the security settings, access, or the format of the URL itself.

• Can you check if there are any specific configuration differences between the Synapse workspaces in the two environments?
• Ensure that the URL you're using follows the correct format. The URL should point directly to the file in ADLS and must be fully qualified.
• Ensure the path and filename are correct and match exactly, including case sensitivity

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.