Actionable Data Analytics
Join Our Email List for Data News Sent to Your Inbox

Azure Synapse Analytics Manage Hub

Azure Synapse Analytics Studio Manage Hub allows you to manage your workspace within a single dashboard. It has many options, from creating linked services using connectors such as Power BI and Azure Data Lake to granting access to the platform.

The Synapse Analytics Manage Hub offers the following options:

  • Analytic Pools
  • SQL pools
  • Apache Spark pools
  • External Connections
  • Linked Services
  • Orchestration
  • Triggers
  • Integration runtimes
  • Security
  • Access control

SQL Pools

In this area, you can manage your previously created SQL pools or create new ones.

  1. You can execute SQL workloads by using any of the provisions forms:
  • On-demand: pay only for the execution time of the queries
  • Provisioned: pay a fixed price for the number of data warehouse units allocated to the services (you can scale out and scale back as requested).
  1. You can start and pause your provisioned SQL pools
  2. You can also create new SQL pools without leaving the Azure Synapse Analytics workspace

Manage Hub SQL Pools

Apache Spark Pools

It’s possible to create multiple instances of Spark pools depending on the workload requirements (1) and define the auto-pause rules to stop paying for resources (2).

Manage Hub Spark Pools

Linked Services

In the Linked Services section, you can create and manage connections to different services and design more to use when you develop datasets in Azure Synapse Analytics.

There are more than 85 connectors including Power BI, Oracle, Snowflake, HTTP, ODBC, and more.

The definition of linked services comes from Azure Data Factory.

Manage Hub Linked Services


Triggers enable you to manage when you execute your Azure Data Factory Pipelines.

The definition of triggers comes from Azure Data Factory, with options to execute workloads based on schedule, tumbling windows or an event.

Manage Hub Triggers

Integration Runtimes

The Integration Runtimes are the components where Azure Data Factory pipelines are executed. They close the gap between the activities in a pipeline and the linked services.

There are 3 main types of integration runtimes:

  • Azure: execute workloads between Azure services or Azure Data Factory Mapping Data Flows.
  • Self-Hosted: execute workloads between on-premises environments and Azure.
  • Azure-SSIS: execute SQL Server Integration Services packages in Azure Data Factory.

The definition of linked services comes from Azure Data Factory.

Manage Hub Integration Runtimes

Access Control

Azure Synapse Analytics comes with role-based access control.

You need to give users access to these roles before they can access Azure Synapse Analytics.

Some of the roles available are:

  • Workspace admin
  • Apache Spark admin
  • SQL admin

Manage Hub Access Control


Azure Synapse Analytics Manage Hub offers a central dashboard where you can manage your Azure Synapse Analytics workspaces, from starting and stopping SQL Pools to granting access to data experts.

For access control, I believe that it’d be great to see some more roles added to the service, not just admin roles.

What’s next?

During the next few weeks, we will explore the other Azure Synapse Analytics hubs and start to explore some of the features within Azure Synapse Analytics in detail.

Check out these other blog posts

Audit Databases with Data Classification and Power BI

comment [ 0 ]
No tags 0

No Comments Yet.

Do you want to leave a comment?

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

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.