Exercise - Create pools in Azure Synapse Analytics

  • 9 minutes

To create an Azure Synapse Analytics pool, perform the following steps:

For Azure Synapse SQL pool

  1. Launch Azure Synapse Studio. The URL can be found in the Azure Synapse Workspace created in the Azure portal.

  2. In Azure Synapse Studio, navigate to the Management Hub in the left navigation by selecting the Manage icon.

    The Management Hub in Azure Synapse Studio

  3. Once in the Management Hub, navigate to the SQL pools section to see the current list of SQL pools that are available in the workspace.

  4. Select + New command and the new SQL pool create wizard will appear.

    The basics screen in the Create SQL Pool in Azure Synapse Studio

  5. Enter the following details in the Basics tab:

    • SQL pool name: SQLPool01
    • Performance level: DW100c

  6. In the next tab, Additional settings, select none to provision the SQL pool without data. Leave the default collation as selected.

    The additional settings screen in the Create SQL Pool in Azure Synapse Studio

  7. We won't add any tags for now, so next select Review + create.

  8. In the Review + create tab, make sure that the details look correct based on what was previously entered, and press create

    The review and create screen in the Create SQL Pool in Azure Synapse Studio

    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.

  9. Once the SQL pool is created, it will be available in the workspace for loading data, processing streams, reading from the lake, etc.

    The SQL Pool in Azure Synapse Studio

Azure Synapse Spark pool

  1. Launch Azure Synapse Studio. The URL can be found in the Azure Synapse Workspace created in the Azure portal.

  2. In Azure Synapse Studio, navigate to the Management Hub in the left navigation by selecting the Manage icon.

  3. Once in the Management Hub, navigate to the Apache Spark pools section to see the current list of Apache Spark pools that are available in the workspace.

    The Apache Spark Pool screen in Azure Synapse Studio

  4. Select + New and the new Apache Spark pool create wizard will appear.

  5. Enter the following details in the Basics tab:

    • Apache Spark Pool name: Sparkpool01
    • Node size: Small (4 vCPU / 32 GB)
    • Autoscale: Disabled
    • Number of Nodes: 8

    The basics screen in the Create Apache Spark Pool in Azure Synapse Studio

  6. In the next tab (Additional settings), leave all settings as defaults.

  7. We won't add any tags for now, so select Review + create.

  8. In the Review + create tab, make sure that the details look correct based on what was previously entered, and press Create.

    The review screen in the Create Apache Spark Pool in Azure Synapse Studio

  9. The Apache Spark pool will start the provisioning process.Once the provisioning is complete, the new Apache Spark pool will appear in the list.

    Viewing a Spark pool in the Apache Spark Pool screen in Azure Synapse Studio

Delete a pool.

  1. Navigate to the pools in the Management Hub in Synapse Studio. In this case Apache Spark

  2. Select the ellipsis next to the Apache pool to be deleted (in this case, Sparkpool01) to show the commands for the Apache Spark pool.

    Delete a pool in Azure Synapse Studio

  3. Press delete.

  4. Confirm the deletion, and press Delete button.

  5. When the process completes successfully, the Apache Spark pool will no longer be listed in the workspace resources.