Chapter 8: Provisioning and Implementing an Azure Synapse SQL Pool

Azure Synapse Analytics is an integrated environment used to create data analytics platforms at scale. The SQL pools of Synapse Analytics are an ideal platform to implement star schema analytical databases at scale.

In this chapter, you will learn about Synapse Analytics. You will implement a star schema database using Synapse SQL pools. The following topics will be explained:

  • Overview of Synapse Analytics
  • Provisioning a Synapse Analytics workspace
  • Creating a Synapse SQL pool
  • Implementing tables in Synapse SQL pools
  • Understanding workload management
  • Using PolyBase to load data
  • Connecting to and using a dedicated SQL pool

Overview of Synapse Analytics

Synapse Analytics is a ...

Get Data Modeling for Azure Data Services 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.