raikherrmann/synapsesetup

Synapse Workspace Setup & Access Control configuration

Synapse Bootcamp Setup

Synapse Workspace Setup & Access Control configuration

Azure Synapse environment

We need you to prepare some things for the upcoming Synapse Bootcamp. Since you are working as a team, you only need to deploy the needed Azure resources one time. To do so klick the button below. It will open the Azure portal. Make sure you are using the right subscription. On the screen you are seeing fill in the values as follows:

Field	Fill in
Resource group	press the Create new button and enter a name for your Resource group
Region	West Europe
Company Acronym	a three letter acronym for your company
SQL Administrator Login	enter admin name
SQL Administrator Login Password	enter admin password

Be aware that the SQL password should consist of uppercase letters, lowercase letters and digits (0-9). Any non-alphanumeric characters such as: !, $, #, or % will lead the deployment to fail.

If you are using a new subscription make sure all needed resource providers are registered. The following providers are needed: Microsoft.Logic, Microsoft.Storage, Microsoft.Insights, Microsoft.MachineLearningServices, Microsoft.KeyVault, Microsoft.Sql, Microsoft.DataFactory, Microsoft.DataLakeStore, Microsoft.Notebooks, Microsoft.Synapse.

Leave the rest as is. It will take around 10 minutes for the following deployment to create all resources.

Once the resources are deployed take a look at them.

You will find a Dedicated SQL pool that is named XXXwssql1 (XXXws/XXXwssql1). We want to pause this resource, since it will cost you otherwise. We did set it up to automatically pause at 6 in the afternoon, but since you potentially did this in the morning, let's pause it manually.
Select the dedicated SQL pool. In the detail view you will find the button Pause select it. It will ask you for confirmation. For a more detailed description look here.
Have a look at the permissions and make sure everything is set up to work with the given resources. Also make sure that your teammates are at least contributers on either the resource group your Azure services are residing in or on all the services themselves. Make sure everyone has the role of Storage Blob Data Contributor on the Azure Storage Account XXXdls - don't forget yourself. Go to the Azure Synapse workspace Studio. Under Manage select Access control. Add all your teammates as Synapse Administrator (this will make it easier for the bootcamp). Here you will find a more detailed description.
After that you are all set on the Azure environment.

Local environment

Now all participants need some tools to be able to properly work from their local machine.

Azure Storage Explorer One of the first exercises will be to copy raw data from an Azure public storage account to your Synapse workspace data lake. This will prepare the following exercises. The most efficient way to do this, is using Azure Storage Explorer. Download it from here and install it:
Azure Storage Explorer – cloud storage management

Azure Data Studio Azure Data Studio is a cross-platform database tool, running on Windows, macOS and Linux. You will be given different tasks concerning management and data access in Synapse SQL pools and Azure PostgreSQL. Download and install Azure Data Studio from here:
Azure Data Studio

SQL Server Management Studio This offers you management and data access to SQL server environments including Synapse serverless and dedicated SQL pools. It runs on Windows. Download and install it from here:
SQL Server Management Studio (SSMS)