How to Create Azure Synapse Analytics

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”.
Create 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.

create azure synapse analytics 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.
creating azure synapse analytics workspace
How to create azure synapse analytics workspace

Now, it will look like below.

Create Synapse workspace in Azure Portal

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.

Create synapse analytics workspace on Azure Portal

So, we have created the Synapse workspace successfully.

How do I create Azure synapse analytics

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

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.

Create Azure Synapse Analytics PowerShell

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

install Az.Synapse Azure PowerShell module

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

Once, you will execute the above script, you will get the below output on successful completion.

ResourceGroupName : Demo690
Location          : eastus
ProvisioningState : Succeeded
Tags              : 
ResourceId        : /subscriptions/1cdf4300-dee5-4518-9c9c-feaa72a5cbd1/resourceGroups
                    /Demo690

3. If you don’t have a storage account, you can create an Azure storage account using the below Azure PowerShell cmdlet.

$resourceGrp = 'Demo690'
$location = 'East US'

New-AzStorageAccount -ResourceGroupName $resourceGrp `
  -Name 'demostrgact' `
  -Location $location `
  -SkuName Standard_RAGRS `
  -Kind StorageV2

On the successful execution, you will get the output like below

StorageAccountName ResourceGroupName PrimaryLocation SkuName        Kind      AccessTi
                                                                              er      
------------------ ----------------- --------------- -------        ----      --------
demostrgact        Demo690           eastus          Standard_RAGRS StorageV2 Hot    

4. run the Azure Powershell script below to create the Azure Synapse Analytics workspace.

$SynapseWN = 'demoworkspace56'
$resourceGrp = 'Demo690'
$StorageAN ='demostrgact'
$FileSN = 'democtfile'
$MySqlUser = 'tsinfouser1'
$MySqlPassword = 'Hello@123'
$Region = 'East US'

$myCred = New-Object -TypeName System.Management.Automation.PSCredential ($SqlUser, (ConvertTo-SecureString $SqlPassword -AsPlainText -Force))

$MywpParams = @{
  Name = $SynapseWN
  ResourceGroupName = $resourceGrp
  DefaultDataLakeStorageAccountName = $StorageAN
  DefaultDataLakeStorageFilesystem = $FileSN
  SqlAdministratorLoginCredential = $myCred
  Location = $Region
}
New-AzSynapseWorkspace @MywpParams

Below are the parameter details

  • $SynapseWN = Your Azure Synapse Workspace name.
  • $resourceGrp = Your Resource Group name.
  • $StorageAN = The ADLS Gen2 storage account name you created above.
  • $FileSN = Your existing file storage name.

Once you run the above Azure PowerShell script, on the Successful creation of the Azure Synapse Workspace, you will get the output like below.

DefaultDataLakeStorage           : Microsoft.Azure.Commands.Synapse.Models.PSDataLakeS
                                   torageAccountDetails
ManagedResourceGroupName         : synapseworkspace-managedrg-68aac7b1-e5bf-44b2-8409-
                                   4aa31d3edc44
ProvisioningState                : Succeeded
SqlAdministratorLogin            : tsinfouser1
VirtualNetworkProfile            : 
Identity                         : Microsoft.Azure.Commands.Synapse.Models.PSManagedId
                                   entity
ConnectivityEndpoints            : {[web, https://web.azuresynapse.net?workspace=%2fsu
                                   bscriptions%2f1cdf4300-dee5-4518-9c9c-feaa72a5cbd1%
                                   2fresourceGroups%2fDemo690%2fproviders%2fMicrosoft.
                                   Synapse%2fworkspaces%2fdemoworkspace56], [dev, 
                                   https://demoworkspace56.dev.azuresynapse.net], 
                                   [sqlOnDemand, 
                                   demoworkspace56-ondemand.sql.azuresynapse.net], 
                                   [sql, demoworkspace56.sql.azuresynapse.net]}
ManagedVirtualNetwork            : 
PrivateEndpointConnections       : {}
WorkspaceUID                     : 6d7de4af-d4f0-4a2b-82ef-1726bd07a1e3
ExtraProperties                  : {[WorkspaceType, Normal], [IsScopeEnabled, False]}
ManagedVirtualNetworkSettings    : 
Encryption                       : Microsoft.Azure.Commands.Synapse.Models.PSEncryptio
                                   nDetails
WorkspaceRepositoryConfiguration : 
CspWorkspaceAdminProperties      : Microsoft.Azure.Commands.Synapse.Models.PSCspWorksp
                                   aceAdminProperties
PublicNetworkAccess              : Enabled
PurviewConfiguration             : 
Tags                             : 
TagsTable                        : 
Location                         : eastus
Id                               : /subscriptions/1cdf4300-dee5-4518-9c9c-feaa72a5cbd1
                                   /resourceGroups/Demo690/providers/Microsoft.Synapse
                                   /workspaces/demoworkspace56
Name                             : demoworkspace56
Type                             : Microsoft.Synapse/workspaces

You can see it here.

Create Azure Synapse Analytics using PowerShell

5. Now, to get the Azure synapse URL, you can execute the below Azure PowerShell script

$SynapseWN = 'demoworkspace56'
$resourceGrp = 'Demo690'
$MywsWebURL = (Get-AzSynapseWorkspace -Name $SynapseWN -ResourceGroupName $resourceGrp).ConnectivityEndpoints.web

$MywsWebURL contains the value for the Azure Synapse URL.

6. Access the Azure Synapse Workspace URL using the below command.

Start-Process $MywsWebURL

Once you will run the above command, the Azure Synapse Analytics Workspace will open in a new tab on your browser.

How to Create Azure Synapse Analytics using PowerShell

You might be thinking, what next?. Yes, it is Synapse Studio that comes into the picture now.

FAQs

How To Delete Azure Synapse Analytics Workspace

If you don’t want to keep the Azure Synapse Workspace, you can delete the workspace using PowerShell as well as using Azure Portal.

Using PowerShell

You can use the below Azure PowerShell script to delete the Workspace.

$SynapseWN = 'demoworkspace56'
$resourceGrp = 'Demo690'
Remove-AzSynapseWorkspace -Name $SynapseWN -ResourceGroupName $resourceGrp

Once you will execute the above script, click on the Yes button for confirmation on the next step.

Delete Azure Synapse Analytics Workspace using PowerShell

It will take a few seconds to delete the Azure Synapse Analytics Workspace.

Using Azure Portal

You can remove the Azure Synapse Analytics Workspace from the Azure Portal using the information below.

  1. Login to AzurePortal and navigate to the Azure Synapse Analytics Workspace.
  2. On the Synapse workspace page, click on the three dots from the right side –>
Remove Azure Synapse Analytics Workspace

You may also like following the articles below

Wrapping Up

In this article, we learned how to create Azure Synapse Analytics using Azure Portal and PowerShell, and along with that, we have also discussed Azure Synapse Studio and how to open Azure Synapse Studio, Delete Azure Synapse Analytics Workspace, etc. Hope you have enjoyed this article !!!