Can two Synapse Workspace share the same Primary ADLS Gen 2 account and Primary File system?

Silvano P 101 Reputation points
2021-03-29T19:01:11.533+00:00

Hello,

I have already created a Synapse Workspace and would like to create another one.

Is it possible to share the same Primary ADLS Gen 2 and Filesystem, or there can be conflicts?

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,346 questions
0 comments
Accepted answer
  1. Saurabh Sharma 23,671 Reputation points Microsoft Employee
    2021-03-31T16:49:14.27+00:00

    @Silvano P It won't cause any issues. Also, regarding your second ask - The file system is used as the default warehouse location for any tables created and stored in the Metastore. It’s also used as a temporary location by the DW connector to extract data.

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Saurabh Sharma 23,671 Reputation points Microsoft Employee
    2021-03-29T23:19:32.943+00:00

    @Silvano P I am able to create two synapse workspaces with same primary ADLS Gen2 account. I do not see any issues there in terms of the data stored by the system, each workspace has a different path prefix and so should be fine from that perspective. There might be other considerations that I may have missed.

    0 comments
  2. Silvano P 101 Reputation points
    2021-03-30T00:15:36.387+00:00

    Thanks for quick Answer!

    I know that there should not be any issue, but was just wandering since we specify the same ADSL Gen 2 account and the same filesystem, if Synapse uses the filesystem, as a temp area, and if having the same could have caused issue.

    So the question is what is the file system of the ADLS Gen 2 account used for?

    Thanks again

  3. Silvano P 101 Reputation points
    2021-03-31T15:31:33.12+00:00

    Hi,

    thanks for your feedback.

    When creating a Synapse Workspace you need to specify an ADLS Gen 2 and a filesystem. I'm referring to the filesystem if two workspace shares the same ADLS Gen2 and filesystem could this cause issues. I'm not sure what is the usage of the file system for. I thought it was used as a temp area for synapse, did you check internally?

    Thanks

    0 comments