question

SilvanoP-4597 avatar image
0 Votes"
SilvanoP-4597 asked ManasDasgupta-6315 commented

Cannot find the credential "https/datalake/file.parquet" because it does not exist or you do not have permission

Hello,

I'm using Synapse Serverless Pool and created a view with a query that access a parquet file stored in our data lake.

I'm the owner and I can run the view without issues using the On SQL on demand endpoint.

I would like now to create a user that can access the the SQL Endpoint and access the view?

Create a Sql Login gave reader permission, but maybe this is not enough since it cannot access the Azure Data Lake Storage.

Any idea?

Thanks

azure-synapse-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello:
Did you get this resolved?
I'm running into same issue.
Thanks.

0 Votes 0 ·

1 Answer

SamaraSoucy-MSFT avatar image
0 Votes"
SamaraSoucy-MSFT answered

The most common reason for this error is the user does not have the Storage Blob Data Contributor on the Storage account. This is required even if you have owner permissions on the account.

Please let me know if this solves the issue or if we need to go through some more troubleshooting.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.