Help. I'm currently doing the Exercise - Explore Azure Synapse Analytics and I'm encountering the following error:

Paul Nalzaro 40 Reputation points
2023-10-24T19:10:02.6933333+00:00

Help. I'm currently doing the Exercise - Explore Azure Synapse Analytics and I'm encountering the following error:

"Started executing query at Line 1

File 'https://datalakebw426yz.dfs.core.windows.net/files/product_data/products.csv' cannot be opened because it does not exist or it is used by another process.
Visit this article to learn more about this error

Total execution time: 00:00:01.420"

Link:

https://microsoftlearning.github.io/dp-203-azure-data-engineer/Instructions/Labs/01-Explore-Azure-Synapse.html

Im in 'Use a serverless SQL pool to analyze data' part

Thanks!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,557 questions
0 comments No comments
{count} votes

Accepted answer
  1. AnnuKumari-MSFT 31,731 Reputation points Microsoft Employee
    2023-10-25T10:14:07.0166667+00:00

    Hi Paul Nalzaro ,

    Welcome to Microsoft Q&A platform and thanks for posting your question here.

    As I understand your issue, you are trying to retrieve data from csv file using openrowset function using sql script in serverless sql pool . However, you are getting error :"The file can not be opened because it does not exist or it is used by another process" . Please let me know if that is not the concern.

    It seems your Microsoft Entra identity doesn't have rights to access the file or because a firewall is blocking access to the file. Kindly try to provide Storage Blob Data Contributor role on the storage account .

    storageblob

    In case you are still facing the issue, let me know, I will try to repro the excercise from my end as well.

    Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful