As part of a multi-year project to re-architect the query processing framework in the SQL DW parallel data warehouse services the POLARIS distributed query engine was developed. If you work with Azure Synapse Analytics and analytical workloads then this session is for you. We will review our new architecture for Generation 3 Provisioned Pools and SQL Serverless Pools. We will demonstrate how to resize live workloads, deliver predictable performance at scale, and how to effectively handle unstructured and relational data.

You will learn:

• About the underlying architecture changes for Generation 3 Provisioned & Serverless Pools
• Demonstrate using Serverless Pools to read unstructured data
• Demonstrate auto scale up and scale out multi-clusters