question

SilvanoP-4597 avatar image
0 Votes"
SilvanoP-4597 asked SaurabhSharma-msft answered

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered

@silvanop-4597 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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered

@SilvanoP-4597 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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SilvanoP-4597 avatar image
0 Votes"
SilvanoP-4597 answered SaurabhSharma-msft commented

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@silvanop-4597 I will check internally with the products team and get back to you on your ask.

0 Votes 0 ·

@silvanop-4597 Could you please provide a concrete example of what temp area usage the you are referring to ? As mentioned earlier as each workspace has a different path prefix it should be fine.

0 Votes 0 ·
SilvanoP-4597 avatar image
0 Votes"
SilvanoP-4597 answered

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.