ERWIN & BUSINESS ANALYTICS
Create an Azure Synapse Analytics SQL Pool
Adding a new SQL Pool
There are 2 options to create a SQL Pool. Go to your Synapse Workspace in de Azure Portal and add a new SQL Pool.
Or go to the Management Tab in your Azure Synapse Workspace and add a new Pool.
Creating a new SQL Pool
SQL Pool Name (SQL pool name should not be greater than 15 characters) and select the correct Performance Level. Be careful in selecting the Performance Level. DW 1000c will cost you € 12,73 per hour excluding storage. My advice is to start small and scale up when necessary. More about DWc units can be found here.
If you want to use Data from an existing pool, select Backup or Restore Point. Otherwise select none
Use existing data-Backup
Use existing data-Restore Point
Use existing data-None
Review your settings and your SQL Pool will be created.
Be aware that if you already have another Azure SQL DW running, you cannot select or add it to your Azure Synapse Workspace.
Adding an SQL pool is only possible via the Azure Synapse Workspace(Azure Portal or Studio).
If you install it as a standalone component through the Azure portal, the SQL Pool cannot be added to the Azure Synapse Workspace.
And if you don’t use your SQL pool please PAUSE it. It will save you a lot of money.