10
Building the Serving Layer in Azure Synapse SQL Pool
As introduced in Chapter 8, Processing Data Using Azure Synapse Analytics, Azure Synapse Analytics comprises three key components – the Synapse integration pipeline to ingest and transform the data, the SQL pool and the Spark pool to process and serve the data, and Power BI integration to visualize the data. The SQL pool, the relational data warehouse engine, is usually the layer that maintains the processed data and will be used as the data serving layer consumed by reporting solutions. So, this chapter will focus on how to load processed data into a dedicated SQL pool and maintain dedicated SQL pools.
In this chapter, we will cover the following main topics:
- Loading data into dedicated ...
Get Azure Data Engineering Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
