2. Introducing the Azure Synapse Analytics workspace and Synapse Studio
In the previous chapter, we introduced you to Azure and the types of platforms, tools, and resources that Azure provides to facilitate the creation of data warehouse solutions.
In this chapter, we will focus on the new unified experience in the Azure Synapse Analytics workspace and Synapse Studio. We will cover the following topics:
- Azure Synapse Analytics and why we need it
- Deep dive into Azure Synapse Analytics
- Introduction to the Azure Synapse Analytics workspace and a step-by-step quick start guide
- Introduction to Synapse Studio
- Two ways of launching Synapse Studio
- Provisioning an SQL pool, ingesting data, and analyzing the data in the SQL pool
- Creating an Apache Spark pool, ingesting data, and exploring data using Spark
- Copying data to/from SQL pools and Spark pools
- Linked data sources
- Analyzing data using serverless SQL pools
- Integrating with pipelines...