Through Azure Synapse analytics external tables of data in ADLS Gen2 inaccessible even after trying to access by Blob Storage Contributor role.

Riyaz 71 Reputation points
2022-09-07T14:03:04.293+00:00

Hi All, I am a newbie, I am trying to copy data from Azure Synapse Analytics wherein data format is comma separated value(.csv). Aftermath of multiple trails I am standing at the same point where I started. Here is following screen-shot for your reference and your thought-process solutions. ![238682-screenshot-2022-09-07-at-192858.png][1] [1]: /api/attachments/238682-screenshot-2022-09-07-at-192858.png?platform=QnA

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,462 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 31,716 Reputation points Microsoft Employee
    2022-09-08T09:08:11.71+00:00

    Hi @RiyazM ,

    Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

    As I understand your issue, you are trying to create an external table on top of a .csv file and are facing the above stated error.

    Kindly make sure to perform the following steps before creating the external table:

    Create External table script step is equivalent to what you are directly running via UI.

    For more details, Kindly check out the following video: External Tables with Synapse SQL in Azure Synapse Analytics

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators