Azure synapse storage account in workspace creation

Question

Hi folks,

I know that for a synapse workspace a storage account in needed. I came to you asking for recommendation or best practices.

• Is this storage account (and container) using for handle workspace operation?
• Is a good practice to create a storage account only for workspace requirement and store/load de the data in another different data lake (storage account).

Thanks in advance and sorry for my English if I am not explaining myself correctly.

Regards
Fede

Answer 1

Hello @Federico Sardo ,

Thanks for the question and using MS Q&A platform.

A storage account is used to store data for a Synapse workspace, including both the data you load into the workspace and any files or artifacts that are generated by the workspace. In general, it is a good practice to create a separate storage account for your Synapse workspace to keep the data and resources for the workspace separate from other data and resources in your organization.

If you have a large volume of data that you want to store and analyze in your Synapse workspace, you may want to consider using a data lake (which is a type of storage account) to store the data. A data lake can store large amounts of structured and unstructured data at a lower cost than traditional relational databases. You can then use Synapse to access and analyze the data in the data lake.

It is also possible to use a data lake as the storage account for your Synapse workspace, but this may not be the best approach if you have a large volume of data and want to perform complex queries on the data. In this case, it may be more efficient to use a separate storage account for the workspace and use the data lake as a separate repository for storing and managing the data.

Overall, the choice of storage account for your Synapse workspace will depend on your specific requirements and the volume and type of data you are working with. It is a good idea to carefully consider your storage needs and choose a solution that is well-suited to your needs.

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

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

• Please don't forget to click on or upvote 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 jhow you can be part of Q&A Volunteer Moderators