Edit

Quickstart: Create a Data Explorer pool using the Azure portal (Preview)

  • Article

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 article describes the steps to create a Data Explorer pool in a Synapse workspace by using the Azure portal.

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.

Create a new Data Explorer pool

  1. In the Synapse workspace where you want to create the Data Explorer pool, select New Data Explorer pool.

    Azure portal home page with Overview section highlighted.

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

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

    Setting Suggested value Description
    Scaling Manual scale We won't need autoscale in this quickstart
    Number count 2 Set this to the smallest size to reduce costs for this quickstart

    Advanced settings for Azure portal new Data Explorer pool

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

  5. Select Review + create.

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

    The Data Explorer pool will start the provisioning process.

    Create Azure portal new Data Explorer pool

  7. Once the provisioning is complete, navigate back to the workspace Overview page and verify that the new Data Explorer pool welcome page appears.

    Azure portal new Data Explorer pool list

Clean up Data Explorer pool resources using the Azure portal

Use the following steps to delete the Data Explorer pool from the workspace using the Azure portal.

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