Quickstart: Create a Data Explorer pool using Synapse Studio (Preview)

Azure Synapse Data Explorer is a fast, fully managed data analytics service for real-time analysis on large volumes of data streaming from applications, websites, IoT devices, and more. To use Data Explorer, you first create a Data Explorer pool.

This quickstart describes the steps to create a Data Explorer pool in a Synapse workspace by using Synapse Studio.

Important

Billing for Data Explorer instances is prorated per minute, whether you are using them or not. Be sure to shutdown your Data Explorer instance after you have finished using it, or set a short timeout. For more information, see Clean up resources.

If you don't have an Azure subscription, create a free account before you begin.

Prerequisites

Sign in to the Azure portal

Sign in to the Azure portal

  1. Navigate to the Synapse workspace where the Data Explorer pool will be created by typing the service name (or resource name directly) into the search bar.

    Azure portal search bar with Synapse workspaces typed in.

  2. 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.

    Listing of Synapse workspaces filtered to show those containing the name Contoso.

Launch Synapse Studio

From the workspace overview, select the Workspace web URL to open Synapse Studio.

Azure portal Synapse workspace overview with Launch Synapse Studio highlighted.

Create a new Data Explorer pool

  1. On the Synapse Studio home page, navigate to the Management Hub in the left navigation by selecting the Manage icon.

    Synapse Studio home page with Management Hub section highlighted.

  2. Once in the Management Hub, navigate to the Data Explorer pools section to see the current list of Data Explorer pools that are available in the workspace.

    Synapse Studio management hub with Data Explorer pools navigation selected

  3. Select + New. The new Data Explorer pool create wizard appears.

  4. Enter the following details in the Basics tab:

    Setting Suggested value Description
    Data Explorer pool name contosodataexplorer This is the name that the Data Explorer pool will have.
    Workload Compute optimized This workload provides a higher CPU to SSD storage ratio.
    Node size Small (4 cores) Set this to the smallest size to reduce costs for this quickstart

    Basics for Synapse Studio new Data Explorer pool

    Important

    Note that there are specific limitations for the names that Data Explorer pools can use. Names must contain lowercase letters and numbers only, must be between 4 and 15 characters, and must start with a letter.

  5. Select Next: Additional settings. Use the following settings and leave the defaults for the remaining settings.

    Setting Suggested value Description
    Autoscale Disabled We won't need autoscale in this quickstart
    Number of instances 2 Set this to the smallest size to reduce costs for this quickstart

    Advanced settings for Synapse Studio new Data Explorer pool

  6. Select Next: tags. Don't add any tags.

  7. Select Review + create.

  8. Review the detail making sure they are correct, and then select Create.

    The Data Explorer pool will start the provisioning process.

    Create Synapse Studio new Data Explorer pool

  9. Once the provisioning is complete, navigate back to the workspace and verify that the new Data Explorer pool appears in the list.

    Synapse Studio new Data Explorer pool list

Clean up Data Explorer pool resources using Synapse Studio

Use the following steps to delete the Data Explorer pool from the workspace using the Synapse Studio.

Warning

Deleting a data-explorer pool will remove the analytics engine from the workspace. It will no longer be possible to connect to the pool, and all queries, pipelines, and notebooks that use the deleted pool will no longer work.

Delete the Data Explorer pool

  1. Navigate to the Data Explorer pools in the workspace.

  2. To remove the Data Explorer pool (in this case, contosodataexplorer), select More [...] > Delete.

    Listing of Data Explorer pools, with the recently created pool selected.

  3. To confirm the deletion, enter the name of the pool being deleted and then select Delete.

    Confirm deletion of the recently created pool.

  4. Once the process completes successfully, verify that the pool no longer appears in the list.

Next steps