Beginning Azure Synapse Analytics: Transition from Data Warehouse to Data Lakehouse

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021

B. ShiyalBeginning Azure Synapse Analyticshttps://doi.org/10.1007/978-1-4842-7061-5_5

5. Synapse SQL

Bhadresh Shiyal¹  

(1)

Mumbai, India

 

Azure Synapse Analytics consists of multiple architectural components along with many tools and technologies. In the previous chapter, we discussed the Azure Synapse Analytics architecture and its main components in detail. During that discussion, we also briefly examined Synapse SQL as one of the important architectural components. In this chapter, we are going to discuss Synapse SQL in much more detail.

Synapse SQL is a core component of Azure Synapse Analytics, as it offers two different node-based architectures: Dedicated ...