Quickstart: Create an Azure Synapse workspace using an ARM template

This Azure Resource Manager (ARM) template will create an Azure Synapse workspace with underlying Data Lake Storage. The Azure Synapse workspace is a securable collaboration boundary for analytics processes in Azure Synapse Analytics.

An Azure Resource Manager template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax. You describe your intended deployment without writing the sequence of programming commands to create the deployment.

If your environment meets the prerequisites and you're familiar with using ARM templates, select the Deploy to Azure button. The template will open in the Azure portal.

Prerequisites

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

To create an Azure Synapse workspace, a user must have Azure Contributor role and User Access Administrator permissions, or the Owner role in the subscription. For detailed steps, see Assign Azure roles using the Azure portal.

Review the template

You can review the template by selecting the Visualize link. Then select Edit template.

The template defines two resources:

• Storage account
• Workspace

Deploy the template

1. Select the following image to sign in to Azure and open the template. This template creates a Synapse workspace.

   

2. Enter or update the following values:

   • Subscription: Select an Azure subscription.
   • Resource group: Select Create new and enter a unique name for the resource group and select OK. A new resource group will facilitate resource clean up.
   • Region: Select a region. For example, Central US.
   • Name: Enter a name for your workspace.
   • SQL Administrator login: Enter the administrator username for the SQL Server.
   • SQL Administrator password: Enter the administrator password for the SQL Server.
   • Tag Values: Accept the default.
   • Review and Create: Select.
   • Create: Select.

3. Once deployed, additional permissions are required.

• In the Azure portal, assign other users of the workspace to the Contributor role in the workspace. For detailed steps, see Assign Azure roles using the Azure portal.
• Assign other users the appropriate Synapse RBAC roles using Synapse Studio.
• A member of the Owner role of the Azure Storage account must assign the Storage Blob Data Contributor role to the Azure Synapse workspace MSI and other users.

Next steps

To learn more about Azure Synapse Analytics and Azure Resource Manager,

• Read an Overview of Azure Synapse Analytics
• Learn more about Azure Resource Manager
• Create and deploy your first ARM template

Next, you can create SQL pools or create Apache Spark pools to start analyzing and exploring your data.