While we wait for Azure Synapse Analytics’ release for the general public, what information is already available about the new workspace experience?
Microsoft announced Azure Synapse Analytics back in November 2019. A select group of people gained access to its private version before another group became part of the current public preview. Even though I have access to the public preview, this post will focus on information available to the general public.
The service appears to be a one-stop-shop for analytics aimed at users of various levels. As someone who has been working in the data analytics space since 2011, I believe that Azure Synapse Analytics is going to be a game-changer.
A couple of clarifications:
1. Azure SQL Data Warehouse has been rebranded to Azure Synapse Analytics, but the new workspace experience is not yet available to the general public. The current GA (Generally Available) Azure Synapse Analytics component contains all the functionality that came from Azure SQL Data Warehouse.
2. Microsoft has released that the new experience will be through workspaces. There is some documentation already available on this topic. (Check this link)
The following image shows just how promising the service will be:
This picture gives us a lot of information about the features of Azure Synapse Analytics, but let’s take a closer look at the key components:
Azure Synapse Analytics Studio
This is where everything comes together, and it is our Azure Synapse Analytics Workspace presentation layer. This layer allows us to explore, develop, orchestrate, monitor and manage Azure Synapse Analytics, from Azure Data Factory Pipelines and Power BI reports to Notebooks.
Languages: the existing benefits of using SQL for coding will be available as well as the addition of Python, .NET, Java, Scala and R for users who are more comfortable using these languages.
Provisioned: Resources are already assigned to the service and running.
ON-Demand: Services for answering business questions are accessible just when you need them.
SQL: This is the current GA Azure Synapse Analytics (formerly known as Azure SQL Data Warehouse).
Spark: Adding Spark allows the service to run big data analytics workloads using Python, Scala, R and .Net.
Data Integration Layer
Azure Data Factory will be commonly used for data integration.
Azure Data Lake Storage
Taking advantage of the existing features of Azure Data Lake Storage and bringing Common Data Models (CMD) to the platform will help to reduce the gap between the Power Platform and Azure Data Services.
Without a doubt, Azure Synapse Analytics is exciting and should reshape the data analytics space.
While Microsoft hasn’t released the date for the next milestone (GA) yet, I feel confident that this announcement will happen sometime soon. Just by looking at when the information about creating the services was published, we can gain some insight. It’s also possible to track changes in GitHub: https://github.com/microsoft/azure-docs/commits/master/articles/synapse-analytics
In upcoming blog posts, you will find more information about this exciting service and the different components that make up the new workspace experience for Azure Synapse Analytics.