How to Create Azure Synapse Analytics

In this Azure tutorial, we will discuss how to create Azure synapse analytics. Along with this, we will also discuss Create Azure Synapse Analytics using PowerShell, Azure Synapse Studio, and how to open Azure Synapse Studio, etc.

To Create an Azure Synapse analytics workspace, Search for Azure Synapse Analytics in the Azure Portal –> Click on the + Create button from the Azure Synapse Analytics window.

Well, we can quickly create an Azure Synapse analytics workspace using Azure Portal. Before starting the actual functionality, we should know the prerequisites for creating Azure synapse analytics.

Prerequisites

You must have a valid Azure Account or an Azure Subscription. If you don’t have an Azure account, create a free Azure account now.

Assuming you are ready with the prerequisites, let’s start creating Azure synapse analytics using Azure Portal.

Create Azure Synapse Analytics

1. Log in to the Azure Portal (https://portal.azure.com/)
2. Once logged in to the Azure Portal, search for “Azure Synapse Analytics” and click on the search result “Azure Synapse Analytics”.

3. On the Azure Synapse Analytics window, click on the + Create button to create your Azure Synapse Analytics Workspace.

You can also click on the Create Synapse Workspace button to create the Workspace.

4. On the Create Synapse workspace window, fill in the below details.

• Subscription: Select a valid Azure Subscription that you want to use here.
• Resource Group: You can select your existing Resource Group, or If you don’t have an existing Resource Group, you can click on the Create new link to create a new Resource Group.
• Managed resource group: Provide the name for the Managed resource group.
• Workspace name: Provide a unique name for your Azure Synapse workspace.
• Region: Select the Region.
• Select Data Lake Storage Gen2: You can select the From subscription option. You can also do it manually via URL.
• Account name: Click on Create new ink and provide a name for your Data Lake Storage Gen2 account.
• File system name: For the File system name, Click Create new Iink and provide a name for the Data Lake Storage Gen2 file system.

Now, it will look like below.

Select or check the checkbox “Assign myself the Storage Blob Data Contributor role on the Data Lake Storage Gen2 account to interactively query it in the workspace.”.

Keep the other options as it is, and now click on the Review + create button.

Now, it will validate whether all the values entered are correct or not. If it finds all the values are perfect as per the terms and conditions, it will show a “Validation succeeded” message on the next screen, and the Create button will be enabled.

5. On the next screen, review all the details, including the pricing details, and finally, click on the Create button to create the Synapse workspace.

It might take a few minutes to create all the components associated with the Synapse workspace, and finally, it will show you “Your deployment is complete”.

Expand Deployment details to see all the components of the Synapse workspace.

So, we have created the Synapse workspace successfully.

Create Azure Synapse Analytics using PowerShell

You can also use Azure Synapse Analytics using Azure PowerShell, But before that, we should know the Prerequisites needed here.

Prerequisites

• You must have an Azure Data Lake Storage Gen2 storage account.

Follow the below steps quickly.

1. The first step is to install Az.Synapse Azure PowerShell module.

Install-Module -Name Az.Synapse

Once you run the above command, you will get the below pop-up. Click on the Yes to All button to install the Az.Synapse Azure PowerShell module.

On the successful installation of the Az.Synapse module, you will get the installation completed message.

2. As the next step, you must create a resource group using the Azure PowerShell cmdlet below.

$resourceGrp = 'Demo690'
$YourRegion = 'East US'
New-AzResourceGroup -Name $resourceGrp -Location $YourRegion