Apr 13 2022 08:45 PM
Hi
I have my CSV file in the Azure data lake gen 2. I created an external table for this CSV file in SQL Serverless Pool and I am able to read the table in the Azure Synapse notebook. However, getting the below error when I tried to connect this external table with SQL server management studio.
I am unable to read the table. Can anyone advise what is the issue here? I have a csv file located in the data lake gen 2
Apr 27 2022 05:53 AM
SolutionHi, @JasonB35,
The error that is shown on linked thread is usually related to file permissions. Make sure that you have permissions on storage account and file itself. Query fails because file cannot be opened.
Bonus things to check:
May 31 2022 03:50 PM
Apr 27 2022 05:53 AM
SolutionHi, @JasonB35,
The error that is shown on linked thread is usually related to file permissions. Make sure that you have permissions on storage account and file itself. Query fails because file cannot be opened.
Bonus things to check: