About this chapter: Synapse SQL

Synapse SQL is an important architectural component of Azure Synapse Analytics.

This chapter will cover a lot of ground about Synapse SQL and many important topics about it. It will share start with an overview of Synapse SQL architecture components and then discuss Dedicated Synapse SQL Pool as well as Serverless Synapse SQL Pool in detail.

This chapter will also cover massively parallel processing (MPP)
and distributed query processing (DQP) engines, as Dedicated and Serverless Synapse SQL use these engines, respectively

About the Book

• Covers Delta Lake and Data Lakehouse as intrinsic parts of Azure Synapse Analytics
• Includes use cases and reference architecture for Synapse Analytics
• Presents Synapse SQL best practices
• Provides details of Synapse SQL and Synapse Spark architecture and their main components

Like what you are reading, purchase the full ebook here.