[spacer] [spacer] [spacer]

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

[mc4wp_form id="4946"] [spacer]

Azure Synapse Analytics Develop Hub

Posted on

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.

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

  • SQL Scripts
  • Power BI Reports
  • 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:

 

Develop Hub SQL Table

 

 

 

Chart:

 

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.

 

Develop Hub Power BI Linked Service

 

 

Build new reports and explore:

 

Power BI Develop Hub

Notebooks

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.

 

No Comments Yet.

Do you want to leave a comment?

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