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

Azure Synapse Analytics Develop Hub

Azure Synapse Analytics Studio Develop Hub offers a wide range of development options, from building Azure Data Factory data flows to building Power BI Reports.

Introduction to Azure Synapse Analytics Develop Hub

With the Develop Hub in Azure Synapse Analytics you can develop:

  • SQL Scripts
  • KQL Scripts
  • Power BI Reports
  • Apache Notebooks
  • Data Flows (Azure Data Factory)
  • Spark Job Definitions
Azure Develop Hub

To start with, let’s take a quick look at the different options.

SQL Scripts

You can develop SQL Scripts with IntelliSense and there are two different types of outputs:

  • Table
  • Chart

You will be able to execute your scripts using your SQL pool (on-demand or provisioned).

Table View

Develop Hub SQL Table


Develop Hub SQL Chart

Power BI Reports

It is possible to build and publish Power BI reports from Azure Synapse Analytics Workspaces. For building Power BI Reports you will need to create a linked service to your workspace. I suggest creating a new workspace for testing and data exploring purposes.

Build new reports and explore

With Azure Synapse Analytics you can create Power BI reports.

Power BI Develop Hub


Azure Synapse Analytics combines the best elements of Jupyter Notebooks or Databrick. You can create notebooks using any of your favorite languages:

  • Python
  • Scala
  • C#
  • Spark SQL

You will be able to execute the notebooks by using your Spark pools.

Develop Hub Notebooks

Data Flows (Azure Data Factory)

With Azure Data Factory mapping data flows you can create data transformation in a visual experience just by dragging and dropping! Additionally, Azure Data Factory pipelines still exist (they are part of the Orchestration hub).

Develop Hub Mapping Data Flows

Spark Job Definitions

Execute Spark Job definitions from Azure Synapse Analytics. The file definition needs to exist in the storage account. As you can see in the following picture, you will be able to execute definition files for different languages:

  • Python
  • Scala
  • C#/F#
Develop Hub Spark Job Definition

Final Thoughts

As we have seen, it is possible to develop everything without leaving Azure Synapse Analytics Studio, which is essential for getting actionable insights and solutions in a timely manner.

What’s next?

In my next post, we will explore some of the options within the different hubs in detail.

comment [ 0 ]
No tags 1

No Comments Yet.

Do you want to leave a comment?

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