[spacer] [spacer] [spacer]

Sign up with your email address to be the first to know about new publications

[mc4wp_form id="4946"] [spacer]

Create Your First Azure Synapse Analytics Workspace

This blog post outlines the steps to follow to create an Azure Synapse Analytics Workspace using the Azure portal.

Let’s take a closer look at this surprising service.

Create an Azure Synapse Analytics Workspace

Firstly, register the resource provider if it is not already registered.

Then, proceed to find the service:

Basic Configuration

  1. Project details 

  • Select the subscription and the resource group where you’d like to create an Azure Synapse Analytics Workspace.
  1. Workspace details

  • Workspace name: surprisingly we cannot use the naming convention highlighted by Microsoft (syn-), so we will stick with synws (Synapse Workspace).
  • Region: select the region where you want to host your service. Microsoft will add more regions soon.
  • Select Data Lake Storage Gen2: use an existing account in your subscription, external subscription or create a new one. After the creation of an Azure Synapse Analytics Workspace, it will add permissions directly to the storage account.

Naming limitations

Storage account permissions (added automatically after the creation of the service)

Security + Networking

1. SQL Administrator credentials:

Create SQL Server credentials for the SQL pools

2. Workspace managed identity: 

Automatically add managed identity permissions for your SQL pools and SQL on-demand

3. Allow connections from all IP addresses: 

Lastly, make sure you disable this option (if it is enabled by default). We will come back to it once the service is created. You don’t want to allow connections from all IP addresses to access your Azure Synapse Analytics workspace.

Tags

Make sure you create/include some tags that facilitate the administration.

Summary

Below is the last screen before we create an Azure Synapse Analytics Workspace!


Access

Once an Azure Synapse Analytics Workspace is created, use the service by accessing the workspace URL:

After that, you will find you don’t have access. This is because firewall rules control access to the workspace.

Finally, add your company public IP or your client IP address to the firewall rule exceptions:

Now, if we access the link for Azure Synapse Analytics Workspaces, you will have full access:

Final thoughts

From start to finish, creating a workspace only takes about 6 minutes and is quite user-friendly. During the next few months, Microsoft will continue to expand the documentation available on Azure Synapse Analytics.

Additionally, you can also create the service using Power Shell (I haven’t tested it).

No Comments Yet.

Do you want to leave a comment?

Your email address will not be published. Required fields are marked *