Hi all,
I'll keep it short, I've created a new synapse workspace, linked it my existing Gen 2 Storage account (so its the primary), in the storage account is a container and in there is a sample parquet file.
My issue is in the Analytics studio when I select, develop, new SQL script and try and run the following
SELECT
TOP 100 *
FROM
OPENROWSET(
BULK 'https://x.blob.core.windows.net/containername/filename.parquet',
FORMAT='PARQUET'
) AS [result]
I'm getting back the following
File 'https://x.blob.core.windows.net/containername/filename.parquet' cannot be opened because it does not exist or it is used by another process. As far as I can see permissions for both me and the workspace on the container are good. I did try to change the connection to use a key rather than users but I'm not able to change it for the primary so I created a new linked service that does use, it tests fine.
So my questions are, am I missing anything obvious? and is there a way I can tell the above command to not use the primary storage and to use the one I created instead, so its using the key rather than the default of the primary.
Any help would be appreciated.
Thanks,
Nic
November 11, 2022 at 1:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Hi,
Answering my own question here but our Infra team turned on some Azure logging and it turned out my personal work account was being used but didnt have permissions on the container as that had the AD group I was in.
Seems it couldn't resolve that I was a member of the group and had permissions, adding me as a user resolved the issue and now it works.
Thanks,
Nic
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply