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.
Table of Contents
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
- Log in to the Azure Portal (https://portal.azure.com/)
- 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.
- The first step is to install Az.Synapse Azure PowerShell module.
Install-Module -Name Az.SynapseOnce 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 $YourRegionOnce, 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
/Demo6903. 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 StorageV2On 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 @MywpParamsBelow 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.
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 $MywsWebURLOnce you will run the above command, the Azure Synapse Analytics Workspace will open in a new tab on your browser.
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 $resourceGrpOnce you will execute the above script, click on the Yes button for confirmation on the next step.
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.
- Login to AzurePortal and navigate to the Azure Synapse Analytics Workspace.
- On the Synapse workspace page, click on the three dots from the right side –>
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 !!!
I am Rajkishore, and I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machine, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.