Share via

Unable to read the external Table (SQL Serverless) from SQL server Management Studio

Dhilip Subramanian 56 Reputation points
2022-04-14T03:54:53.537+00:00

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 read the external table with SQL server management studio.

192991-image.png

Can anyone advise what is the issue here? CSV file is located in the data lake gen 2. My table name is FactJobs

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.

Answer accepted by question author

  1. Vidya Narasimhan 2,126 Reputation points Microsoft Employee
    2022-04-14T14:46:27.553+00:00

    @Dhilip Subramanian please go through this link https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand

    As described there, common reasons are your Azure AD identity does not have the right RBAC permissions to access the file or maybe firewall is blocking the access.

    Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.