Blog Post

Azure Synapse Analytics Blog
2 MIN READ

Synapse Studio error while trying to read data from Storage Account using SQL On Demand

Liliam_C_Leme's avatar
Liliam_C_Leme
Icon for Microsoft rankMicrosoft
Jul 09, 2020
Error: File 'https://storageaccount.dfs.core.windows.net/parquettest/filename.snappy.parquet' cannot be opened because it does not exist or it is used by another process.   Scenario: Storage is w...
Updated Jul 10, 2020
Version 8.0
Synapse SQL
synapse studio
synapse support
siddharthamohapatra's avatar
siddharthamohapatra
Copper Contributor
Apr 15, 2021

Hi Liliam,

Thanks for the article.

The strange part in this set up is the RBAC access on the data lake. I was looking at a reader access to read the files.

If you know, can you confirm as why the contributor access needed to read files through SQL?

 

thanks

Sid