Primary file system container not visible for a Synapse Analytics workspace

pmscorca 987 Reputation points
2024-09-02T13:44:05.9+00:00

Hi,

I'm working with a Synapse workspace and I've noticed that in Synapse Studio, Data --> Linked --> Azure Data Lake Storage Gen2, isn't visible the primary file system container. This container is also not visible in the related ADLS Gen2.

My Microsoft Entra user is a Synapse Administrator for the workspace, a Storage Blob data contributor for the related ADLS gen2 and an Azure Contributor for the related Azure resource group.

The Synapse ws has been created with an az synapse workspace create command, using an existing ADLS gen2 with the hierachical namespace enabled having no containers.

For another old workspace with analogue permissions I can see the related primary file system container.

I'd like to know the reason for a such different behaviour, please. 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,858 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 23,096 Reputation points
    2024-09-03T07:32:15.0766667+00:00

    When creating an Azure Synapse workspace, the primary file system container in the linked ADLS Gen2 is created automatically by the system. However, if this container wasn’t created properly due to a glitch or permissions issue, it may not be visible in Synapse Studio.

    Since you mentioned that the workspace was created using the az synapse workspace create command with an existing ADLS Gen2, it's possible that the creation process did not properly link or create the primary file system container.

Your answer

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