Quickstart: Create a Synapse workspace

In this Quickstart, you will create a Synapse workspace, and you can follow along with the rest of the tutorials to create a dedicated SQL pool, and a serverless Apache Spark pool.

Prerequisites

• If you don't have an Azure subscription, create a trial account before you begin.
• To complete this tutorial's steps, you need to have access to a resource group for which you're assigned the Owner role. Create the Synapse workspace in this resource group.

Create a Synapse workspace in the Azure portal

Start the process

1. Open the Azure portal, in the search bar enter Synapse without hitting enter.
2. In the search results, under Services, select Azure Synapse Analytics.
3. Select Create to create a workspace.

Basics tab > Project Details

Fill in the following fields:

1. Subscription - Pick any subscription.
2. Resource group - Use any resource group.
3. Managed Resource group - Leave this blank.

Basics tab > Workspace details

Fill in the following fields:

1. Workspace name - Pick any globally unique name. In this tutorial, we'll use myworkspace.
2. Region - Pick the region where you have placed your client applications/services (for example, Azure Virtual Machine, Power BI, Azure Analysis Service) and storages that contain data (for example Azure Data Lake storage, Azure Cosmos DB analytical storage).

Under Select Data Lake Storage Gen 2:

1. By Account name, select Create New and name the new storage account contosolake or similar as the name must be unique.

   Tip

   If you get an error reading "The Azure Synapse resource provider (Microsoft.Synapse) needs to be registered with the selected subscription", open the Azure portal and select Subscriptions. Select your subscription. Under the Settings list select Resource providers. Search for Microsoft.Synapse, select it, and select Register.

2. By File system name, select Create New and name it users. This will create a storage container called users. The workspace will use this storage account as the "primary" storage account to Spark tables and Spark application logs.

3. Check the Assign myself the Storage Blob Data Contributor role on the Data Lake Storage Gen2 account box.

Completing the process

Select Review + create > Create. Your workspace is ready in a few minutes.

Open Synapse Studio

After your Azure Synapse workspace is created, you have two ways to open Synapse Studio:

1. Open your Synapse workspace in the Azure portal, in the Overview section of the Synapse workspace, select Open in the Open Synapse Studio box.

2. Go to the https://web.azuresynapse.azure.cn and sign in to your workspace.

   

Place sample data into the primary storage account

We're going to use a small 100k row sample dataset of NYC Taxi Cab data for many examples in this getting started guide. We begin by placing it in the primary storage account you created for the workspace.

1. Download the NYC Taxi - green trip dataset to your computer:
   1. Navigate to the original dataset location from the link, choose a specific year and download the Green taxi trip records in Parquet format.
   2. Rename the downloaded file to NYCTripSmall.parquet.
2. In Synapse Studio, navigate to the Data hub.
3. Select Linked.
4. Under the category Azure Data Lake Storage Gen2, you'll see an item with a name like myworkspace ( Primary - contosolake ).
5. Select the container named users (Primary).
6. Select Upload and select the NYCTripSmall.parquet file you downloaded.

Once the parquet file is uploaded, it's available through two equivalent URIs:

• https://contosolake.dfs.core.chinacloudapi.cn/users/NYCTripSmall.parquet
• abfss://users@contosolake.dfs.core.chinacloudapi.cn/NYCTripSmall.parquet

Next steps