Skip to content

Files

Latest commit

WilliamDAssafMSFTWilliamDAssafMSFT
20220204 1626
Feb 5, 2022
40dedf5 · Feb 5, 2022

History

History
73 lines (49 loc) · 4.34 KB

quickstart-deployment-template-workspaces.md

File metadata and controls

73 lines (49 loc) · 4.34 KB
title description services ms.service ms.subservice ms.topic ms.custom author ms.author ms.date
Quickstart: Create an Azure Synapse workspace Azure Resource Manager template (ARM template)
Learn how to create a Synapse workspace by using Azure Resource Manager template (ARM template).
azure-resource-manager
synapse-analytics
workspace
quickstart
subject-armqs, mode-arm
WilliamDAssafMSFT
wiassaf
02/04/2022

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.

[!INCLUDE About Azure Resource Manager]

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.

Deploy to Azure 1

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.

Visualize

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.

    Deploy to Azure 2

  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,

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