Quickstart: Create a Synapse SQL pool (preview) using the Azure portal
Azure Synapse Analytics offers various analytics engines to help you ingest, transform, model, and analyze your data. A SQL pool offers T-SQL based compute and storage capabilities. After creating a SQL pool in your Synapse workspace, data can be loaded, modeled, processed, and delivered for faster analytic insight.
In this quickstart, you learn how to create a SQL pool in a Synapse workspace by using the Azure portal.
If you don't have an Azure subscription, create a free account before you begin.
Sign in to the Azure portal
Sign in to the Azure portal
Navigate to the Synapse workspace
- Navigate to the Synapse workspace where the SQL pool will be created by typing the service name (or resource name directly) into the search bar. .
- From the list of workspaces, type the name (or part of the name) of the workspace to open. For this example, we'll use a workspace named contosoanalytics.
Create new SQL pool
In the Synapse workspace where you want to create the SQL pool, select New SQL pool command in the top bar.
Enter the following details in the Basics tab:
Setting Suggested value Description SQL pool name Any valid name Name of the SQL pool. Performance level DW100c Set to the smallest size to reduce costs for this quickstart
Note that there are specific limitations for the names that SQL pools can use. Names can't contain special characters, must be 15 or less characters, not contain reserved words, and be unique in the workspace.
Select Next: Additional settings.
Select None to provision the SQL pool without data. Leave the default collation selected.
Select Review + create.
Make sure that the details look correct based on what was previously entered. Select Create.
At this point, the resource provisioning flow will start.
After the provisioning completes, navigating back to the workspace will show a new entry for the newly created SQL pool.
After the SQL pool is created, it will be available in the workspace for loading data, processing streams, reading from the lake, etc.
Clean up resources
Follow the steps below to delete the SQL pool from the workspace.
Deleting a SQL pool will both remove the analytics engine and the data stored in the database of the deleted SQL pool from the workspace. It will no longer be possible to connect to the SQL pool, and all queries, pipelines, and notebooks that read or write to this SQL pool will no longer work.
If you want to delete the SQL pool, complete the following steps:
- Navigate to the SQL pools blade in the workspace blade
- Select the SQL pool to be deleted (in this case, contosowdw)
- Once selected, press delete
- Confirm the deletion, and press Delete button
- When the process completes successfully, the SQL pool will no longer be listed in the workspace resources.