Hello @Anonymous ,
Thanks for the question and using MS Q&A platform.
To resolve this issue, you need to have proper rights to access the file. Easiest way is to grant yourself
Storage Blob Data Contributor
role on the storage account you're trying to query.
If your query fails with the error saying, File cannot be opened because it does not exist or it is used by another process
and you're sure both file exist and it's not used by another process it means serverless SQL pool can't access the file. This problem usually happens because your Azure Active Directory identity doesn't have rights to access the file. By default, serverless SQL pool is trying to access the file using your Azure Active Directory identity.
- Visit full guide on Azure Active Directory access control for storage for more information.
- Visit Control storage account access for serverless SQL pool in Azure Synapse Analytics
For more details, see Query fails because file cannot be opened.
Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on
or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators